InnoDB Log Size

[Ben Clewett]

Dear InnoDB,

I am trying to work out how large my InnoDB log file should be, and hope somebody may offer some clue. I know it has to be large enough to cater for heavy load where row data writing may be delayed, and yet not too large so that a crash-recovery is not delayed. There may be other complications I don't yet understand.

There is a lot of conflicting advise out there. I read one posting saying it should be larger than the buffer size. But surely uncommitted row data is held in the buffer, so setting the log as larger than the buffer makes no sense?

Therefore I want to start again with the experts and see what you guys suggest!

I also really want to know how much uncommitted data my logs hold at any one time, preferably in bytes, so that I can measure how much uncommitted data I have.

Any information is very welcome!

Ben