MySQL :: MySQL 8.4 Reference Manual :: 17.15.1 InnoDB INFORMATION

version 8.4

8.0 current
5.7

8.0 Japanese

MySQL 8.4 Reference Manual / ... / 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 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.

PREV HOME UP NEXT