How to check MySQL query caching status?

1. First of all, you have to log in as root using SSH on the server.

2. Now, open MySQL prompt and run this command:

mysql> SHOW VARIABLES LIKE '%query_cache%';

This will give a tabular result like:


---------------------------------------------
| Variable_name | Value |
---------------------------------------------
| have_query_cache | YES |
| query_cache_limit | 2097152 |
| query_cache_min_res_unit | 8192 |
| query_cache_size | 268435456 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
---------------------------------------------
6 rows in set (0.01 sec)


query_cache_type will be set to ON or OFF as required.
Was this answer helpful? 0 Users Found This Useful (0 Votes)