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
Jan
31
2017
Showing entries 1 to 1
Top 20 Authors
Frederic Descamps (8)Alena Subotina (7)
Joshua Otwell (6)
Michael McLaughlin (6)
Saroj Tripathy (6)
Dave Stokes (5)
Olivier Dasini (4)
Hardik Savani (3)
Jesper Krogh (3)
Ronald Bradford (3)
Kristian Köhntopp (2)
Mikael Ronström (2)
RoseHosting (2)
Andrew Grimo (1)
Daniel Nichter (1)
David Yeager (1)
Kedar Vaijanapurkar (1)
Keith Hollman (1)
Mahmud Ahsan (1)
Tiago L. Alves (1)