Comment 11 for bug 1417810

@mig5 - in addition to Roel's question:

  innodb_log_buffer_size 8388608
  innodb_log_file_size 104857600

These values look low. They may be fine if you have small volume, small transactions and small data rows. It really depends on your usage.

If your transaction volume, transaction size or DML statements are large you would want to increase these.

There is a very good article here:

http://www.percona.com/blog/2008/11/21/how-to-calculate-a-good-innodb-log-file-size/

The measurement will take a minute during your peak load time. You may want to take a few measurements and average to come up with good settings. Beyond this, you may want to contact our support for assistance in tuning for your environment.