PDF (A4) - 40.9Mb
Man Pages (TGZ) - 259.7Kb
Man Pages (Zip) - 366.9Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb
TheINNODB_CMPMEM andINNODB_CMPMEM_RESET tables provide status information about compressed pages that reside in the buffer pool. Please consultSection 17.9, “InnoDB Table and Page Compression” for further information on compressed tables and the use of the buffer pool. TheINNODB_CMP andINNODB_CMP_RESET tables should provide more useful statistics on compression.
Internal Details
InnoDB uses abuddy allocator system to manage memory allocated topages of various sizes, from 1KB to 16KB. Each row of the two tables described here corresponds to a single page size.
TheINNODB_CMPMEM andINNODB_CMPMEM_RESET tables have identical contents, but reading fromINNODB_CMPMEM_RESET resets the statistics on relocation operations. For example, if every 60 minutes you archived the output ofINNODB_CMPMEM_RESET, it would show the hourly statistics. If you never readINNODB_CMPMEM_RESET and monitored the output ofINNODB_CMPMEM instead, it would show the cumulative statistics sinceInnoDB was started.
For the table definition, seeSection 28.4.7, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”.
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 259.7Kb
Man Pages (Zip) - 366.9Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb