InnoDB: ERROR: the age of the last checkpoint

From Kolmisoft Wiki
Revision as of 06:22, 10 October 2018 by Admin (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

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