Hi
We have just started getting this error:
060819 16:57:44 InnoDB: ERROR: the age of the last checkpoint is 188740240,
InnoDB: which exceeds the log group capacity 188739994.
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 have looked thru the forum for previous reports of this issue, which basically say to look to
http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html which I have done.
This page says to do these things:
1. Make the ibdata file auto extend - mine is
2. Increase the ib_log file size
What makes me confused is that the message says to increase the log file size, and my log file is 100M and the longest blob I have is 25378 bytes - well within the limits of the message above.
Can anyone please offer some advice?
Thanks in advance.
Alan Langridge