Aikesheng Open Source Community

Nov 20, 2024 · Databases

InnoDB Lock Analysis for INSERT … ON DUPLICATE KEY UPDATE (Repeatable‑Read and Read‑Committed)

This article examines how InnoDB acquires various row, gap, and next‑key locks during INSERT … ON DUPLICATE KEY UPDATE statements under REPEATABLE‑READ and READ‑COMMITTED isolation levels, illustrating the lock behavior with detailed SQL examples and performance‑schema queries.