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
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