14.16.1 InnoDB INFORMATION_SCHEMA Tables about Compression
There are two pairs of InnoDB
INFORMATION_SCHEMA
tables about compression that can provide insight into how well compression is working overall:
INNODB_CMP
andINNODB_CMP_RESET
provide information about the number of compression operations and the amount of time spent performing compression.INNODB_CMPMEM
andINNODB_CMPMEM_RESET
provide information about the way memory is allocated for compression.