Surf 11 » How To Check if MySQL Query Caching is Turned On

Finding the best waves on the web.

Need to know if the query cache is turned on in MySQL? Simply run the following SQL statement:

SHOW VARIABLES LIKE 'query_cache_type';

If the query cache is turned on it should look something like this:

mysql> SHOW VARIABLES LIKE 'query_cache_type';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| query_cache_type | ON    |
+------------------+-------+

More info on: query caching in MySQL.



Related Entries
Name:

Email: (optional, not displayed on site)
   Subscribe to this thread
Comments: (html will be escaped)



Subscribe to our RSS Feed: subscribe to this feed XML
Archives   Tags   Contact