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.

Last updated 16 Jul 2013

Return to the Artful MySQL Tips page