… was a cache miss storm – situation which can happen with memcache (as in this case) as well as with query cache. If you… this problem ? You should carefully watch frequently accessed cache items as well as cache items which take long to generate in case… hot cache entries which cause the problem. So if your server has seemingly random spikes of activities check this out – cache miss storm…
Post: MySQL caching methods and tips
April 4, 2011 By 5 Comments
… some of the most common cache methods for MySQL. Popular cache methods The MySQL query cache When the query cache is enabled, MySQL examines… time. Another problem which can occur is the “cache stampede” aka a “miss storm“. This happens when multiple requests need data for…, and multiple cache entries may be invalidated by a single table change. Peter’s advice in the miss storm blog post suggests…
Post: More on dangers of the caches
September 23, 2010 By 5 Comments
… queries… which corresponded to cache miss storm but why it was not problem before ? The answer lies in caching as well. When software… gradually recover by populating cache – if because of cache misses performance is so bad the speed of populating cache with new items is… done outside of the time window allowed. Know your Cold Cache Performance and Behavior Know how your application behaves with cold…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
… = 4 innodb_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the buffer… then that, I have also disabled query cache to avoid contention caused by query cache on write heavy workload. OK, so that…, using “estimate” checkpoint method to reduce chances of log flush storms and disabling the query cache.
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… to periodically go through battery learning cycle which switches RAID cache in write-through mode which can cause serve performance degradation… – the traffic on different boxes might be different and hence cache content. Replication Traffic Changes Changing in the replication traffic (what… is many things which come together to form the perfect storm – just a bit of data growth which just a bit…
Comment: Cache Miss Storm
September 12, 2010 By 30 Comments
Cache Miss Storm. Nice term. But not news: Bug #15044 Query Cache synchronisation for multiple identical threads Date: 18 November 2005 http://…
Comment: Cache Miss Storm
September 10, 2010 By 30 Comments
I can’t resist adding some Google keywords for alternative ways to say “cache miss storm“: dogpile effect, thundering herd, cache stampede.
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
… time. It’s pretty easy to get into a “perfect storm” scenario. For example, I’m working with one client right… we need to stop the buffer pool and the OS cache from competing. My chosen strategy for this was to set…
