Change innodb_log_file_size to solve the problem of InnoDB: ERROR: the ag...

Change innodb_log_file_size to solve InnoDB: ERROR: the ag... sometimes Mysql reports an ERROR: 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 www.2cto.com. This is mainly because innodb_log_file_size is 5 MB by default and is not enough. to increase innodb_log_file_size, pause mysql,/etc/init. d/mysql stop transfer ib_logfile0 and ib_logfile1, mv/usr/local/mysql/var/ib_logfile *.. /edit my. cnf, added innodb_log_file_size = 64 m to start mysql,/etc/init. d/mysql start author neou