ServerTune

Browse by category

Search    |    Advanced search

How can I check if query cache is working on my MySQL server?

From inside the MySQL CLI:
show status like 'qc%';

It will produce output like this:
show status like 'qc%';

+-------------------------+----------+
| 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)
 
 
Add comment
 
Views: 814
 
Votes: 0
 
Comments: 0
 

Other articles in this Category

RSS