Query Cache in MySQL

October 5, 2010 | By

Hi frinds,

MySQL stores every SQL text and result of same in memory. When identical SQL text executes again that time MySQL retrive data from CACHE and provide output. Indeed memory scan is more faster than disk scan.

This CACHE called as QUERY CACHE.

For enabling Query Cache in MySQL.
Modify my.cnf with following parameters.

Set query_cache_type = 0 means it is disabled
Set query_cache_type = 1 means it is enabled
Set query_cache_type = 2 means it is enabled but works on demand

Another parameter is query_cache_size. This parameter stands for total size of Query Cache.
for better performance we can set it to 25MB. Modify this parameter in my.cnf and put bytes.

Thanks and regards,

Remote Assistance DBA team

Be Sociable, Share!

Tags: , , , , ,

Category: blog, blogging, remote dba, remote dba service, software, technology

Comments are closed.