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…') |
|||
| Line 10: | Line 10: | ||
innodb_log_file_size = 768M | innodb_log_file_size = 768M | ||
2. | 2. mysql -uroot -p -e"SET GLOBAL innodb_fast_shutdown = 0;" | ||
3. | 3. service mysql stop | ||
4. service mysql start | 4. rm -f /var/lib/mysql/ib_logfile* | ||
5. service mysql start | |||
This will rebuild the following files | This will rebuild the following files | ||
| Line 24: | Line 26: | ||
= See also = | = See also = | ||
* https://www.percona.com/blog/2008/11/21/how-to-calculate-a-good-innodb-log-file-size/ | * 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 | |||
Revision as of 06:21, 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. mysql -uroot -p -e"SET GLOBAL innodb_fast_shutdown = 0;"
3. service mysql stop
4. rm -f /var/lib/mysql/ib_logfile*
5. service mysql start
This will rebuild the following files
/var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile1
