…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_buffer_pool… would be to look at response time contribution – how much buffer misses (physical reads) contributed to response time ? This would take into account…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
…buffer, key_buffer, and key cache interchangeably. However, I will be careful about the difference between “rate” and “ratio”. In this article, the key cache miss rate…InnoDB tuning? You might be wondering, what about InnoDB tuning? What is the best way to choose an innodb_buffer_pool…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…read requests per a readahead. The InnoDB buffer is 256 page read requests for the aio read…Cache with good results. I just wrote the post on this this matter the other day – choosing innodb_buffer_pool…reads misses (10ms each). The reads…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…INNODB uses it’s own internal buffer pool but it’s in conflict with the Linux kernel’s buffer pool. In high load situations where INNODB…buffer pool and which are not swappable. They also allow to reduce number of TLB cache misses…
