Tag: query cache

Query Cache in MySQL

Query Cache in MySQL

October 5, 2010 | By | Add a Comment

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. […]

Read More