check_unused_indexes

A Percona Lab tool that flags an index as unused only when every node in a MySQL replication topology agrees, including Aurora readers.


About

Statistics from a single server can make an index look unused when a replica still relies on it for reporting. check_unused_indexes discovers the replication topology from the primary and reports an index only if it’s unused on all nodes. It also skips indexes that back foreign keys, warns about recently restarted nodes, and generates ALTER INDEX ... INVISIBLE statements by default so changes are easy to roll back.

It’s written in Python and released under the Apache 2.0 license.

Category Software & Tools
Subcategory Schema Management & Migration, Monitoring & Observability
✎ Suggest an update

Community feedback

This space is for grounded, evaluable experience — versions used, environments, what you measured or observed, and how it behaves alongside other software. General impressions without supporting detail may be removed. Sign in to write one; posts are tied to a verified identity, not anonymous.