Showing entries 1 to 1
Displaying posts with tag: 2PL (reset)
Jan
31
2017
A beginner’s guide to the Phantom Read anomaly, and how it differs between 2PL and MVCC
Posted by Vlad Mihalcea on Tue 31 Jan 2017 06:43 UTC
Tags:

Introduction Unlike SQL Server which, by default, relies on the 2PL (Two-Phase Locking) to implement the SQL standard isolation levels, Oracle, PostgreSQL, and MySQL InnoDB engine use MVCC (Multi-Version Concurrency Control). However, providing a truly Serializable isolation level on top of MVCC is really difficult, and, in this post, I’ll demonstrate that it’s very difficult … Continue reading A beginner’s guide to the Phantom Read anomaly, and how it differs between 2PL and MVCC →

Showing entries 1 to 1