2012年12月5日 星期三

InnoDB出現ERROR: the age of the last checkpoint is xxx

MySQL 的 Error log 出現:

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


解決方式:
1.調大以下三個參數(vi my.cnf)
innodb_log_buffer_size
innodb_buffer_pool_size
innodb_log_file_size

2.shutdown mysql
ssh# mysqladmin shutdown -uroot -p
Enter password:

3.將 ib_logfile* 刪除
ssh# cd /var/db/mysql
ssh# rm ib_logfile0
ssh# rm ib_logfile1

4.start mysql
ssh# /usr/local/bin/mysqld_safe &

沒有留言: