Locking Mechanism

Sohu Tech Products

Jan 8, 2025 · Databases

Analysis of MySQL Deadlock Issues in Multi-threaded Scenarios

The article investigates a MySQL deadlock that arises when multiple threads concurrently execute INSERT … ON DUPLICATE KEY UPDATE for logistics cancellations, reproduces the issue on MySQL 5.7 and 8.0, analyzes InnoDB lock handling and internal mini‑transactions, and explains how batch processing of each value leads to the deadlock.

DatabaseLocking MechanismMulti-threading

0 likes · 18 min read

Analysis of MySQL Deadlock Issues in Multi-threaded Scenarios

Aikesheng Open Source Community

Jun 12, 2024 · Databases

Understanding InnoDB Table Lock Acquisition in MySQL 8.0.32

This article explains how InnoDB determines whether a transaction already holds a table lock, acquires a mutex token, checks for blocking locks, and creates or reuses lock structures, detailing the complete table‑lock acquisition workflow in MySQL 8.0.32.

InnoDBLocking MechanismMySQL

0 likes · 15 min read

Understanding InnoDB Table Lock Acquisition in MySQL 8.0.32