MySQL query cache is enabled but not being used

Posted by Yoga on Server Fault See other posts from Server Fault or by Yoga
Published on 2014-06-05T07:55:58Z Indexed on 2014/06/05 9:29 UTC
Read the original article Hit count: 223

Filed under:
|

I've checked the query cache is enabled

mysql> SHOW VARIABLES LIKE 'have_query_cache';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| have_query_cache | YES   |
+------------------+-------+
1 row in set (0.00 sec)

But seems it is not being used

mysql> SHOW STATUS LIKE 'Qcache%';
+-------------------------+----------+
| Variable_name           | Value    |
+-------------------------+----------+
| Qcache_free_blocks      | 1        |
| Qcache_free_memory      | 16759648 |
| Qcache_hits             | 0        |
| Qcache_inserts          | 0        |
| Qcache_lowmem_prunes    | 0        |
| Qcache_not_cached       | 21555882 |
| Qcache_queries_in_cache | 0        |
| Qcache_total_blocks     | 1        |
+-------------------------+----------+
8 rows in set (0.00 sec)

Any reason?

© Server Fault or respective owner

Related posts about mysql

Related posts about mysql5.5