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

This article shows you how the mechanism of mysql update is. The content is concise and easy to understand. It will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

You can see the specific flow of a Update operation. When Update SQL is sent to MySQL, MySQL Server reads the first record that meets the condition according to the where condition, and then the InnoDB engine returns the first record and current read it. After MySQL Server receives the locked record, it initiates another Update request to update the record. A record operation is completed, and the next record is read until there is no record that meets the criteria. Therefore, inside the Update operation, there is a current read. In the same way, the same goes for Delete operations. The Insert operation is slightly different, simply put, the Insert operation may trigger a conflict check for Unique Key, as well as a current read.

Generally speaking, service read data innodb (engine) execution

The process is as follows

Service reads a record, and the engine locks the read record and informs service,service to initiate a update command, and the engine performs update actions on the locked record.

The above is what the mechanism of mysql update is. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to 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.