…What cache hit rate is good for optimal MySQL Performance” is typical question I’m asked. It could by MyISAM key_… full table scan and you have 100 rows per page you will get 1 miss per page and 99 hits, making your hit ratio… good was OS or SAN cache hit rate – something you would not see otherwise. The bad luck is – MySQL currently does not provide this information…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…is current value for the mutex object (locked=1/free=0) , “waiters flag” is current…hit rate. It is hard to tell what buffer pool hit rate is good enough – it is…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…1 PAGES_READ_RATE: 0 PAGES_CREATE_RATE: 0 PAGES_WRITTEN_RATE: 0 NUMBER_PAGES_GET: 6731253 HIT_RATE…CURRENT: 0 UNCOMPRESS_TOTAL: 0 * UNCOMPRESS_TOTAL: 0 UNCOMPRESS_CURRENT: 0 UNCOMPRESS_CURRENT: 0 As promised, here are the results from joining the tables…
Post: Living with backups
November 6, 2008 By 28 Comments
…is wiped out and replaced by random “garbage” for no good reason. Since the hit ratio becomes worse as the cache is…is the current…rate=15000000 …’); } $was_running= 1; $is_running= 1; while(1) { if ($is_running == 0 && $was_running == 1) { kill 19, $pid; $was_running= 0; } if ($is_running == 1…
