Optimise query cache efficiency
from the Artful MySQL Tips List
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.
Return to the Artful MySQL Tips page