17.9 InnoDB Table and Page Compression (original) (raw)

This section provides information about theInnoDB table compression andInnoDB page compression features. The page compression feature is also referred to astransparent page compression.

Using the compression features of InnoDB, you can create tables where the data is stored in compressed form. Compression can help to improve both raw performance and scalability. The compression means less data is transferred between disk and memory, and takes up less space on disk and in memory. The benefits are amplified for tables withsecondary indexes, because index data is compressed also. Compression can be especially important for SSD storage devices, because they tend to have lower capacity thanHDD devices.