VPS
Main PagecPanel and DirectAdmin LicensingServer Management PlansVirtual Private ServersDedicated Servers
Control Panel Licensing
ServerTune ResellersResellersSpecial PromotionsServerTune SpecialsHomeAbout ServerTuneContact usTechnical SupportKB
ServerTune Main Page
Space
Space
Our most popular products:

SPECIAL PROMOTION: cPanel License $36 /month. more info

Issues, Tips, and Solutions

Protect your server with Mod Security rules written specifically for your system. more info ...

Space
Search:    Advanced search
Browse by category:
How can I check if query cache is working on my MySQL server?
Printer Friendly
email to a friend
Add comment Add comment
Views: 527
Votes: 0
Comments: 0
Posted: 09 Jul, 2007
by: Support T.
* * * * *
Updated: 09 Jul, 2007
by: Support T.

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



RSS