Re: Deadlock Detection in InnoDB storage engine
Even 15 seconds is dangerously long if you want to have 5 copies running at the same time.
Plan A:
Use AUTO_INCREMENT instead of a sequence table. It is much simpler and more efficient.
Plan B:
I suggest you get the sequence number _outside_ the transaction.
If you need more help, please provide the whole transaction, plus SHOW CREATE TABLE and SHOW TABLE STATUS for the tables involved.
Subject
Views
Written By
Posted
6895
July 24, 2012 06:03AM
2057
July 24, 2012 09:49AM
1728
July 24, 2012 10:10AM
1664
July 24, 2012 10:24PM
1572
July 25, 2012 02:38AM
1396
July 25, 2012 04:59AM
1369
July 25, 2012 05:04AM
1341
July 25, 2012 05:19AM
1383
July 25, 2012 11:39PM
1464
July 26, 2012 02:32AM
1413
July 26, 2012 06:33AM
Re: Deadlock Detection in InnoDB storage engine
1318
July 27, 2012 10:30PM
1654
July 31, 2012 12:00AM
1751
July 31, 2012 02:32AM
1260
July 31, 2012 05:10AM
4621
August 01, 2012 12:03AM
1412
August 01, 2012 06:05AM
1291
August 02, 2012 03:20AM
1198
August 28, 2012 06:28AM
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.