What are the three stages of MySQL transaction commit

This article introduces the knowledge of "what are the three stages of MySQL transaction submission". Many people will encounter this dilemma in the operation of actual cases, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Transaction commit is divided into three phases

-several threads in each phase enter the phase queue, and the first (leader) thread completes the phase task of each thread's session

-each phase is executed in parallel, with only one set of transactions in any phase

-second, the three phases can be added to the queue of the previous batch, and the original leader can be changed to follower halfway.

-flush phase, which is done sequentially for each transaction:

Storage engine prepare, which brushes the storage engine transaction log for the whole group at once

Generate XID_EVENT, solidify the transaction's binlog cache

Generate gtid-log-event (transaction timestamp, global timestamp)

Write the binlog of the transaction to the binlog file

-sync Pha

Binlog group commit wait

Disposable flash disk binlog file

-commit

Storage engine commit, which is done according to the order in the queue

That's all for "what are the three stages of MySQL transaction commit?" Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!