BestHub
Sign in
Tagged articles
10 articles
Page 1 of 1
Sohu Tech Products
Sohu Tech Products
Dec 3, 2025 · Databases

Why MySQL Uses MVCC: A Deep Dive into Concurrency, Isolation Levels, and Read Views

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.

Concurrency ControlInnoDBIsolation Levels
0 likes · 18 min read
Why MySQL Uses MVCC: A Deep Dive into Concurrency, Isolation Levels, and Read Views
IT Services Circle
IT Services Circle
Dec 1, 2025 · Databases

Master MySQL MVCC: Unlocking Concurrency, Locks, and Isolation Levels

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.

InnoDBMVCCRead View
0 likes · 17 min read
Master MySQL MVCC: Unlocking Concurrency, Locks, and Isolation Levels
dbaplus Community
dbaplus Community
Sep 14, 2025 · Databases

Why MySQL Updates Sometimes Disappear: InnoDB Read View Explained

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.

InnoDBRead ViewUpdate Anomaly
0 likes · 16 min read
Why MySQL Updates Sometimes Disappear: InnoDB Read View Explained
政采云技术
政采云技术
Mar 28, 2023 · Databases

Understanding MVCC and Lock Mechanisms in MySQL

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.

InnoDBIsolation LevelsLocks
0 likes · 11 min read
Understanding MVCC and Lock Mechanisms in MySQL
IT Services Circle
IT Services Circle
Oct 27, 2022 · Databases

Understanding MVCC (Multiversion Concurrency Control) in MySQL InnoDB

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.

InnoDBMVCCRead View
0 likes · 9 min read
Understanding MVCC (Multiversion Concurrency Control) in MySQL InnoDB
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Oct 11, 2021 · Databases

Understanding MVCC and Transaction Isolation Levels in InnoDB

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
Understanding MVCC and Transaction Isolation Levels in InnoDB
Java Interview Crash Guide
Java Interview Crash Guide
Aug 23, 2021 · Databases

Understanding MySQL Isolation Levels and MVCC: A Deep Dive

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.

Isolation LevelsMVCCRead View
0 likes · 10 min read
Understanding MySQL Isolation Levels and MVCC: A Deep Dive