Tagged articles
Read View
11 articles · Page 1 of 1
This article explains MySQL's MVCC mechanism in InnoDB, detailing how hidden fields, undo logs, and Read Views enable lock-free snapshot reads, the differences between RC and RR isolation levels, why MVCC prevents non-repeatable reads but not phantom reads, and common pitfalls like long transactions causing undo log bloat.
InnoDBMVCCPhantom Read
0 likes · 11 min read

This article explains MySQL InnoDB’s MVCC mechanism, why it replaces traditional locking, details the four SQL isolation levels, illustrates dirty, non‑repeatable and phantom reads with examples, and breaks down the hidden fields, undo‑log chain, and read‑view algorithm that enable high‑concurrency, non‑blocking reads and writes.
InnoDBMVCCMySQL
0 likes · 18 min read

This article explains why MySQL uses Multi-Version Concurrency Control, how it replaces traditional locking, the inner workings of hidden fields, undo logs, and read views, and details each transaction isolation level with practical SQL examples and common anomalies such as dirty, non‑repeatable, and phantom reads.
InnoDBMVCCMySQL
0 likes · 17 min read

A nighttime incident revealed that a MySQL transaction updated a row but subsequent reads returned the old value, prompting a deep investigation that uncovered InnoDB’s repeatable‑read snapshot behavior, concurrent updates, and how MySQL may skip updates when data appears unchanged, along with reproducible steps and mitigation advice.
InnoDBMySQLRead View
0 likes · 16 min read

This article explains MySQL InnoDB's multi-version concurrency control (MVCC), covering its basic concepts, hidden columns, isolation levels, the creation and evaluation of Read Views, and includes detailed source code examples and step‑by‑step experiments to illustrate transaction visibility.
Database ConcurrencyInnoDBMVCC
0 likes · 18 min read


政采云技术Oct 24, 2023 · Databases
This article explains MySQL InnoDB's Multi-Version Concurrency Control (MVCC), covering its basic concepts, read/write scenarios, implicit fields, undo logs, read view mechanisms, transaction handling, and differences between RC and RR isolation levels, providing a comprehensive guide for developers.
InnoDBMVCCMySQL
0 likes · 16 min read


政采云技术Mar 28, 2023 · Databases
This article explains why MySQL uses MVCC, how undo‑log version chains and read views implement multi‑version concurrency control, and details the various lock types—including global, table, metadata, intention, row, gap, and next‑key locks—under different isolation levels with practical code examples.
InnoDBLocksMVCC
0 likes · 11 min read

This article explains MySQL 5.7 InnoDB's four isolation levels, the structure and purpose of undo logs, the mechanics of multi‑version concurrency control (MVCC), read‑view creation and closure, and why REPEATABLE READ still allows phantom reads, illustrated with code examples.
InnoDBMVCCMySQL
0 likes · 8 min read

MVCC (Multiversion Concurrency Control) in MySQL InnoDB uses undo logs and read views to provide non‑locking snapshot reads, managing read‑write, write‑write, and read‑read concurrency, with implicit row fields and transaction IDs determining visibility across isolation levels.
InnoDBMVCCMySQL
0 likes · 9 min read

This article explains the fundamentals of MVCC, transaction isolation levels, and related concepts such as ACID properties, dirty reads, non‑repeatable reads, phantom reads, hidden columns, undo logs, version chains, read views, and demonstrates how InnoDB implements these mechanisms with practical SQL examples and diagrams.
InnoDBMVCCRead View
0 likes · 21 min read

This article explains MySQL transaction isolation levels, the four concurrency problems (dirty write, dirty read, non‑repeatable read, phantom), how MVCC and version chains work, and the differences between READ COMMITTED and REPEATABLE READ using practical examples and diagrams.
MVCCMySQLRead View
0 likes · 10 min read
