May 24, 2012

Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages

Innodb Log Checkpointing So, first of all, what can we see about Innodb log checkpointing and what does it tell us? mysql> SHOW ENGINE INNODBhow can we optimize here?  The short of it is: make innodb flush more dirty pages.  However, I can‘t help but wonder if

Post: Living with backups

…dumps all MySQL tables into a…seem by my last sentence, …allows to affect how I/O scheduler will be dealing with I…even if not, you can change … an application tells the system… for InnoDB tablespaces, other MySQL data …manage and have a way to know when it ends. This is of course just a concept of what I