MySQL Forums
Forum List  »  InnoDB

Re: Need more detail about index-record lock
Posted by: Shawn Green
Date: February 17, 2018 02:22PM

Your second transaction is waiting for your first transaction to COMMIT or ROLLBACK so that it can also have access to the supremum page for PK that table.

You are competing for the same "end" of the table.

It's a complicated topic but here are some resources to get you started.
https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-set.html
https://dev.mysql.com/doc/refman/5.7/en/innodb-next-key-locking.html

Yours,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville, TN

Become certified in MySQL! Visit https://www.mysql.com/certification/ for details.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Need more detail about index-record lock
526
February 17, 2018 02:22PM


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.