TrianglePHP Message Board › query_cache_type vs. tmp table variables
I just wanted to understand how these variables query_cache_type, tmp_table_size, max_heap_table_size, memory temporary tables influence each other?
In a replicated environment where query_cache_type is enabled and the tmp_table_size (64MB) and max_heap_table_size ( 1GB) the number of memory temporary tables created over a period of half-an-hour is around 2000.
Whereas if query_cache_type is disabled and the tmp_table_size(64 MB) and max_heap_table_size 91 GB) the number of temporary tables created over a period of half-an-hour is around 6000.
Can anyone please let me know what would be the explanation for the above?
Should I bring down values of tmp_table_size and max_heap_table_size?