How to find all un-used indexes?

index

#1

By times we created a lot of index and I think some indexes are not in used anymore. Are then anyway to findout them ?

Thank you


#2

you can run all your queries with EXPLAIN and remove all indexes, which are not reported there.


#3

Normally developer create Queries, so as IT we dont’ know all of queries. If we can have report to by time for all report usage (the last use of an index), it would help much