ADJ網路實驗室 - Powered by Discuz! Board

標題: [分享] 解決 InnoDB: ERROR: the age of the last checkpoint is [打印本頁]

作者: seeyou 時間: 2011-10-26 15:18 標題: 解決 InnoDB: ERROR: the age of the last checkpoint is

最近使用 MySQL 5.1.52 時...發現Mysql Log 有 Error錯誤訊息:

引用:

InnoDB: ERROR: the age of the last checkpoint is 60394386,
InnoDB: which exceeds the log group capacity 60394292.
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.

這主要是由於innodb_log_file_size 默認是5M, 不夠用引起的.

增大innodb_log_file_size的方法:

引用:

(1)先搬移ib_logfile0和ib_logfile1 到 /tmp , 因為新舊的大小不同...必須改用新的size

#mv /var/lib/mysql/ib_logfile* /tmp
(2)編輯my.cnf , 增加

innodb_log_file_size=64M

之後重新啟動 mysql ...這就就可以啦~~

歡迎光臨 ADJ網路實驗室 (http://dz.adj.idv.tw/)