MySQL Forums
Forum List  »  Knowledge Base

mysqldump on slave hangs
Posted by: Thomas Kettenbach
Date: December 27, 2008 11:40AM

We have a master / slave configuration with a mixed MyISAM / InnoDB Database. Once a day we make a backup of the databases on the slave. mysqldump does the
'FLUSH TABLES WITH READLOCK'

Another process makes a 'FLUSH TABLES', while the master keeps on getting updated the slave sql replication issues a 'UPDATE table SET ... WHERE ...' -- this one hangs on 'WAIT FOR RELEASE OF READ LOCK'. So far, so good.

However the other two processes with 'FLUSH TABLES WITH READLOCK' and 'FLUSH TABLES' seem to hang and can't continue.

My questions in this issue are:
- What are the 'flush table' processes doing? How can I get more info on that?
- Why is the 'read lock' not released?
- How can i see active locks held on the mysqld?

Thanks for working during the eoy period and hopefully answering this issue.

Options: ReplyQuote


Subject
Views
Written By
Posted
mysqldump on slave hangs
2802
December 27, 2008 11:40AM


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.