BestHub
Sign in
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 ReadInnoDBMVCC
0 likes · 14 min read
Understanding Consistent Reads and MVCC in MySQL InnoDB
ITPUB
ITPUB
Jun 24, 2016 · Databases

How Oracle Uses Undo to Provide Consistent Reads and Recover Transactions

This article explains Oracle's undo mechanism, detailing how it enables consistent reads, supports transaction rollback, and facilitates instance recovery by tracking SCN numbers and chaining undo blocks to reconstruct past data states.

Consistent ReadDatabase RecoveryOracle
0 likes · 10 min read
How Oracle Uses Undo to Provide Consistent Reads and Recover Transactions