本节提供有关 InnoDB 表压缩和 InnoDB 页压缩功能的信息。页压缩功能也称为 透明页压缩。This section provides information about the InnoDB table compression and InnoDB page compression features. The page compression feature is also referred to as transparent page compression.

使用 InnoDB 的压缩功能，可以创建数据以压缩形式存储的表。压缩可以帮助提高原始性能和可扩展性。压缩意味着在磁盘和内存之间传输的数据更少，并且在磁盘和内存中占用的空间更小。对于带有 二级索引 的表，这种好处会被放大，因为索引数据也会被压缩。对于 SSD 存储设备，压缩尤其重要，因为它们的容量通常比 HDD 设备小。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 with secondary indexes, because index data is compressed also. Compression can be especially important for SSD storage devices, because they tend to have lower capacity than HDD devices.