MySQL Backups - Innodb
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.
Subject
Written By
Posted
MySQL Backups - Innodb
August 04, 2011 01:49AM
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.