Mysql Innodb: InnoDB: ERROR: the age of the last checkpoint is InnoDB: which exceeds the log group capacity

STEP 01) Change the following in /etc/my.cnf

[mysqld]
innodb_log_buffer_size          = 32M
innodb_buffer_pool_size         = 2G
innodb_log_file_size            = 768M

STEP 02) SET GLOBAL innodb_fast_shutdown = 0; to force InnoDB to completely purge transactional changes from all of InnoDB moving parts, including the transactional logs (ib_logfile0, ib_logfile1). Thus, there is no need to backup the old ib_logfile0, ib_logfile1.

mysql -uroot -p -e"SET GLOBAL innodb_fast_shutdown = 0;"

STEP 03) Stop mysql

service mysql stop

STEP 04) Delete ib_logfiles

rm -f /var/lib/mysql/ib_logfile*

STEP 05) Start mysql again

service mysql start

References: Stackoverflow

Leave a Reply