Aikesheng Open Source Community
Nov 6, 2024 · Databases
Understanding INSERT … ON DUPLICATE KEY UPDATE Locking in MySQL InnoDB (Repeatable‑Read vs Read‑Committed)
This article explains how MySQL 8.0.32 InnoDB handles INSERT … ON DUPLICATE KEY UPDATE under REPEATABLE‑READ and READ‑COMMITTED isolation levels, showing the preparation steps, lock acquisition process, and why the same exclusive record lock is obtained in both cases.
Duplicate Key UpdateInnoDBMySQL
0 likes · 7 min read