Tagged articles

B-Link Tree

2 articles · Page 1 of 1

Apr 4, 2024 · Databases

Why MySQL Tables Stall After 20 Million Rows and How B‑Link Trees Fix It

The article examines why MySQL performance drops sharply when a single table exceeds tens of millions of rows, debunks the index‑depth myth, explains SMO concurrency limits in InnoDB, and shows how B‑Link Tree indexes and heap‑organized tables can overcome these bottlenecks.

B-Link TreeB-TreeInnoDB

0 likes · 10 min read

Why MySQL Tables Stall After 20 Million Rows and How B‑Link Trees Fix It

MaGe Linux Operations

Feb 26, 2024 · Databases

Why MySQL Single Tables Hit Performance Limits and How B‑Link Trees Help

This article examines the technical reasons why MySQL single tables struggle with massive data volumes, debunks the index‑depth myth, explains InnoDB's SMO concurrency bottlenecks, and shows how B‑Link Tree indexes and heap‑organized tables in GaussDB provide superior performance for large‑scale workloads.

B-Link TreeB-TreeGaussDB

0 likes · 10 min read

Why MySQL Single Tables Hit Performance Limits and How B‑Link Trees Help

B-Link Tree

Why MySQL Tables Stall After 20 Million Rows and How B‑Link Trees Fix It

Why MySQL Single Tables Hit Performance Limits and How B‑Link Trees Help

Why MySQL Tables Stall After 20 Million Rows and How B‑Link Trees Fix It