MySQL 8.3 Release Notes
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.