qq_26235241的博客

原创 mysql查询索引使用情况

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为所要查询的表名