… thread id 1148250464, thread declared inside InnoDB 442 mysql tables in use 1, locked 0 MySQL thread id 8079, query id 728899 localhost… writes/s Buffer pool hit rate 999 / 1000 This section shows Buffer pool activity and memory usage. You can see total memory allocated by Innodb (sometimes it…
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_buffer_pool it does not really matter. In both cases trying to come up with constant “good” hit rate is looking…
Post: Can Innodb Read-Ahead reduce read performance ?
June 26, 2007 By 2 Comments
… writes/s Buffer pool hit rate 933 / 1000 ————– ROW OPERATIONS ————– 8 queries inside InnoDB, 3 queries in queue 12 read views open inside InnoDB Main thread… (I was adviseor in this project from MySQL AB side) – to improve how Innodb read-ahead works by having more overlap between…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 5 Comments
…buffer pool pages are flushed down the to the tablespace. If Innodb stops (read: crashes) with dirty buffer pool pages, Innodb…Innodb log checkpointing and what does it tell us? mysql> SHOW ENGINE INNODB…rate of transaction log growth. innodb…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
… 99% of advice about tuning MySQL‘s key cache hit ratio is wrong, even …buffer, key_buffer, and key cache interchangeably. However, I will be careful about the difference between “rate…InnoDB tuning? You might be wondering, what about InnoDB tuning? What is the best way to choose an innodb_buffer_pool…
Post: FlashCache: tpcc workload
May 25, 2010 By 18 Comments
…32GB of RAM, 22GB allocated for buffer pool and I put 70GB on FlashCache …rate in final place is limited by RAID. So all performance benefits will come from read hits…blocksize), and you only rely on InnoDB in this case, and it takes…able to attach previous cache, and MySQL was able to start and finish…
