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

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

Archives   Tags   Contact