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. service mysql stop

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

4. 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/