Friday, March 14, 2008

How can I check how my query cache is working

From inside the MySQL CLI:
show status like 'qc%';
It will produce output like this:

mysql> show status like 'qc%';
mysql> show status like 'qc%';
+-------------------------+----------+
Variable_name Value
+-------------------------+----------+
Qcache_queries_in_cache 9741
Qcache_inserts 49905222
Qcache_hits 60496383
Qcache_lowmem_prunes 137163
Qcache_not_cached 181538
Qcache_free_memory 56155320
Qcache_free_blocks 4623
Qcache_total_blocks 24533
+-------------------------+----------+
8 rows in set (0.00 sec)

No comments: