Creating sort index cause shared lock
Posted by:
Hansen Ng
Date: May 16, 2016 09:29PM
We have a large query to select some records on a single table. In running the application, it caused deadlock with some other update statement on the same table occasionally. In the deadlock information shown in the mysqld.log, the select statement (pure select statement without for update) causes "Creating sort index", and it causes the "lock mode S locks" in some records. How to avoid the Shared lock in the select statement as I don't expect the SQL statement would cause locking on the table.
Subject
Views
Written By
Posted
Creating sort index cause shared lock
3720
May 16, 2016 09:29PM
1879
May 16, 2016 09:48PM
1687
May 23, 2016 03:05PM
1550
May 24, 2016 09:08PM
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.