ServerTune Logo Dedicated Servers Colocation VPS Server Management ServerTune.com
 
ServerTune HomeAbout usContact usHelp DeskKnowledgebaseSpecialLIVE Chat ServerTune
DirectAdmin VPS Server Management

Value, Power, and Performance :: Dedicated Servers starting $89 /month

Dedicated Server Hosting

Click here to view photos from the conferences we attended.   *** Follow ServerTune on: ServerTune is on Facebook ServerTune is on Twitter
 
Browse by category   Search
 


How can I check if query cache is working on my MySQL server?
Printer Friendly
email to a friend
Email to friend
Add comment Add comment
Views: 1518
Votes: 0
Comments: 0
Posted: 09 Jul, 2007
by: Customer Service :: S.
* * * * *
Updated: 09 Jul, 2007
by: Customer Service :: S.

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)
Other articles in this Category
document I see hundreds of mysql-bin.00xxxxxxx files in /var/lib/mysql directory. What are these files?
document Starting MySQLCouldn't find MySQL manager or server
document HowTo :: commands, statements, and clauses
document HowTo :: change MySQL root password
document Got a packet bigger than 'max_allowed_packet' bytes
document MySQL :: HowTo fix Access-Denied Errors
document Warning: MySQL server has gone away
document Error :: Can't connect to [local] MySQL server
document Who is exhausting MySQL resources on my server?



RSS

Control Panel Licensing
cPanel Plesk Miva Merchant