innodb_table_stats
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| database_name | varchar(64) | No | ||
| table_name | varchar(64) | No | ||
| last_update | timestamp | No | CURRENT_TIMESTAMP | |
| n_rows | bigint(20) | No | ||
| clustered_index_size | bigint(20) | No | ||
| sum_of_other_index_sizes | bigint(20) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | database_name | 4 | A | No | |
| table_name | 4 | A | No |