Hi there,

I'm trying to enhance and develop my skills in MySQL and wondered what the difference was between the two: query_cache_type 1 and 2?

I can't get my head around it!

Cheers,
Sue

Hi Sue,

there are 3 possible settings:

0 - off
1 - on for all queries that except those that explicitly state not to cache the query and the results. SELECT SQL_NO_CACHE ...
2 - off except for queries that explicitly state to be included in the query cache. SELECT SQL_CACHE ...

Ronan

I have created a small demo to show the performance differences using the caching behaviour on MySQL. I created a table with 1,000,000 records and then attempted to group these. The query without caching takes approximately 1.75 seconds on my hardware platform but when caching is enabled the first iteration of the SQL takes 1.75 but subsequent queries takes 0.008 seconds. If you want a complete read of the post check it out here:

MySQL – query_cache_type IT Integrated Business Solutions