MySQL Forums
Forum List  »  Install & Repo

innodb_log_archive : should I activate it?
Posted by: Johanne Duhaime
Date: August 17, 2004 09:40AM

I just install mysql 4.3.1 and I am wondering if I should archive the logfiles.

In the documentation it is said about innodb_log_archive : "This value should currently be set to 0. As recovery from a backup is done by MySQL using its own log files, there is currently no need to archive InnoDB log files. The default value of this parameter is 0" .

I have 2 log files. Usually I prefer to use archiving (at least I do it in Oracle) to be sure that records in the logfiles are not overwriten. I know that the size of the logfile should prevent this but still I would prefer. I am wondering why it is said that there is not need.

Also I have looked for information about the checkpoint. Is it a time dependant checkpoint or a size dependant. Can we modify the time or the size?

Johanne
Duhaimj@ircm.qc.ca

Options: ReplyQuote


Subject
Written By
Posted
innodb_log_archive : should I activate it?
August 17, 2004 09:40AM


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.