Shulou(Shulou.com)06/02 Report--

This article is about how mysql implements innodb table-level locks and row-level locks. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Innodb's row lock is when there is an index, and a table without an index locks the whole table.

Table lock demo (no index)

Operation 1

Operation 2

In a state of waiting.

After going back to operation 1 commit, operation 2 came out with the result (locked for 8 seconds, and then submitted to session1 after about 6 seconds).

The experimental results are as follows:

My for update operation on operation 1 seems to lock only rows with ID 2, but actually locks the whole table, so that the update for rows with ID 1 in later operation 2 needs to wait for the release of operation 1 lock.

Row lock demo (index is ID)

Increase the index:

Experimental results:

This time the lock is a locked row, so rows that are not locked (rows with ID not 2) can be update..

Thank you for reading! On "mysql how to achieve innodb table-level locks and row-level locks" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, you can share it out for more people to see it!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.