🔷 TiDB Database Internals
TiDB is a distributed SQL database that separates compute (TiDB) from storage (TiKV/TiFlash), coordinated by PD. These visualizations help you understand the internals and tune for your workload.
✦ Live
Raft Region Size
The invisible lever for performance & recovery
✦ Live
LSM-Tree & Compaction
How TiKV stores data and manages write amplification
✦ Live
Distributed Transactions
Percolate 2PC: prewrite, commit, and lock resolution
Coming soon
Hot Regions & Load Balancing
PD scheduler: splitting, scattering, and rebalancing
Coming soon
TiFlash HTAP
Row store vs column store, when to use each
Coming soon
Coprocessor Push-Down
Moving computation to storage nodes
Coming soon
GC & MVCC
Multi-version concurrency and garbage collection
Coming soon
Backup & PITR
Full backups, incremental, and point-in-time recovery
Coming soon
SQL Execution Flow
From SQL text to result set, step by step
Coming soon
Placement Rules
Control where your data lives across datacenters