mysql查询索引使用情况

3/3/2017来源:C/C++教程人气:3019

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 where OBJECT_NAME = ‘t_area’; t_ara为所要查询的表名 第三个索引无视

TABLE culturalbase yu PRIMARY 1 1 1 TABLE culturalbase yu uq_yu_y_name 0 0 0 TABLE culturalbase yu [null] 0 0 0