查看索引使用情况
show status like '%Handler_read%';
查看一个表下索引
show INDEX FROM 表名
查看索引是否被使用到
SELECT
object_type,
object_schema,
object_name,
index_name,
count_star,
count_read,
COUNT_FETCH
FROM
PERFORMANCE_SCHEMA.table_io_waits_summary_by_index_usage;
可查看指定账号在指定主机下的权限
show grants for 账号@'%';