How Meituan Merges Cost‑Based and AI‑Driven Index Recommendation for Billions of Slow Queries

Facing over a hundred million daily slow queries, Meituan’s Database Autonomous Service combines traditional cost‑based index selection with an AI‑powered, data‑driven classifier to automatically generate and validate missing indexes, achieving a 12.16% uplift in index adoption and saving thousands of hours of query execution time.

AIIndex Recommendationcost‑based optimization

0 likes · 16 min read

How Meituan Merges Cost‑Based and AI‑Driven Index Recommendation for Billions of Slow Queries

dbaplus Community

Jun 4, 2023 · Databases

How to Build an End‑to‑End SQL Defense and Capacity Forecast System

This article summarizes a technical presentation on innovative database practices, covering a preventive SQL defense framework, full‑SQL analysis for deep observation, and capacity prediction through simulated traffic testing, with detailed methods, challenges, and future plans for multi‑cloud environments.

Database GovernanceIndex Recommendationperformance optimization

0 likes · 16 min read

How to Build an End‑to‑End SQL Defense and Capacity Forecast System

DataFunSummit

Apr 13, 2023 · Databases

AI-Driven and Cost-Based Index Recommendation for Slow Queries at Meituan

This article describes Meituan's collaboration with East China Normal University to improve slow‑query performance by combining traditional cost‑based index recommendation with a novel AI‑plus‑data‑driven approach, detailing the overall architecture, modeling process, experimental results, and future plans for large‑model integration.

AIDatabase OptimizationIndex Recommendation

0 likes · 15 min read

AI-Driven and Cost-Based Index Recommendation for Slow Queries at Meituan

Meituan Technology Team

Apr 6, 2023 · Databases

AI-Driven Index Recommendation for Slow Queries at Meituan

This article details a joint research effort between Meituan and East China Normal University that combines cost‑based methods with AI‑driven, data‑centric models to automatically generate and evaluate missing indexes for billions of daily slow queries, improving recommendation accuracy and query performance.

AICost ModelIndex Recommendation

0 likes · 16 min read

AI-Driven Index Recommendation for Slow Queries at Meituan

dbaplus Community

May 10, 2022 · Databases

How Meituan Optimizes MySQL Slow Queries with Cost‑Based Index Recommendations

This article explains how Meituan tackles MySQL slow‑query problems by leveraging the database cost‑based optimizer to generate index suggestions, evaluate their quality, and operate a full‑stack governance workflow that includes data collection, statistical modeling, validation, and continuous improvement.

Database PerformanceIndex Recommendationcost‑based optimizer

0 likes · 23 min read

How Meituan Optimizes MySQL Slow Queries with Cost‑Based Index Recommendations

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.

Cost ModelDatabase OptimizationFakeindex

0 likes · 22 min read

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