Alex Rivera | Logout

What is Multiversion Concurrency Control (MVCC) and who supports it?

Asked 2008-08-26T07:04:21.657
49

Recently Jeff has posted regarding his trouble with database deadlocks related to reading. Multiversion Concurrency Control (MVCC) claims to solve this problem. What is it, and what databases support it?

updated: these support it (which others?)

  • oracle
  • postgresql
database deadlock terminology
Edit
Report

1 Answer

9

The following have an implementation of MVCC:

SQL Server 2005 (Non-default, SET READ_COMMITTED_SNAPSHOT ON)

Oracle (since version 8)

MySQL 5 (only with InnoDB tables)

PostgreSQL

Firebird

Informix

I'm pretty sure Sybase and IBM DB2 Mainframe/LUW do not have an implementation of MVCC

answered 2009-06-04T17:53:34.110

Your Answer