查看完整版本: 解決 InnoDB: ERROR: the age of the last checkpoint is


seeyou 2011-10-26 15:18

解決 InnoDB: ERROR: the age of the last checkpoint is

<P>最近使用 MySQL 5.1.52 時...發現Mysql Log 有 Error錯誤訊息:</P>
<P>[quote]</P>
<P>InnoDB: ERROR: the age of the last checkpoint is 60394386,<BR>InnoDB: which exceeds the log group capacity 60394292.<BR>InnoDB: If you are using big BLOB or TEXT rows, you must set the<BR>InnoDB: combined size of log files at least 10 times bigger than the<BR>InnoDB: largest such row.</P>
<P>[/quote]</P>
<P>&nbsp;</P>
<P>這主要是由於innodb_log_file_size 默認是5M, 不夠用引起的.</P>
<P>增大innodb_log_file_size的方法:</P>
<P>[quote]</P>
<P>(1)先搬移ib_logfile0和ib_logfile1 到 /tmp , 因為新舊的大小不同...必須改用新的size</P>
<P>#mv /var/lib/mysql/ib_logfile* /tmp<BR>(2)編輯my.cnf , 增加</P>
<P>innodb_log_file_size=64M<BR>[/quote]</P>
<P>&nbsp;</P>
<P>之後重新啟動 mysql ...這就就可以啦~~</P>
頁: [1]
查看完整版本: 解決 InnoDB: ERROR: the age of the last checkpoint is