TrianglePHP Message Board › query_cache_type vs. tmp table variables

query_cache_type vs. tmp table variables

Revathi
masrrev
Bangalore, IN
Post #: 1
Hi

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?

Thanks
Revathi R
Powered by mvnForum

Our Sponsors

  • TEKsystems

    Meeting space and refreshments

  • indieconf 2013

    $20 discount off indieconf 2013 - use code TRIANGLEPHP to save today!

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy