Hello 
 
I have looked in the archive of the mailing list, to see if there was
any discussion on that, but I have not seen any message. 
 
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?
 
Thank you in advance for your help
 
Johanne Duhaime
courrier: [EMAIL PROTECTED]
 
 

Reply via email to