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

This article introduces how to carry out MySQL update data when InnoDB internal operation, the content is very detailed, interested friends can refer to, hope to be helpful to you.

When MySQL updates data, the operation flow within InnoDB is roughly as follows:

(1)。 Read the data into InnoDB buffer pool and add exclusive lock to the related records

(2)。 Write UNDO information to the rollback segment of the undo tablespace

(3)。 Change the data of the cached page and write the update record to redo buffer

(4)。 Refresh the update record in redo buffer to InnoDB redo log file in different ways according to the settings of innodb_flush_log_at_trx_commit, and then release the exclusive lock.

(5)。 The background IO thread will refresh and write the updated data in the cache to the disk file according to the need.

On how to conduct MySQL update data when the InnoDB internal operations are shared here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.