MySQL Tuning: Disable Query Cache on Frequently Updated Databases

April 26, 2007

It may seem counterintuitive, but for some types of applications, the query cache, especially if set to be large, can reduce performance. MySQL’s query cache stores the results of previously executed queries. In theory, the cache exists to speed up your application by responding to the same query with results directly from memory instead [...]