Tagged articles
5 articles
Page 1 of 1
Sohu Tech Products
Sohu Tech Products
May 14, 2025 · Databases

How to Quickly Diagnose MySQL InnoDB Deadlocks in 3 Simple Steps

This guide walks you through locating the deadlock log, analyzing its contents to determine the time, order, and involved SQL statements, and pinpointing the root cause of MySQL InnoDB deadlocks, including special locking scenarios and how to interpret lock structures.

InnoDBLock Analysisdatabase troubleshooting
0 likes · 16 min read
How to Quickly Diagnose MySQL InnoDB Deadlocks in 3 Simple Steps
dbaplus Community
dbaplus Community
Nov 27, 2022 · Databases

Unraveling MySQL InnoDB Deadlocks in Video Conference Sessions

A detailed investigation of intermittent MySQL InnoDB deadlocks occurring during video‑conference session creation, covering log extraction, lock analysis, source‑code debugging, reproducible test cases, and a simple code change that eliminates the deadlock while explaining the underlying locking mechanisms.

InnoDBLock Analysisdatabase
0 likes · 22 min read
Unraveling MySQL InnoDB Deadlocks in Video Conference Sessions
Xianyu Technology
Xianyu Technology
Jun 2, 2020 · Backend Development

Diagnosing and Resolving Random JVM Hang Issues in a High-Concurrency Application

The article outlines a six‑step method for diagnosing sporadic JVM hangs in a high‑concurrency Xianyu service—starting with code review, live state capture, I/O checks, lock analysis, resource‑exhaustion assessment, and finally framework thread‑pool tuning—to uncover lost‑lock behavior and severe thread‑pool imbalance that cause prolonged lock waits despite low CPU load.

JVMLock AnalysisThread Dump
0 likes · 12 min read
Diagnosing and Resolving Random JVM Hang Issues in a High-Concurrency Application
Youzan Coder
Youzan Coder
Jan 25, 2019 · Databases

Analyzing MySQL Deadlock Logs: A Step-by-Step Guide

The guide walks through creating a sample InnoDB table, reproducing a delete‑vs‑insert deadlock, and dissecting the SHOW ENGINE INNODB STATUS output to explain lock modes such as X, S, GAP and INSERT‑INTENTION, showing how one transaction’s IX lock and another’s X lock on the same index create a classic deadlock and why understanding these modes is crucial for diagnosis.

InnoDBLock Analysisdatabase
0 likes · 8 min read
Analyzing MySQL Deadlock Logs: A Step-by-Step Guide