Root Cause Analysis and Optimization of Slow SQL in Meituan‑Dianping MySQL Thread‑Pool

This article presents a detailed investigation of intermittent slow SQL queries observed in Meituan‑Dianping’s services, identifies the MySQL 5.6 thread‑pool as the primary cause, and demonstrates how adjusting thread‑pool parameters dramatically reduced slow‑query counts and improved overall service availability.

Thread-Poolmysqlperformance tuning

0 likes · 14 min read

Root Cause Analysis and Optimization of Slow SQL in Meituan‑Dianping MySQL Thread‑Pool

dbaplus Community

Aug 20, 2017 · Databases

How We Cut 98% of Slow MySQL Queries by Tuning Thread‑Pool Settings

This article walks through a real‑world MySQL performance case at Meituan‑Dianping, showing how systematic monitoring, packet capture, and step‑by‑step analysis identified the Thread‑Pool as the bottleneck and how disabling and fine‑tuning its parameters reduced slow queries from thousands to just a few dozen.

Database OptimizationSlow QueriesThread-Pool

0 likes · 16 min read

How We Cut 98% of Slow MySQL Queries by Tuning Thread‑Pool Settings