0 views collected around this technical thread.
Thread dumps provide a snapshot of all active JVM threads, including their state, stack trace, and metadata, enabling developers to diagnose performance issues such as slow responses, high CPU usage, deadlocks, and thread pool inefficiencies by examining key fields and applying practical analysis techniques.
This article explains how MySQL's InnoDB deadlock detection thread works, when it checks for deadlocks based on the innodb_deadlock_detect variable, how it discovers lock‑wait cycles, performs a secondary verification using snapshot and slot information, and finally summarizes the overall process.
This article explains MySQL's Metadata Lock (MDL) subsystem, describing how MDL protects metadata, the lock types and modes, the transaction‑level implementation introduced in MySQL 5.5 and refined in 5.7, the lock acquisition and release algorithms, deadlock detection mechanisms, and the lock‑free hash table used to store lock objects.