Invalidating query cache mysql

Rated 4.25/5 based on 988 customer reviews

It may seem counterintuitive, but for some types of applications, the query cache, especially if set to be large, can reduce performance.

However, the query cache is only useful in certain scenarios.After the caching, results will be set in a memory cache like memcached or cassandra.The query caching is normally used with the content caching.For My SQL, there is a general query cache which can help tremendously.The My SQL is one of the important feature in My SQL and an inevitable part of query optimization.

Leave a Reply