Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I running a MySql DB at a webhosting company. The size limit of a schema/DB is set to 100Mb.

I'm using temporary tables in my query like:

CREATE TEMPORARY TABLE t_foo
SELECT * FROM Foo INNER JOIN Bar ON Foo.bar_id = Bar._id

Will that effect the size of a schema in a way that is detectable or does the result of temporary tables got saved somewhere else?

I understand that temporary tables reside in memory as long as the size is less then max_tmp_tables and max_heap_table_size. I know that there is possible to force MySql to keep the entire temporary table in memory by using the following:

CREATE TEMPORARY TABLE test.temp_table_memory (x int) ENGINE=MEMORY;

Maybe keeping the temporary table in memory is the way to go if I don't want to hit the ceiling?

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.