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

Today, I will talk to you about the use of mysql record locks, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

When we introduced the scope of InnoDB locking, we mentioned the concept of record lock, which will be explained in detail today.

1. Record lock, locking only one row of the index record, and locking on a single index record.

2. Record lock always locks the index, not the record itself. Even if there is no index on the table, innodb creates a hidden clustered primary key index in the background, locking the hidden clustered primary key index.

Example

Add record sharing lock select * from t1_simple where id = 1 lock in share mode;-- plus record exclusive lock select * from t1_simple where id = 1 for update; after reading the above, do you have any further understanding of the use of mysql record locks? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

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.