Wednesday, September 10, 2008

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.

Labels:

0 Comments:

Post a Comment

<< Home