mysql.innodb_index_stats
You are viewing an old version of this article. View
the current version here.
The mysql.innodb_index_stats
table contains the following fields:
Field | Type | Null | Key | Default | Description |
---|---|---|---|---|---|
database_name | varchar(64) | NO | PRI | NULL | |
table_name | varchar(64) | NO | PRI | NULL | |
index_name | varchar(64) | NO | PRI | NULL | |
last_update | timestamp | NO | current_timestamp() | on update current_timestamp() | |
stat_name | varchar(64) | NO | PRI | NULL | |
stat_value | bigint(20) unsigned | NO | NULL | ||
sample_size | bigint(20) unsigned | YES | NULL | ||
stat_description | varchar(1024) | NO | NULL |
Example
SELECT * FROM mysql.innodb_index_stats\G *************************** 1. row *************************** database_name: mysql table_name: gtid_slave_pos index_name: PRIMARY last_update: 2017-08-19 20:38:34 stat_name: n_diff_pfx01 stat_value: 0 sample_size: 1 stat_description: domain_id *************************** 2. row *************************** database_name: mysql table_name: gtid_slave_pos index_name: PRIMARY last_update: 2017-08-19 20:38:34 stat_name: n_diff_pfx02 stat_value: 0 sample_size: 1 stat_description: domain_id,sub_id *************************** 3. row *************************** database_name: mysql table_name: gtid_slave_pos index_name: PRIMARY last_update: 2017-08-19 20:38:34 stat_name: n_leaf_pages stat_value: 1 sample_size: NULL stat_description: Number of leaf pages in the index *************************** 4. row *************************** database_name: mysql table_name: gtid_slave_pos index_name: PRIMARY last_update: 2017-08-19 20:38:34 stat_name: size stat_value: 1 sample_size: NULL stat_description: Number of pages in the index *************************** 5. row *************************** database_name: test table_name: ft index_name: FTS_DOC_ID_INDEX last_update: 2017-09-15 12:58:39 stat_name: n_diff_pfx01 stat_value: 0 sample_size: 1 stat_description: FTS_DOC_ID *************************** 6. row *************************** database_name: test table_name: ft index_name: FTS_DOC_ID_INDEX last_update: 2017-09-15 12:58:39 stat_name: n_leaf_pages stat_value: 1 sample_size: NULL stat_description: Number of leaf pages in the index ...
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.