MySQL Forums :: Newbie :: MySQL Backups - Innodb


Advanced Search

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

Hi,

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


Subject Written By Posted
MySQL Backups - Innodb Purna Chinta 08/04/2011 01:49AM
Re: MySQL Backups - Innodb Morgan Tocker 08/06/2011 09:59AM
Re: MySQL Backups - Innodb Peter Brawley 08/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.