innodb_index_stats
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| database_name | varchar(64) | No | ||
| table_name | varchar(64) | No | ||
| index_name | varchar(64) | No | ||
| last_update | timestamp | No | CURRENT_TIMESTAMP | |
| stat_name | varchar(64) | No | ||
| stat_value | bigint(20) | No | ||
| sample_size | bigint(20) | Yes | NULL | |
| stat_description | varchar(1024) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | database_name | 12 | A | No | |
| table_name | 12 | A | No | |||||
| index_name | 12 | A | No | |||||
| stat_name | 12 | A | No |