This is a time-honored topic, and there’s no shortage of articles on the topic on this blog. I wanted to write a post trying to condense and clarify those posts, as it has taken me a while to really understand this relationship. Some basic facts Most of us know that writing into Innodb updates buffer [...]
The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 4 Comments
Setting up XFS on Hardware RAID — the simple edition
December 16, 2011 By 8 Comments
There are about a gazillion FAQs and HOWTOs out there that talk about XFS configuration, RAID IO alignment, and mount point options. I wanted to try to put some of that information together in a condensed and simplified format that will work for the majority of use cases. This is not meant to cover every [...]
Beware the Innodb Table Monitor
November 29, 2011 By 2 Comments
As I stated in my last post, I decided to use the Innodb Table monitor to diagnose an Index count mismatch error a customers found in their mysqld.err log to verify if the problem still existed. The Innodb Table Monitor has existed for basically forever in Innodb (the MySQL manual discusses it back in the 4.1 [...]
Innodb vs MySQL index counts
November 29, 2011 By 6 Comments
I had a customer recently who a few strange errors in their mysqld.err log: [ERROR] Table database_name/table_name contains 8 indexes inside InnoDB, which is different from the number of indexes 7 defined in the MySQL This customer was running Percona Server 5.1 and they got this error on two tables during a maintenance window when [...]
