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