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%’;
+————————————-+—————+
| 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)
Your rating: None Average: 2 (1 vote)