更改innodb_log_file_size, 解决InnoDB: ERROR: the ag...的问题

来源：未知责任编辑：责任编辑发表时间:2015-01-01 13:18　点击:次

有时侯Mysql会报错:

120418 8:00:14 InnoDB: ERROR: the age of the last checkpoint is 9434204,

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 www.2cto.com

这主要是由于 innodb_log_file_size 默认是5M, 不够用引起的.

增大innodb_log_file_size的方法:

暂停mysql, /etc/init.d/mysql stop

转移ib_logfile0和ib_logfile1, mv /usr/local/mysql/var/ib_logfile* ../

编辑my.cnf , 增加 innodb_log_file_size=64M

启动mysql, /etc/init.d/mysql start

作者 neou