MySQL Forums
Forum List  »  InnoDB

Re: What is the different between ib_logfile0 and ib_logfile1?
Posted by: Marko Mäkelä
Date: September 28, 2015 02:03AM

Rick posted the correct answer.

That said, ib_logfile0 is special, because it contains the log checkpoint information in pages 1 and 3 (starting at byte offsets 512 and 1536). The checkpoint will point to somewhere in the ib_logfile* files. There can be up to 100 of them, and logically they are like one big file, as if all ib_logfile* were catenated together.

I do not see any theoretical reason why there could not be just 1 ib_logfile0. The minimum number of files just happens to be 2, and we did not change that yet.

Starting with MySQL 5.6 (WL#6494), you can change the number and size of the redo log files at startup. Before that, InnoDB complained if the file sizes did not agree with the configuration.

With best regards,
Marko Mäkelä
InnoDB Group, MySQL Server, Oracle Corporation

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: What is the different between ib_logfile0 and ib_logfile1?
10678
September 28, 2015 02:03AM
1408
September 27, 2015 03:05PM


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.