InnoDB Log Optimisation

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

Re: InnoDB Log Optimisation

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 useful.

Re: InnoDB Log Optimisation

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