Shulou(Shulou.com)05/31 Report--

This article "mysql key lock refers to what" most people do not understand, so the editor summed up the following content, detailed, clear steps, with a certain reference value, I hope you can get something after reading this article, let's take a look at this "mysql key lock refers to what" article.

Description

1. Acting on a non-unique index, it is a combination of record lock and gap lock.

2. The left open and right closed interval, the locked range follows: the next left open and right closed interval of the last record.

That is, (- ∞, 5] (5-∞ 10] (10-10) (15-15) (15-20) (20-25) (25-10).

Example

Update userinfo SET age=19 where id=10; Select * from userinfo where id=10 FOR UPDATE

Both will be locked in (5, 10, 10) and (10, 15). That is, InnoDB will acquire the key lock of the record row and the gap lock of the next interval of the record row at the same time.

The above is about "mysql key lock refers to what" this article content, I believe we all have a certain understanding, I hope the editor to share the content to help you, if you want to know more related knowledge content, please pay attention to the industry information channel.

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.