Knowledgebase


Portal Home > Knowledgebase > Hosting FAQ's > How to check MySQL query caching status on your linux server?

How to check MySQL query caching status on your linux server?

Login to your server as root.

 

On mysql prompt fire the following command:

 

mysql> SHOW VARIABLES LIKE ‘%query_cache%’;

 

This will result the table as follows :

+——————————+———–+
| Variable_name | Value |
+——————————+———–+
| have_query_cache | YES |
| query_cache_limit | 1248376 |
| query_cache_min_res_unit | 3496 |
| query_cache_size | 134576828 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
+——————————+———–+
6 rows in set (0.20 sec)

 

query_cache_type will be set to ON or OFF as required.


Also Read