Search: Advanced search |
Browse by category: |
| 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: August, 2008 ••• Copyright (c) 2004-2008 ServerTune Inc.