BestHub
Sign in
Tagged articles

slow SQL

11 articles · Page 1 of 1
Java Architect Essentials
Java Architect Essentials
May 21, 2026 · Backend Development

Building a High‑Performance SpringBoot Log Analyzer for Slow SQL Detection from Scratch

Faced with massive MyBatis log files that made manual slow‑SQL hunting impossible, the author designed a SpringBoot‑Vue‑MySQL system that parses logs with multithreaded batch processing, flexible regex templates, real‑time performance monitoring, and virtual‑scroll UI, achieving 55 000 lines/s throughput and over 95% matching accuracy.

MyBatisRegexSpring Boot
0 likes · 11 min read
Building a High‑Performance SpringBoot Log Analyzer for Slow SQL Detection from Scratch
Ubiquitous Tech
Ubiquitous Tech
Oct 31, 2024 · Databases

Deep Dive into JD’s sql-analysis Slow‑SQL Component Architecture

This article provides a detailed walkthrough of JD’s open‑source sql‑analysis component, dissecting its eight functional modules, MyBatis interceptor flow, SQL extraction logic, query‑plan analysis, rule‑based scoring, and output strategies, while highlighting design patterns and potential extension points for developers.

MyBatisOpen Sourcejava
0 likes · 15 min read
Deep Dive into JD’s sql-analysis Slow‑SQL Component Architecture
Ubiquitous Tech
Ubiquitous Tech
Oct 28, 2024 · Databases

Detecting and Preventing Slow SQL with JD’s Open‑Source sql‑analysis Component

This article introduces JD’s open‑source sql‑analysis component, explains its design based on a MyBatis interceptor, demonstrates how it analyzes SQL execution plans with Explain and a rule engine to warn about potential slow queries, and shows step‑by‑step usage and its advantages for early detection and rapid hot‑swap remediation.

EXPLAINMyBatisOpen Source
0 likes · 14 min read
Detecting and Preventing Slow SQL with JD’s Open‑Source sql‑analysis Component
ITPUB
ITPUB
Aug 10, 2024 · Backend Development

Why Did Our Backend Freeze? A Deep Dive into Connection‑Pool Exhaustion and Slow SQL

A detailed post‑mortem of a three‑time service outage reveals how hidden bugs, frequent FullGC, a saturated connection pool, and an unindexed slow SQL query crippled a Spring Boot backend, and shows the step‑by‑step troubleshooting, temporary fixes, and lasting improvements applied.

backendconnection-poolslow SQL
0 likes · 11 min read
Why Did Our Backend Freeze? A Deep Dive into Connection‑Pool Exhaustion and Slow SQL
JD Cloud Developers
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 GovernanceRead Replicasslow SQL
0 likes · 20 min read
Cutting MySQL Disk Usage by 10% and Reducing QPS by 30%: A Real‑World Case Study
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.

Connection PoolDebuggingbackend
0 likes · 10 min read
Root Cause Analysis of Repeated Backend Service Outages: Connection Pool Exhaustion and Slow SQL
ITPUB
ITPUB
Jan 19, 2022 · Databases

How a Startup Solved Midnight MySQL Timeouts: Slow‑SQL Diagnosis & Caching

During nightly peaks, a social‑e‑commerce startup experienced hour‑long service outages due to MySQL timeouts; by analyzing traffic spikes, CPU usage, and slow‑SQL logs, the team identified un‑cached ranking queries and a 20‑minute cache refresh bottleneck, then implemented targeted caching, monitoring scripts, and fallback static pages to eliminate the issue.

MySQLcachingincident analysis
0 likes · 14 min read
How a Startup Solved Midnight MySQL Timeouts: Slow‑SQL Diagnosis & Caching
Alibaba Cloud Developer
Alibaba Cloud Developer
Sep 23, 2021 · R&D Management

How to Win Collaboration: From Slow SQL Governance to POS Standardization

This article shares practical collaboration strategies through real‑world cases, explaining why framing proposals around others' benefits, identifying the right partners, and aligning mutual goals can turn complex technical challenges—like slow‑SQL governance and barcode‑scale integration—into successful joint projects.

Case studyPOS integrationR&D Management
0 likes · 9 min read
How to Win Collaboration: From Slow SQL Governance to POS Standardization
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.

MySQLThread-Poolperformance-tuning
0 likes · 14 min read
Root Cause Analysis and Optimization of Slow SQL in Meituan‑Dianping MySQL Thread‑Pool