MySQL DBA - Tips and Techniques Magazine

23 Oct 2014

InnoDB: ERROR: the age of the last checkpoint

We just had this error message from "mk-lluprequal-1"

 

 

080331 10:57:46  InnoDB: ERROR: the age of the last checkpoint is

9433713,

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.

 

 

 

Can you please explain why someone is running alter table command on a

production system.  There is a transaction that may be too big for the

allocated log size.  Currently its set to 5m.

 

| 33927407 | prequal_rw | dhcp-26-55.hk.uk.intranet:39713   | prequal |

Query       | 434     | copy to tmp table

| alter table LineTest add key TestDate(TestDate) |

 

 

 

 

http://crazytoon.com/2007/08/16/mysql-innodb-error-the-age-of-the-last-checkpoint-is-number/

No comments:

Post a Comment