Re: Innodb Log File Error
No, you won't lose any data.
The InnoDB log files (these are also called the REDO logs) are implemented as a circular buffer. Should you accumulate more information than you have available space for (based on the position of the last checkpoint) then the overflow is temporarily routed to the primary tablespace (your ibdata# files). This is clearly going to have some impact performance until the new information added to the REDO logs since your last checkpoint can be merged with the permanent data location of the tables.
To fix this, *carefully* follow the procedure documented here to increase the size your log files
http://dev.mysql.com/doc/refman/5.5/en/innodb-data-log-reconfiguration.html
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
Subject
Written By
Posted
February 06, 2013 06:35AM
Re: Innodb Log File Error
February 13, 2013 12:51PM
February 13, 2013 08:06PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.