Root Cause Analysis of MySQL InnoDB Thread Concurrency Blocking and Nanosleep Behavior

The article investigates a MySQL 8.0 instance where many sessions were stuck in the executing state, analyzes InnoDB thread‑concurrency settings, stack traces and source code to reveal that exhausted InnoDB tickets caused nanosleep‑based blocking, and proposes configuration and SQL‑optimisation solutions.

InnoDBSQLdatabase

0 likes · 11 min read

Root Cause Analysis of MySQL InnoDB Thread Concurrency Blocking and Nanosleep Behavior

Aikesheng Open Source Community

Oct 14, 2019 · Databases

Analyzing MySQL InnoDB Thread Concurrency Issues and Their Resolution

This article examines a MySQL performance problem where frequent requests become unresponsive, analyzes processlist, system I/O/CPU metrics, and pstack traces to identify InnoDB thread concurrency and concurrency tickets as the root cause, then explains the relevant parameters, configuration guidelines, and a simulated test to demonstrate the solution.

DebuggingInnoDBSQL

0 likes · 25 min read

Analyzing MySQL InnoDB Thread Concurrency Issues and Their Resolution