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