… 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 it does not really matter. In both cases trying to come up with constant “good” hit rate is…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… InnoDB 442 mysql tables in use 1, locked 0 MySQL thread id…buffer_size is optimal – if you see more than 30% of log buffer…buffer pool. Finally you can see buffer pool hit ratio which measures buffer pool efficiency. 1000/1000 corresponds to 100% hit rate. It is hard to tell what buffer pool hit rate…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 5 Comments
…it tell us? mysql> SHOW ENGINE INNODB STATUS\G …optimize the Checkpoint age, it is flushing to try to optimize IO and to obey the LRU in the buffer pool. Since buffers…buffers and they are hitting their max checkpoint age. The way this increases dirty buffer… and the rate of transaction log growth…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
… advice about tuning MySQL‘s key cache hit ratio is …buffer, key_buffer, and key cache interchangeably. However, I will be careful about the difference between “rate… buffer hit or miss takes. If you approach application performance optimization…way to choose an innodb_buffer_pool_size setting? This is…
