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.

ON DUPLICATE KEY UPDATEdeadlocklocking mechanism

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.

Concurrency ControlInnoDBTable Locks

0 likes · 15 min read

Understanding InnoDB Table Lock Acquisition in MySQL 8.0.32

NetEase Yanxuan Technology Product Team

Mar 29, 2021 · Operations

How Yanxuan Designs a Multi‑Layer Inventory System for Seamless E‑Commerce

This article examines Yanxuan's inventory management challenges and presents a layered design—warehouse, physical, and sales layers—combined with a flexible lock‑stock pool to support multi‑channel, multi‑warehouse operations while addressing promotional and special‑use inventory requirements.

Layered DesignOperationse‑commerce

0 likes · 14 min read

How Yanxuan Designs a Multi‑Layer Inventory System for Seamless E‑Commerce