> is that if very few changes are made to a system it could take hours > before it actually gets backed up, is this correct? Here's what I'm > thinking and please verify if I'm thinking correctly, with 10 > minute log > backups I have the potential to loose up to 9 minutes and 59 seconds > (roughly due to the time it takes to actually execute the script, then > backup) and/or 7.9k of data?
Not hours - but 10 minutes :-) The database writes a checkpoint every 10 minutes and the fact, that this checkpoint has been written will be reflected in an update of a table. This update will produce log. Let's assume you have a problem with the database and you need to recover. In case the logfile (which can be mirrored) is intact it will ask you to recover log and use the yet-not-archived log also to bring the database online to the point it has been before the crash. To ensure maximum security I'd use the mirror log feature on a separate disk. Greetz, SIEGENIA-AUBI KG Informationswesen i.A. Markus Döhr SAP-CC/BC, SAPDB-DBA Tel.: +49 6503 917-152 Fax: +49 6503 917-7152 E-Mail: [EMAIL PROTECTED] Internet: http://www.siegenia-aubi.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
