MySQL Forums
Forum List  »  Backup

Re: mysqldump --single transaction blocks writers
Posted by: Rick James
Date: July 23, 2014 08:37AM

> SELECT /*!40001 SQL_NO_CACHE */ * FROM `db_external_notification`

has been running 20 minutes; how big is the table?

> State: Waiting for table flush

FLUSH TABLES WITH READ LOCK;
has probably been issued by mysqldump -- it has to wait for all activity to cease.

See if XtraBackup will avoid this problem.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: mysqldump --single transaction blocks writers
1634
July 23, 2014 08:37AM


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.