Re: InnoDB Backup
innodb log files contain the innodb transactions which are yet to be written to the data file. It kind of acts as a buffer to the actual data file. It is these files that are used by innodb during crash recovery.
mysql binary logs contain all the transactions/statements that could have potentially changed the db. It is not required for normal usage. Its main use is during replication. In fact if u are not using replication then u better disable binary logging as it slightly affacts the performance. More ihfo on this is available in the mysql documentation.
Subject
Views
Written By
Posted
2631
November 10, 2008 04:00PM
Re: InnoDB Backup
1644
November 11, 2008 09:07AM
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.