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_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?