June 19, 2013

Comment: How to calculate a good InnoDB log file size

… have got the impression that if you get the error message: 081223 7:54:18 InnoDB: ERROR: the age of the last checkpoint is xxxxx, InnoDB: which exceeds the log group capacity yyyyy. InnoDB: If you are using big BLOB or TEXT rows, you must set the InnoDB

Comment: How to calculate a good InnoDB log file size

…:04 InnoDB: ERROR: the age of the last checkpoint is 9434190, InnoDB: which exceeds the log group capacity 9433498. InnoDB: If you are using big BLOB or TEXT rows, you must set the InnoDB: combined size of

Comment: How to calculate a good InnoDB log file size

… | +———————-+———–+ | innodb_log_file_size | 536870912 | +———————-+———–+ 1 row in set (0.00 sec) The error message in the log states that the age of the last checkpoint is 966364465 and the capacity is 966363956. I’m not sure why there capacity is a bit smaller than two times the innodb