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.
Subject
Views
Written By
Posted
1572
January 12, 2013 11:43AM
702
January 12, 2013 01:51PM
Re: deadlock for mixed row and table lock?
677
January 14, 2013 09:29AM
751
February 13, 2013 03:12PM
666
February 24, 2013 03:39PM
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.