Skip to content

MVCC (Multi-Version Concurrency Control)

MVCC (Multi-Version Concurrency Control) is a mechanism employed by database systems to manage concurrent data access^[600-developer__mysql.md].

Overview

Unlike traditional locking mechanisms that might force read transactions to wait for write transactions to complete (or vice versa), MVCC allows multiple versions of a data record to exist simultaneously. This approach enables readers to access data without acquiring locks, preventing them from being blocked by writers.^[600-developer__mysql.md]

  • [[Database Transactions]]
  • [[Concurrency Control]]
  • [[Database Isolation Levels]]

Sources

^[600-developer__mysql.md]