Qcache_not_cached should be small

If not, you’re wasting overhead on checking and invalidating the query cache, for a large/busy query cache, it gets more expensive. Thus, the lesson is to know which query should not be cached and explicitly use “SELECT SQL_NO_CACHE …” in your SQL statement. It means tables with many UPDATES/INSERTS should not use query caching.


Posted

in

by

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *