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