Search⌘ K
AI Features
Home
Courses
Deep Dive into the Internals of the Database

Multiversion Concurrency Control

Explore how multiversion concurrency control (MVCC) manages multiple data versions to provide consistent database snapshots. Learn how MVCC uses transaction IDs to isolate changes, prevent nonrepeatable reads, and maintain data integrity during concurrent operations.

We'll cover the following...

Introduction

Multiversion concurrency control (MVCC) is a concurrency control technique that allows multiple versions of the same record to exist simultaneously during a given time and provides a consistent view of the database at a point in the past identified by the timestamp.

With this method, every active transaction in the database sees a snapshot of the data at that point. The new transactions won’t see any changes made by other transactions until the database commits the transaction.

In addition, multiversion concurrency control techniques prevent nonrepeatable reads problems.

Implementation

When a database transaction starts, the database generates a unique, monotonically increasing ...