InnoDB: ERROR: the age of the last checkpoint

The error message means that you're trying to insert too much data into InnoDB too quickly, and the InnoDB log is filling up before the data can be flushed into the main data files.

Solution

1. Change the following in /etc/my.cnf

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

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

3. service mysql stop

4. mv -fr /var/lib/mysql/ib_logfile* /tmp

5. service mysql start

This will rebuild the following files

/var/lib/mysql/ib_logfile0
/var/lib/mysql/ib_logfile1

See also

• https://www.percona.com/blog/2008/11/21/how-to-calculate-a-good-innodb-log-file-size/
• https://dba.stackexchange.com/questions/16510/mysql-innodb-innodb-error-the-age-of-the-last-checkpoint-is-innodb-which-exc