NEW VPS Plans

ServerTune provides -- managed and un-managed -- VPS hosting solutions at affordable prices to accommodate your personal and/or businesses needs.

Click here for more info ...

NEW VPS Plans

Click to hideClick to view
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:
mysql> 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)
Printer Friendly
 
email to a friend
Email to friend
 
Add comment
Add comment
 
Views: 1923
 
Votes: 0
 
Comments: 0
 
Posted: 09 Jul, 2007 by: Customer Service S.
Updated: 08 Mar, 2011 by: Customer Service S.

Other articles in this Category

Article
Article
Article
Article
Article
Article
Article
Article
Article
Article
Article
RSS