Tencent Database Technology
Sep 7, 2020 · Databases
InnoDB Index Physical Space Usage Statistics and Page Scan Optimization
The article explains how CDB introduced an InnoDB index physical space usage statistic to help users decide when to run OPTIMIZE TABLE, describes the background of page fragmentation, compares incremental and full‑scan methods, and details a sequential I/O optimization that dramatically reduces measurement time.
Database performanceInnoDBOPTIMIZE TABLE
0 likes · 8 min read