Home / server / Questions / 293406
In Process
knorv
Asked: 2011-07-24 11:44:57 +0800 CST

MySQL: InnoDB: ERROR: the age of the last checkpoint is X, which exceeds the log group capacity Y?

  • 772

In a production MySQL environment the following error message is written to /var/log/mysql/error.log every fourth minute:

110723 18:36:02  InnoDB: ERROR: the age of the last checkpoint is 9433856,
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.

I'm not sure how to parse the error message.

More specifically I don't understand how the age of the checkpoint relates to the "log group capacity", and how that in turn relates to the size of rows with large BLOB/TEXT columns.

Basically I'm lost on how to troubleshoot and proceed fixing this problem. My questions are:

  • What does the error message mean?
  • What am I doing wrong?
  • How can I fix it?
mysql innodb

1 Answers

  1. The error message means that you're trying to insert too much data into InnoDB too quickly, and the InnoDB log is filling up before the data can be flushed into the main data files.

    To solve it, you need to stop MySQL cleanly (very important), delete the existing InnoDB log files (probably lb_logfile* in your MySQL data directory, unless you've moved them), then adjust the innodb_log_file_size to suit your needs, and then start MySQL again. This article from the MySQL performance blog might be instructive.

    • 11