Tagged articles

Consistent Read

2 articles · Page 1 of 1
Hujiang Technology
Hujiang Technology
May 8, 2018 · Databases

Understanding Consistent Reads and MVCC in MySQL InnoDB

This article explains how MySQL InnoDB implements consistent reads using multi‑version concurrency control (MVCC), detailing isolation levels, undo‑log mechanics, hidden columns, rollback segments, transaction commit behavior, and the impact on SELECT, INSERT, UPDATE, and DELETE operations.

Consistent ReadDatabaseInnoDB
0 likes · 14 min read
Understanding Consistent Reads and MVCC in MySQL InnoDB