| How can I check if query cache is working on my MySQL server? | |||||||||||||
From inside the MySQL
CLI: It will produce output like this: +-------------------------+----------+ | Variable_name | Value | +-------------------------+----------+ | Qcache_queries_in_cache | 68241 | | Qcache_inserts | 22305222 | | Qcache_hits | 60296383 | | Qcache_lowmem_prunes | 147163 | | Qcache_not_cached | 081538 | | Qcache_free_memory | 91055320 | | Qcache_free_blocks | 8663 | | Qcache_total_blocks | 14233 | +-------------------------+----------+ 8 rows in set (0.00 sec) |
|||||||||||||
Last update: March 21st, 2010 ••• Copyright © 2004-2010 ServerTune Inc.

