BestHub
Sign in
Tagged articles
3 articles
Page 1 of 1
dbaplus Community
dbaplus Community
Sep 22, 2025 · Databases

Why MySQL Tables Shouldn’t Exceed 10 Million Rows – A Deep Dive into InnoDB Pages & B+Tree Limits

This article explains why the industry advises keeping MySQL single‑table row counts below ten million by examining InnoDB’s 16KB page structure, B+‑tree indexing mechanics, fan‑out calculations, and how page size and row size together determine the practical limits and performance cliffs of large tables.

B+TreeDatabaseDesignInnoDB
0 likes · 20 min read
Why MySQL Tables Shouldn’t Exceed 10 Million Rows – A Deep Dive into InnoDB Pages & B+Tree Limits
dbaplus Community
dbaplus Community
Jan 27, 2022 · Databases

Why ClickHouse Beats Elasticsearch for Microservice Governance Data at Scale

The article examines the data‑storage problems caused by rapid microservice growth, explains why traditional Hadoop/Spark stacks were rejected, presents benchmark comparisons that show ClickHouse’s superior performance and compression, and details practical ClickHouse deployment, schema design, sharding, TTL, indexing, and monitoring integrations for real‑time analytics.

DataAnalyticsDatabaseDesignOLAP
0 likes · 27 min read
Why ClickHouse Beats Elasticsearch for Microservice Governance Data at Scale