Make your log files big, even as big as the buffer pool.
When InnoDB has written the log files
full, it must write the modified contents of the buffer pool
to disk in a checkpoint. Small log files cause many
unnecessary disk writes. Although historically big log files
caused lengthy recovery times, recovery is now much faster
and you can confidently use large log files.
Make the log buffer quite large as well (on the order of 8MB).

User Comments
Add your own comment.