macrozheng

Aug 18, 2020 · Databases

Mastering MySQL Passive Performance Optimization: Principles & Practical Solutions

This article explains the core principles of performance optimization, distinguishes active and passive approaches, and provides detailed MySQL passive tuning techniques—including index usage, data partitioning, slow‑query logging, and read/write splitting—to prevent and resolve slow SQL queries.