MySQL Forums
Forum List  »  Backup

Re: mysqldump --single transaction blocks writers
Posted by: Morgan Tocker
Date: July 29, 2014 10:22AM

Did you use any other options for mysqldump, such as --flush-logs or --master-data?

Some options will require mysqldump to initially run a FLUSH command. If you have a number of long running queries this can cause a stall while you wait for the last one to finish. Once the FLUSH command has run, the backup no longer blocks writers.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: mysqldump --single transaction blocks writers
1614
July 29, 2014 10:22AM


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.