MySQL 8.4 Release Notes
有两对关于压缩的 InnoDB INFORMATION_SCHEMA 表,可以提供有关整体压缩效果的洞察:There are two pairs of InnoDB
INFORMATION_SCHEMA tables about compression
that can provide insight into how well compression is working
overall:
INNODB_CMP和INNODB_CMP_RESET提供有关压缩操作次数以及执行压缩所花费时间的信息。INNODB_CMPandINNODB_CMP_RESETprovide information about the number of compression operations and the amount of time spent performing compression.INNODB_CMPMEM和INNODB_CMPMEM_RESET提供了关于压缩内存分配方式的信息。INNODB_CMPMEMandINNODB_CMPMEM_RESETprovide information about the way memory is allocated for compression.