denrepo

MySQLIndexes

Unused indexes

Indexes with no recorded reads since the server started. Only meaningful after a representative period of uptime.

Not yet verified. How scripts are tested

b-my-unused.sql
1SELECT *2FROM sys.schema_unused_indexes3WHERE object_schema NOT IN ('mysql', 'sys', 'performance_schema');

Paste it into your query tool.

Open in denrepo