在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='Meb_User';
看count_star,count_read,COUNT_FETCH 这三个值没有增加
在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='Meb_User';
看count_star,count_read,COUNT_FETCH 这三个值没有增加