Skip to content
All concepts

Concept

MVCC

Multi-version concurrency control lets readers and writers work at the same time without blocking each other. An update does not overwrite a row: it adds a new version, and each transaction sees the versions that were current when it began. Old versions have to be cleaned up later, and a transaction left open stops that cleanup.

Watch each update leave an old row version behind, and the clean-up job clear them. A live step from the lesson MVCC (Databases). Timings and counts are illustrative.

Where you'll see it