Encyclopedia

Multi-Version Concurrency Control

Multi-Version Concurrency Control

(database)
(MVCC) An advanced technique for improving multi-user database performance.

The main difference between multiversion and lock models is that in MVCC locks acquired for querying (reading) data don't conflict with locks acquired for writing data and so reading never blocks writing and writing never blocks reading.

This technique is used in the free software database PostgreSQL.
This article is provided by FOLDOC - Free Online Dictionary of Computing (foldoc.org)
Mentioned in
References in periodicals archive
Oracle Berkeley DB Release 4.5 now supports multi-version concurrency control, non-stop upgrades for replicated environments and a pre-built replication framework to simplify development of highly available applications.
* Multi-Version Concurrency Control -- improves performance of highly concurrent, mixed read/write systems by giving each user their own "snapshot" of the database and managing concurrent changes by many users.
Some of the topics covered are: Cache Friendly Web, The Apache Toolbox, MySQL Best Practices, Internationalization and Localization with PHP, Choosing a Templating System, PostgreSQL's Multi-Version Concurrency Control, Embedded and Linux.
Copyright © 2003-2025 Farlex, Inc Disclaimer
All content on this website, including dictionary, thesaurus, literature, geography, and other reference data is for informational purposes only. This information should not be considered complete, up to date, and is not intended to be used in place of a visit, consultation, or advice of a legal, medical, or any other professional.