MySQL :: MySQL 9.1 Reference Manual :: 17.15.1 InnoDB INFORMATION

PDF (US Ltr) - 40.4Mb
PDF (A4) - 40.5Mb
Man Pages (TGZ) - 259.5Kb
Man Pages (Zip) - 366.7Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb

version 9.1

9.6
9.5
9.4
9.3
9.2
9.0
8.4 current
8.0
5.7

8.0 Japanese

MySQL 9.1 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

PDF (US Ltr) - 40.4Mb
PDF (A4) - 40.5Mb
Man Pages (TGZ) - 259.5Kb
Man Pages (Zip) - 366.7Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb