View Source EctoMySQLExtras.UnusedIndexes (Ecto MySQL Extras v0.6.2)
Query all unused indexes.
Data is retrieved from the performance_schema
database and the table_io_waits_summary_by_index_usage
table.
The database should be running for a while since unused indexes are tracked based on IO activity.
An index is considered unused when it has 0 hits and almost unused when it has 50 hits or less. The latter can however
be configured by passing: min_hits
as an argument. Also indexes of small tables (less than 5 pages) are excluded.
Primary keys are excluded from the query.
Summary
Functions
Callback implementation for EctoMySQLExtras.info/0
.
Callback implementation for EctoMySQLExtras.query/1
.
Functions
Callback implementation for EctoMySQLExtras.info/0
.
Callback implementation for EctoMySQLExtras.query/1
.