…key cache hit ratio should be very high, ideally above 99.9%” or “if your key cache hit ratio is low, your key…key buffer be anyway? Let’s trust MyISAM‘s creators on this one, because they designed a cache hit…
Post: What MySQL buffer cache hit rate should you target
June 29, 2006 By 5 Comments
…What cache hit rate is good for optimal MySQL Performance” is typical question I’m asked. It could by MyISAM key_buffer or Innodb innodb… problems with key buffer efficiency. In the real world even single operation may be IO bould while showing very large hit rate so… were these reads/writes, how good was OS or SAN cache hit rate – something you would not see otherwise. The bad luck is…
