How does MVCC work? How is it different from lock-based concurrency control?

Answer preview

Multi-Version Concurrency Control (MVCC) keeps multiple physical versions of each row so that every transaction reads a consistent snapshot of the database instead of waiting for a lock. Its defining property: readers never block writers and writers never block readers.…