I ran the following sql against MySQL:
SHOW STATUS LIKE 'Qcache%';
Here is what I got:
Qcache_free_blocks 0
Qcache_free_memory 0
Qcache_hits 0
Qcache_inserts 0
Qcache_lowmem_prunes 0
Qcache_not_cached 0
Qcache_queries_in_cache 0
Qcache_total_blocks 0
I don't understand why I get this because I did double-check that the query cache is properlty enabled as follows:
SHOW VARIABLES LIKE 'have_query_cache';
Variable_name Value
have_query_cache YES
Can anyone please help?
Have you read the MySQL Query Cache Configuration page?
E.g.
or