bitscn.com
更改innodb_log_file_size, 解决innodb: error: the ag...的问题 有时侯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 theinnodb: combined size of log files at least 10 times bigger than theinnodb: largest such row 这主要是由于 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 bitscn.com