Aikesheng Open Source Community
Aug 19, 2020 · Databases
Understanding MySQL Compressed Tables: Concepts, Benefits, Limitations, and Practical Usage
This article explains the concept of MySQL compressed tables, highlights strong compression products, discusses why and when to use them, outlines their advantages and drawbacks, details supported compression algorithms, and provides step‑by‑step examples for both MyISAM and InnoDB engines along with their impact on B‑tree pages and the InnoDB buffer pool.
Compressed TablesDatabase OptimizationInnoDB
0 likes · 13 min read