系统表介绍
INNODB_CMP 记录了压缩innodb 表信息.
列名 | 含义 |
---|---|
page_size | 页大小 |
compress_ops | 压缩次数 |
compress_ops_ok | 成功进行压缩的次数 |
compress_time | 压缩时间 |
uncompress_ops | 解压缩次数 |
uncompress_time | 解压缩时间 |
实例
mysql> select * from INNODB_CMP ;
+-----------+--------------+-----------------+---------------+----------------+-----------------+
| 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)