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

Written By
Re: mysqldump --single transaction blocks writers
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.