contain status information on the compressed pages that reside
in the buffer pool. Please consult
Chapter 3, InnoDB Data Compression for further information on
compressed tables and the use of the buffer pool. The tables
should provide more useful statistics on compression.
The InnoDB storage engine uses a so-called “buddy allocator” system to manage memory allocated to pages of various sizes, from 1KB to 16KB. Each row of the two tables described here corresponds to a single page size.
These two tables have identical contents, but reading from
resets the statistics on relocation operations. For example, if
every 60 minutes you archived the output of
it would show the hourly statistics. If you never read
and monitored the output of
instead, it would show the cumulated statistics since InnoDB was
For the table definition, see Columns of INNODB_CMPMEM and INNODB_CMPMEM_RESET.