Difference between revisions of "InnoDB: ERROR: the age of the last checkpoint"
From Kolmisoft Wiki
Jump to navigationJump to search
(Created page with '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 fil…') |
(No difference)
|
Revision as of 06:13, 10 October 2018
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
