From inside the MySQL CLI:
show status like ‘qc%’;
It will produce output like this:
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)
