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