…What cache hit rate is good for optimal MySQL Performance” is typical question I’m asked. It could by MyISAM key_… IO bould while showing very large hit rate so even taking data for single thread is not enough. So what should you look at ? The…, how good was OS or SAN cache hit rate – something you would not see otherwise. The bad luck is – MySQL currently does not provide…
Post: MySQL caching methods and tips
April 4, 2011 By 4 Comments
…is expensive, and even if the disk bottleneck is eliminated, the sorting, aggregation and join operations are still CPU intensive and single threaded…cache is empty. When talking about cache, the miss path is at least as important as the hit…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…hit ratio which measures buffer pool efficiency. 1000/1000 corresponds to 100% hit rate. It is hard to tell what buffer pool hit rate is good enough – it is…
Post: Living with backups
November 6, 2008 By 28 Comments
…hit ratio becomes worse as the cache is being filled with random information additional I/O occur slowing everything down even further. What… the rate at which data is being read. This is unfortunately …Threads_connected”‘); … if ($$row[1] < 10) { $is_running= 1; } if ($$row[1] > 50) { $is_running…
