MySQL

From Leaky
Revision as of 09:09, 23 September 2013 by Leaky (talk | contribs) (Created page with 'If you start to use innodb a lot and see the following error in the mysql error log, you need to tune the innodb_log_file_size variable. 130923 9:27:06 InnoDB: ERROR: the age…')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

If you start to use innodb a lot and see the following error in the mysql error log, you need to tune the innodb_log_file_size variable. 

130923  9:27:06  InnoDB: ERROR: the age of the last checkpoint is 9448377,
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 log files at least 10 times bigger than the
InnoDB: largest such row.

http://www.mysqlperformanceblog.com/2008/11/21/how-to-calculate-a-good-innodb-log-file-size/

Retrieved from "https://wiki.leaky.org/index.php?title=MySQL&oldid=86"