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