MySQL Forums
Forum List  »  InnoDB

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Creating sort index cause shared lock
1902
May 16, 2016 09:29PM


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.