Tagged articles

Cold Archiving

2 articles · Page 1 of 1

Nov 2, 2023 · Databases

Optimizing Large MySQL Tables: Partitioning, Sharding, and Cold Archiving Strategies

This article explains how to evaluate MySQL table size, understand B+‑tree limitations, and improve query performance by using table partitioning, horizontal/vertical sharding, and hot‑cold data archiving, while also comparing the trade‑offs of each approach for practical selection.

B+TreeCold ArchivingMySQL

0 likes · 15 min read

Optimizing Large MySQL Tables: Partitioning, Sharding, and Cold Archiving Strategies

Code Ape Tech Column

Feb 22, 2023 · Databases

Managing Large MySQL Tables: Evaluation, Root Causes, and Optimization Strategies

This article explains how to assess MySQL table size, why massive tables degrade performance due to B+‑tree depth, and presents three practical solutions—table partitioning, database sharding, and hot‑cold data archiving—along with guidance on selecting the appropriate approach.

Cold ArchivingLarge TablesMySQL

0 likes · 14 min read

Managing Large MySQL Tables: Evaluation, Root Causes, and Optimization Strategies