innodb_index_stats

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

mysql> select * from mysql.innodb_index_stats WHERE        database_name='test' and table_name='recordsInRangeTest'; +---------------+--------------------+--------------+---------------------+--------------+------------+-------------+-----------------------------------+ | database_name | table_name         | index_name   | last_update         | stat_name    | stat_value | sample_size | stat_description                  | +---------------+--------------------+--------------+---------------------+--------------+------------+-------------+-----------------------------------+ | test          | recordsInRangeTest | PRIMARY      | 2018-07-14 04:27:29 | n_diff_pfx01 |      24290 |          20 | id                                | | test          | recordsInRangeTest | PRIMARY      | 2018-07-14 04:27:29 | n_leaf_pages |         55 |        NULL | Number of leaf pages in the index | | test          | recordsInRangeTest | PRIMARY      | 2018-07-14 04:27:29 | size         |         97 |        NULL | Number of pages in the index      | | test          | recordsInRangeTest | idx_age      | 2018-07-14 04:27:29 | n_diff_pfx01 |          6 |          29 | age                               | | test          | recordsInRangeTest | idx_age      | 2018-07-14 04:27:29 | n_diff_pfx02 |      24576 |          29 | age,id                            | | test          | recordsInRangeTest | idx_age      | 2018-07-14 04:27:29 | n_leaf_pages |         29 |        NULL | Number of leaf pages in the index | | test          | recordsInRangeTest | idx_age      | 2018-07-14 04:27:29 | size         |         30 |        NULL | Number of pages in the index      | | test          | recordsInRangeTest | idx_age_name | 2018-07-14 04:27:29 | n_diff_pfx01 |          6 |          30 | name                              | | test          | recordsInRangeTest | idx_age_name | 2018-07-14 04:27:29 | n_diff_pfx02 |         11 |          30 | name,age                          | | test          | recordsInRangeTest | idx_age_name | 2018-07-14 04:27:29 | n_diff_pfx03 |      24576 |          30 | name,age,id                       | | test          | recordsInRangeTest | idx_age_name | 2018-07-14 04:27:29 | n_leaf_pages |         30 |        NULL | Number of leaf pages in the index | | test          | recordsInRangeTest | idx_age_name | 2018-07-14 04:27:29 | size         |         31 |        NULL | Number of pages in the index      | | test          | recordsInRangeTest | idx_name     | 2018-07-14 04:27:29 | n_diff_pfx01 |          6 |          25 | name                              | | test          | recordsInRangeTest | idx_name     | 2018-07-14 04:27:29 | n_diff_pfx02 |      24576 |          25 | name,id                           | | test          | recordsInRangeTest | idx_name     | 2018-07-14 04:27:29 | n_leaf_pages |         25 |        NULL | Number of leaf pages in the index | | test          | recordsInRangeTest | idx_name     | 2018-07-14 04:27:29 | size         |         26 |        NULL | Number of pages in the index      | +---------------+--------------------+--------------+---------------------+--------------+------------+-------------+-----------------------------------+