Be Wary of Large Log File Sizes

As some people have mentioned here and here Increasing the innodb log file size can lead to nice increases in performance. This is a trick we often deploy with clients so their is not anything really new here. However their is a caveat, please be aware their is a potentially huge downside to having large log file sizes and that’s crash recovery time. You trade real-world performance for crash recovery time. When your expecting your shiny Heartbeat-DRBD setup to fail-over in under a minute this can be disastrous! In fact I have been some places were recovery time is in the hours. Just keep this in mind before you change your settings.

This entry was posted in 5 minute dba, Common Mistakes, Matt, mysql, performance. Bookmark the permalink.

One Response to Be Wary of Large Log File Sizes

  1. Arjen Lentz says:

    And… it’s more than hours.