MySQL Forums
Forum List  »  Backup

Re: MySQLdump Lock Table
Posted by: Peter Brawley
Date: November 27, 2018 12:14PM

> The mysqldump can be executed and completed without interfering with user tasks?

A massive transaction can hold up other transactions, no question. Logically inevitable.

So we usually do backups at off-peak times.

Best way I know to maximise copy accuracy and minimise user interruption is replication.

Options: ReplyQuote


Subject
Views
Written By
Posted
1613
November 22, 2018 04:46AM
544
November 22, 2018 03:42PM
569
November 23, 2018 03:06AM
549
November 23, 2018 11:56AM
593
November 27, 2018 02:06AM
Re: MySQLdump Lock Table
492
November 27, 2018 12:14PM
472
December 04, 2018 03:39AM


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.