show status like 'qcache%';compute the ratio
Qcache_hits/Qcache_inserts. A ratio < 5 indicates poor reuse. A ratio < 1 indicates no reuse at all---the cache should probably be disabled.Last updated 16 Jul 2013
A good measure of query cache efficiency is the average reuse rate of query results. From ...
show status like 'qcache%';compute the ratio Qcache_hits/Qcache_inserts. A ratio < 5 indicates poor reuse. A ratio < 1 indicates no reuse at all---the cache should probably be disabled.Last updated 16 Jul 2013 |
|