JD Tech Talk
Jul 30, 2024 · Databases
Database Performance Optimization and Governance for a High‑Load Application
This technical report analyzes a high‑traffic MySQL deployment with three servers, detailing disk usage, table space, QPS and slow‑SQL issues, and presents a comprehensive governance plan that includes data migration, read‑traffic offloading to replicas, MyBatis interceptor implementation, JSF monitoring, and Python automation to reduce disk pressure and improve query performance.
Database OptimizationMySQLdata migration
0 likes · 18 min read