MySQL 9.0 Reference Manual Including MySQL NDB Cluster 9.0
There are two pairs of InnoDB
INFORMATION_SCHEMA tables about compression
that can provide insight into how well compression is working
overall:
INNODB_CMP and
INNODB_CMP_RESET provide
information about the number of compression operations and the
amount of time spent performing compression.
INNODB_CMPMEM and
INNODB_CMPMEM_RESET provide
information about the way memory is allocated for compression.