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 ...

Get Mastering MariaDB now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial