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
add comment

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.