Slow SQL | BestHub

JD Cloud Developers

Jul 30, 2024 · Databases

Cutting MySQL Disk Usage by 10% and Reducing QPS by 30%: A Real‑World Case Study

The article describes a high‑traffic core application with a MySQL master‑slave setup facing high resource usage; it details analysis of hardware, disk, table space, QPS, slow SQL, and presents governance actions including data archiving, moving reads to replicas, a MyBatis interceptor, and monitoring scripts, achieving significant performance improvements.

Database GovernanceMySQLPerformance Optimization

0 likes · 20 min read

Cutting MySQL Disk Usage by 10% and Reducing QPS by 30%: A Real‑World Case Study

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.

Connection PoolDatabaseDebugging

0 likes · 10 min read

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

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