Re: Deadlock Detection in InnoDB storage engine
>Is it still required for us to create INDEX on this table?
Yes, because you use SELECT ... FOR UPDATE that lock all rows, if you use INDEX it would lock only 1 row.
Subject
Views
Written By
Posted
6447
July 24, 2012 06:03AM
1939
July 24, 2012 09:49AM
1634
July 24, 2012 10:10AM
1543
July 24, 2012 10:24PM
1480
July 25, 2012 02:38AM
1302
July 25, 2012 04:59AM
Re: Deadlock Detection in InnoDB storage engine
1267
July 25, 2012 05:04AM
1246
July 25, 2012 05:19AM
1267
July 25, 2012 11:39PM
1371
July 26, 2012 02:32AM
1327
July 26, 2012 06:33AM
1233
July 27, 2012 10:30PM
1459
July 31, 2012 12:00AM
1645
July 31, 2012 02:32AM
1167
July 31, 2012 05:10AM
4504
August 01, 2012 12:03AM
1298
August 01, 2012 06:05AM
1186
August 02, 2012 03:20AM
1103
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.