FXJ Wiki

Back

Transactions, Locks, and MVCC in MySQL

Transactions, Locks, and MVCC in MySQL

Based on the original MySQL notes, this post keeps the material on transactions, locks, MVCC, logs, and optimization.
views | comments

This is a short English draft for the Chinese article “MySQL 如何守住一致性:事务、锁、MVCC 与日志”. The full translation is not finished yet, but this page is enough to verify the bilingual blog flow.

Draft Summary#

This draft gives a short English overview of the MySQL topics covered in the Chinese article, including storage, transactions, logs, or locking.

Continue with the Chinese version if you want the complete notes, examples, proofs, and code snippets.

Transactions, Locks, and MVCC in MySQL
https://fxj.wiki/en/blog/interview-mysql-2
Author 玛卡巴卡
Published at 2025年6月5日
Comment seems to stuck. Try to refresh?✨