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
1740
January 12, 2013 11:43AM
773
January 12, 2013 01:51PM
Re: deadlock for mixed row and table lock?
763
January 14, 2013 09:29AM
819
February 13, 2013 03:12PM
744
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.