MySQL Forums
Forum List  »  Backup

Re: Mysqldump with single transaction and skip lock tables locking the tables. help needed
Posted by: Rick James
Date: December 01, 2013 04:40PM

This is the villain:
LOCK TABLES variant WRITE
which was run by Prod_user.

If variant is InnoDB, there is almost no reason to ever use LOCK TABLES on it.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Mysqldump with single transaction and skip lock tables locking the tables. help needed
4122
December 01, 2013 04:40PM


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.