Meituan Technology Team

Apr 21, 2022 · Databases

Meituan's Cost-Based Optimizer for Slow Query Index Recommendation

The article explains how Meituan uses MySQL's cost‑based optimizer to analyze slow queries, generate virtual index candidates, evaluate their costs with detailed statistics, and deploy a recommendation system that validates, tracks, and governs index suggestions to reduce CPU/IO waste and prevent database failures.