I am looking to change indices on my MySQL table. My hunch was that one of the indices, that I am looking to remove, shouldn't be used. But it is being used, based on
I want to find queries that use this index so I can reason what would happen to such queries and if they will fallback to another existing index.
Is there a place where MySQL stores query plans? Or any other way of finding the queries that use a given index?