Database Internals Deep Dive

Question

This round probes DB internals deeply.

What this round covers

• MVCC, isolation levels, locking
• B-tree vs LSM storage; write/read amplification
• WAL/redo logs and crash recovery
• Replication (sync vs async) and failover

Tips

Ground answers in MySQL/Vitess. Show you understand the engine, not just the API.