系统表介绍
提供了压缩innodb 表与索引时的状态信息,并单独提供表与索引的压缩信息。
列名 | 含义 |
---|---|
database_name | 数据库名 |
table_name | 表名 |
index_name | 索引名 |
compress_ops | 压缩次数 |
compress_ops_ok | 成功进行压缩的次数 |
compress_time | 压缩时间 |
uncompress_ops | 解压缩次数 |
uncompress_time | 解压缩时间 |
实例
mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_CMP_PER_INDEX\G
*************************** 1. row ***************************
database_name: employees
table_name: salaries
index_name: PRIMARY
compress_ops: 0
compress_ops_ok: 0
compress_time: 0
uncompress_ops: 23451
uncompress_time: 4
*************************** 2. row ***************************
database_name: employees
table_name: salaries
index_name: emp_no
compress_ops: 0
compress_ops_ok: 0
compress_time: 0
uncompress_ops: 1597
uncompress_time: 0