Multi Version Concurrency Control (MVCC)
In a multi-user database imagine the following situation. While a transaction is reading multiple rows, let’s say from row 1 to row 1.000.000, another transaction updates row 1 and row 900.000 . We now assume that the first transaction finishes some time after the second one finishes. A problem could now be that transaction one … [Read more…]