tables provide status information about operations related to
compressed tables, which are described in
Section 14.9, “InnoDB Table and Page Compression”. The
PAGE_SIZE column reports the compressed
These two tables have identical contents, but reading from
resets the statistics on compression and uncompression
operations. For example, if you archive the output of
every 60 minutes, you see the statistics for each hourly period.
If you monitor the output of
INNODB_CMP (making sure never to
you see the cumulative statistics since InnoDB was started.
For the table definition, see Section 24.32.4, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”.