MySQL :: MySQL 9.6 Reference Manual :: 17.15.1 InnoDB INFORMATION

PDF (US Ltr) - 41.8Mb
PDF (A4) - 41.9Mb
Man Pages (TGZ) - 272.4Kb
Man Pages (Zip) - 378.3Kb
Info (Gzip) - 4.2Mb
Info (Zip) - 4.2Mb

version 9.6

9.7 current
9.5
9.4
9.3
9.2
9.1
9.0
8.4
8.0
5.7

8.0 Japanese

MySQL 9.6 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) - 41.8Mb
PDF (A4) - 41.9Mb
Man Pages (TGZ) - 272.4Kb
Man Pages (Zip) - 378.3Kb
Info (Gzip) - 4.2Mb
Info (Zip) - 4.2Mb