MySQL Forums
Forum List  »  Backup

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Mysqldump with single transaction and skip lock tables locking the tables. help needed
15418
Amol Sane
November 29, 2013 04:55AM
Re: Mysqldump with single transaction and skip lock tables locking the tables. help needed
4084
Rick James
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.