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
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?