Re: Deadlock Detection in InnoDB storage engine
Hi Aftab,
Thanks so much for help.
We are currently not using any stored procedures. Its transactions are from application using springs. We do not have any long running transactions, though one search query is taking long time nearly 15 secs which is using LEFT OUTER JOINS to nearly 7-8 tables.(We are working to solve it.) But this is in a separate transaction and is not using OB_SEQUENCE_INFO table. Each other transaction nearly uses 10 tables.
One idle process which you pointed out came even before we started our JBoss server.
Please let us know if we can debug it further.
Regards,
Manjunath.
Subject
Views
Written By
Posted
6451
July 24, 2012 06:03AM
1941
July 24, 2012 09:49AM
1636
July 24, 2012 10:10AM
1545
July 24, 2012 10:24PM
1481
July 25, 2012 02:38AM
1303
July 25, 2012 04:59AM
1269
July 25, 2012 05:04AM
1247
July 25, 2012 05:19AM
1270
July 25, 2012 11:39PM
1372
July 26, 2012 02:32AM
Re: Deadlock Detection in InnoDB storage engine
1328
July 26, 2012 06:33AM
1235
July 27, 2012 10:30PM
1461
July 31, 2012 12:00AM
1646
July 31, 2012 02:32AM
1168
July 31, 2012 05:10AM
4507
August 01, 2012 12:03AM
1299
August 01, 2012 06:05AM
1187
August 02, 2012 03:20AM
1104
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.