MySQL查看哪些索引未使用

SELECTOBJECT_SCHEMA,OBJECT_NAME,INDEX_NAMEFROM performance_schema.table_io_waits_summary_by_index_usageWHERE INDEX_NAME IS NOT NULLAND COUNT_STAR = 0AND OBJECT_SCHEMA <> 'mysql'ORDER BY OBJECT_SCHEMA,OBJECT_NAME;

参考网络资料：https://www.cnblogs.com/cchust/p/5061131.html