Re: mysqldump --single transaction blocks writers
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.
Subject
Views
Written By
Posted
2952
July 21, 2014 06:24AM
1649
July 23, 2014 08:37AM
Re: mysqldump --single transaction blocks writers
1622
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.