innodb_index_stats
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 | +---------------+--------------------+--------------+---------------------+--------------+------------+-------------+-----------------------------------+
MySQL限时解答,24小时内友哥专业解答
http://www.yougemysqldba.com
如有进一步需要请联系微信onesoft007
微博账号@友哥一指
http://www.yougemysqldba.com
如有进一步需要请联系微信onesoft007
微博账号@友哥一指