select * from
performance_schema.table_io_waits_summary_by_index_usage
WHERE INDEX_NAME IS NOT NULL AND OBJECT_SCHEMA= ‘yourdatabasename’
order by COUNT_STAR desc

https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-wait-summary-tables.html