Re: InnoDB Log Optimisation

2008-05-09 Thread Ben Clewett
Thanks for the idea. Unfortunately nothing I can easily use (for instance in MySql Administrator) to log and monitor the lag in bytes between log writes and row data writes. :) Iñigo Medina García wrote: Hi Ben, Dear MySql, I am trying to optimise InnoDB, and trying to find out how much

Re: InnoDB Log Optimisation

2008-05-09 Thread Iñigo Medina García
Hi Ben, > > Dear MySql, > > I am trying to optimise InnoDB, and trying to find out how much of the > innodb log file contains row data which has not been written to storage. > > Therefore I can optimize the size of the log, keeping it low to reduce > crash recovery time yet high enough to be us

InnoDB Log Optimisation

2008-05-09 Thread Ben Clewett
Dear MySql, I am trying to optimise InnoDB, and trying to find out how much of the innodb log file contains row data which has not been written to storage. Therefore I can optimize the size of the log, keeping it low to reduce crash recovery time yet high enough to be useful. I can see th