Invalidating query cache entries key mysql
I ran SHOW STATUS LIKE "Qcache%" and the results were: Qcache_free_blocks 6941 Qcache_free_memory 23490288 Qcache_hits 253269763 Qcache_inserts 368937684 Qcache_lowmem_prunes 57410566 Qcache_not_cached 9872266 Qcache_queries_in_cache 35275 Qcache_total_blocks 84877 I don't really know what those things mean or if they are even useful in determining whether or not I need to reset the cache. The manual didn't lie to you, any queries which alter data in a table invalidate any cache entries that reference that table. If your data is updated so often that queries would never last in the cache, or the same query is run so infrequently that it's not useful to cache it, then you're just wasting huge amounts of memory and CPU time checking and invalidating cache entries on every Is there a way to turn off the query cache just for selected tables?
90% of my tables are updated so often that they wouldn't need query cache, but the other 10% might never be updated, so query cache might be useful for them.
Since then the replication process lags a lot behind the master with the line in the process list of: invalidating query cache entries (table).
the global Were the size and type set to 0 when the server was started, or later?
I haven't touched anything such as reseting query cache for the year that the game has been up, I'm working with about 5000-1million rows depending on the table.
Everything is being updated constantly and things being inserted into the tables.
If I understand correctly, every insert or update will clear the cache for that table?
After review, it may be pushed to the relevant source trees for release in the next version.If you set it to on demand, then you have to explicitly state which queries you want cached when you issue them.