Deadlocks

MySQL Concurrency: MVCC, Lock Waits, and Deadlocks in One Example

Use two sessions to understand snapshot reads and conflicting updates, inspect deadlocks, and design retries at the transaction boundary.