The information_schema database contains some tables that can be used to monitor the performance of the InnoDB compressed tables. All these tables have their names starting with INNODB_CMP, so they can be listed with the following query:
MariaDB [information_schema]> SHOW TABLES LIKE 'INNODB_CMP%'; +--------------------------------------------+ | Tables_in_information_schema (INNODB_CMP%) | +--------------------------------------------+ | INNODB_CMP | | INNODB_CMP_RESET | | INNODB_CMP_PER_INDEX | | INNODB_CMPMEM_RESET | | INNODB_CMP_PER_INDEX_RESET | | INNODB_CMPMEM | +--------------------------------------------+ 6 rows in set (0.00 sec)
The main InnoDB tables are: