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=’tbl_dev_hosres’
可以查询索引运用了多少次
在查询前后,可以看相应索引有无变化以确认是否应用索引
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=’tbl_dev_hosres’
可以查询索引运用了多少次
在查询前后,可以看相应索引有无变化以确认是否应用索引