MySQL Forums
Forum List  »  InnoDB

Re: deadlock for mixed row and table lock?
Posted by: Rick James
Date: January 14, 2013 09:29AM

In InnoDB don't do table locks.

Do
BEGIN
operation(s)
COMMIT

You can get deadlocks (can't tell about your particular operation); plan for them.

Check each statement for having an error. If you get an error, go back to the BEGIN and start the transaction over.

Options: ReplyQuote


Subject
Views
Written By
Posted
1572
January 12, 2013 11:43AM
Re: deadlock for mixed row and table lock?
677
January 14, 2013 09:29AM


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.