系统表介绍
INNODB_CMP 记录了后压缩innodb 表信息，并提供充值功能.
| 列名 | 含义 |
|---|---|
| page_size | 页大小 |
| compress_ops | 压缩次数 |
| compress_ops_ok | 成功进行压缩的次数 |
| compress_time | 压缩时间 |
| uncompress_ops | 解压缩次数 |
| uncompress_time | 解压缩时间 |
实例
mysql> select * from INNODB_CMP_RESET ;
+-----------+--------------+-----------------+---------------+----------------+-----------------+
| page_size | compress_ops | compress_ops_ok | compress_time | uncompress_ops | uncompress_time |
+-----------+--------------+-----------------+---------------+----------------+-----------------+
| 1024 | 0 | 0 | 0 | 0 | 0 |
| 2048 | 0 | 0 | 0 | 0 | 0 |
| 4096 | 0 | 0 | 0 | 0 | 0 |
| 8192 | 0 | 0 | 0 | 0 | 0 |
| 16384 | 0 | 0 | 0 | 0 | 0 |
+-----------+--------------+-----------------+---------------+----------------+-----------------+
5 rows in set (0.00 sec)