MySQL Forums
Forum List  »  Newbie

MySQL Backups - Innodb
Posted by: Purna Chinta
Date: August 04, 2011 01:49AM


I am new to MySQL. I have read on mysqldev, that using --single-transaction, a consistent backup can be made and all read/write operations will not be blocked. But how mysqldump see's the page as consistent if a write is operation is going on??? Also, by the time dump moves on, I might have completed 'n' number of data changes, but they will not get reflected on dump...will each page record any transaction number on it???? By the time the backup reaches the page, it might have overwritten 'n' times by another transactions...will it still treat the dump as consistent one???

Please help with clarification.

Options: ReplyQuote

Written By
MySQL Backups - Innodb
August 04, 2011 01:49AM
August 06, 2011 09:59AM
August 06, 2011 11:50AM

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.