Monitoring the InnoDB compression performance

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:

• INNODB_CMPMEM: This table stores statistics about the compressed table pages in the buffer pool

• INNODB_CMP: This table stores information...