How Meituan Built a Real‑Time Database Capacity Assessment System

Meituan's database team created a sandbox‑based capacity assessment platform that replays live traffic, uses accelerated replay to discover performance bottlenecks, and closes the loop with capacity monitoring and automated operations, dramatically improving stability and resource utilization.

Database CapacityPerformance Testingautomation

0 likes · 16 min read

How Meituan Built a Real‑Time Database Capacity Assessment System

Lobster Programming

Jul 31, 2024 · Databases

How to Estimate MySQL Single-Table Capacity: The 20 Million Row Rule Explained

This article breaks down the reasoning behind MySQL’s commonly cited 20 million‑row limit for a single table by analyzing page size, B+‑tree structure, storage overhead, and how leaf and index pages combine to estimate maximum row counts.

B+TreeDatabase CapacityStorage Estimation

0 likes · 5 min read

How to Estimate MySQL Single-Table Capacity: The 20 Million Row Rule Explained

21CTO

Oct 21, 2021 · Databases

Why Is Database Capacity Planning So Hard? Simplify with ScyllaDB

This article explains why sizing a database cluster is challenging, outlines a step‑by‑step methodology for estimating workload, configuration and performance, discusses the impact of consistency levels, secondary indexes, materialized views and maintenance, and shows how ScyllaDB can be used to model and simplify capacity planning.

ConsistencyDatabase CapacityNoSQL

0 likes · 16 min read

Why Is Database Capacity Planning So Hard? Simplify with ScyllaDB

How Meituan Built a Real‑Time Database Capacity Assessment System

How to Estimate MySQL Single-Table Capacity: The 20 Million Row Rule Explained

Why Is Database Capacity Planning So Hard? Simplify with ScyllaDB

How to Estimate MySQL Single-Table Capacity: The 20 Million Row Rule Explained