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

Most people do not understand the knowledge points of this article "what are the four locking ranges of mysql InnoDB?", so the editor summarizes the following content, detailed content, clear steps, and has a certain reference value. I hope you can get something after reading this article. Let's take a look at this article "what are the four locking ranges of mysql InnoDB?"

1. Record lock, locking the record in the index.

2. Clearance lock.

Either lock the value in the middle of the index record, lock the value in front of the first index record, or lock the value behind the last index record.

3. the key lock is the combination of the record lock on the index record and the gap lock before the index record.

4. Insert the intention lock and add the lock of the record id in the insert operation.

Example

-- id is listed as a primary key column or a unique index column UPDATE SET age = 50 WHERE id = 1. The above is the content of this article on "what are the four locking ranges of mysql InnoDB". I hope you all have some understanding. I hope the content shared by the editor will be helpful to you. If you want to learn more about the relevant knowledge, please follow 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.