SELECT * FROM `STATISTICS`
TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | NON_UNIQUE | INDEX_SCHEMA | INDEX_NAME | SEQ_IN_INDEX | COLUMN_NAME | COLLATION | CARDINALITY | SUB_PART | PACKED | NULLABLE | INDEX_TYPE | COMMENT | INDEX_COMMENT | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
def | mysql | columns_priv | 0 | mysql | PRIMARY | 1 | Host | A | NULL | NULL | NULL | BTREE | ||||
def | mysql | columns_priv | 0 | mysql | PRIMARY | 2 | Db | A | NULL | NULL | NULL | BTREE | ||||
def | mysql | columns_priv | 0 | mysql | PRIMARY | 3 | User | A | NULL | NULL | NULL | BTREE | ||||
def | mysql | columns_priv | 0 | mysql | PRIMARY | 4 | Table_name | A | NULL | NULL | NULL | BTREE | ||||
def | mysql | columns_priv | 0 | mysql | PRIMARY | 5 | Column_name | A | 0 | NULL | NULL | BTREE | ||||
def | mysql | db | 0 | mysql | PRIMARY | 1 | Host | A | NULL | NULL | NULL | BTREE | ||||
def | mysql | db | 0 | mysql | PRIMARY | 2 | Db | A | NULL | NULL | NULL | BTREE | ||||
def | mysql | db | 0 | mysql | PRIMARY | 3 | User | A | 2 | NULL | NULL | BTREE | ||||
def | mysql | db | 1 | mysql | User | 1 | User | A | 1 | NULL | NULL | BTREE | ||||
def | mysql | event | 0 | mysql | PRIMARY | 1 | db | A | NULL | NULL | NULL | BTREE | ||||
def | mysql | event | 0 | mysql | PRIMARY | 2 | name | A | 0 | NULL | NULL | BTREE | ||||
def | mysql | func | 0 | mysql | PRIMARY | 1 | name | A | 0 | NULL | NULL | BTREE | ||||
def | mysql | help_category | 0 | mysql | PRIMARY | 1 | help_category_id | A | 40 | NULL | NULL | BTREE | ||||
def | mysql | help_category | 0 | mysql | name | 1 | name | A | 40 | NULL | NULL | BTREE | ||||
def | mysql | help_keyword | 0 | mysql | PRIMARY | 1 | help_keyword_id | A | 487 | NULL | NULL | BTREE | ||||
def | mysql | help_keyword | 0 | mysql | name | 1 | name | A | 487 | NULL | NULL | BTREE | ||||
def | mysql | help_relation | 0 | mysql | PRIMARY | 1 | help_keyword_id | A | NULL | NULL | NULL | BTREE | ||||
def | mysql | help_relation | 0 | mysql | PRIMARY | 2 | help_topic_id | A | 1092 | NULL | NULL | BTREE | ||||
def | mysql | help_topic | 0 | mysql | PRIMARY | 1 | help_topic_id | A | 535 | NULL | NULL | BTREE | ||||
def | mysql | help_topic | 0 | mysql | name | 1 | name | A | 535 | NULL | NULL | BTREE | ||||
def | mysql | innodb_index_stats | 0 | mysql | PRIMARY | 1 | database_name | A | 12 | NULL | NULL | BTREE | ||||
def | mysql | innodb_index_stats | 0 | mysql | PRIMARY | 2 | table_name | A | 12 | NULL | NULL | BTREE | ||||
def | mysql | innodb_index_stats | 0 | mysql | PRIMARY | 3 | index_name | A | 12 | NULL | NULL | BTREE | ||||
def | mysql | innodb_index_stats | 0 | mysql | PRIMARY | 4 | stat_name | A | 12 | NULL | NULL | BTREE | ||||
def | mysql | innodb_table_stats | 0 | mysql | PRIMARY | 1 | database_name | A | 4 | NULL | NULL | BTREE |