The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables The total time in microseconds used for relocating blocks of size  PAGE_SIZE . Reading from the table INNODB_CMPMEM_RESET  resets this count. The  INNODB_CMP_PER_INDEX  and  INNODB_CMP_PER_INDEX_RESET  tables provide status information on operations related to compressed  InnoDB  tables and indexes, with separate statistics for each 26.4.8 The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables Notes Example • RELOCATION_TIME mysql>  SELECT * FROM INFORMATION_SCHEMA.INNODB_CMPMEM\G *************************** 1. row *************************** page_size: 1024 buffer_pool_instance: 0 pages_used: 0 pages_free: 0 relocation_ops: 0 relocation_time: 0 *************************** 2. row *************************** page_size: 2048 buffer_pool_instance: 0 pages_used: 0 pages_free: 0 relocation_ops: 0 relocation_time: 0 *************************** 3. row *************************** page_size: 4096 buffer_pool_instance: 0 pages_used: 0 pages_free: 0 relocation_ops: 0 relocation_time: 0 *************************** 4. row *************************** page_size: 8192 buffer_pool_instance: 0 pages_used: 7673 pages_free: 15 relocation_ops: 4638 relocation_time: 0 *************************** 5. row *************************** page_size: 16384 buffer_pool_instance: 0 pages_used: 0 pages_free: 0 relocation_ops: 0 relocation_time: 0 •Use these tables to measure the effectiveness of  InnoDB  table compression in your database. •You must have the  PROCESS  privilege to query this table. •Use the  INFORMATION_SCHEMA COLUMNS  table or the  SHOW COLUMNS  statement to view additional information about the columns of this table, including data types and default values. •For usage information, see Section 15.9.1.4, “Monitoring InnoDB Table Compression at Runtime”  and Section 15.15.1.3, “Using the Compression Information Schema Tables” . For general information about InnoDB  table compression, see Section 15.9, “InnoDB Table and Page Compression” . 4855