Database Management MySQL Subjective
Oct 01, 2025

Describe MySQL's multi-version concurrency control (MVCC).

Detailed Explanation

MVCC allows multiple transactions to access same data simultaneously without locking.

How it works:
• Each row has multiple versions
• Transactions see consistent snapshot
• Old versions kept in undo log
• Readers don't block writers

Benefits:
• High concurrency
• Consistent reads
• No read locks needed

Used in InnoDB with REPEATABLE READ isolation level.

Discussion (0)

No comments yet. Be the first to share your thoughts!

Share Your Thoughts
Feedback