BestHub
search
Sign in
Tag

table splitting

1 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 15, 2021 · Databases

Vertical Partitioning in MySQL: Database, Schema, and Table Level Splitting

The article explains MySQL vertical partitioning techniques—including instance‑level database splitting, schema‑level splitting, and column‑level table splitting—detailing their advantages, drawbacks, and step‑by‑step command‑line procedures with code examples for implementing each method in production environments.

database shardingmysqlperformance optimization
0 likes · 12 min read
Vertical Partitioning in MySQL: Database, Schema, and Table Level Splitting
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jun 11, 2021 · Databases

When Do Database Tables Reach Bottlenecks and How to Split Them: Strategies, Cases, and Best Practices

This article explains how massive e‑commerce platforms identify the point at which database tables become performance bottlenecks, discusses vertical and horizontal sharding strategies, evaluates hash, range and consistent‑hash partitioning, and presents real‑world case studies from Suning, JD, Meituan, Ant Financial and Taobao.

case studiesdatabase shardingdistributed systems
0 likes · 16 min read
When Do Database Tables Reach Bottlenecks and How to Split Them: Strategies, Cases, and Best Practices