BestHub
Sign in
Tag

slow-sql

0 views collected around this technical thread.

IT Services Circle
IT Services Circle
Jul 28, 2024 · Backend Development

Root Cause Analysis of Repeated Backend Service Outages: Connection Pool Exhaustion and Slow SQL

During a Monday incident where the backend service became unavailable three times, the author details step-by-step investigations—checking frontend responses, container status, JVM and thread pool metrics, and database connection pool usage—ultimately identifying a slow, unindexed SQL query that exhausted connections, and describes the remediation and lessons learned.

BackendConnection PoolDatabase
0 likes · 10 min read
Root Cause Analysis of Repeated Backend Service Outages: Connection Pool Exhaustion and Slow SQL
Qunar Tech Salon
Qunar Tech Salon
Aug 23, 2017 · Databases

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.

Database OptimizationMySQLPerformance Tuning
0 likes · 14 min read
Root Cause Analysis and Optimization of Slow SQL in Meituan‑Dianping MySQL Thread‑Pool