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
. 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
the Artful MySQL Tips page