January 2019
Intermediate to advanced
286 pages
7h 41m
English
In the SYS schema, it is quite easy to find useless indexes using the schema_unused_indexes view:

This view is based on the performance_schema.table_io_waits_summary_by_index_usage table, which requires the activation of the performance schema, and of the events_waits_current variable and other dependencies, such as wait, io, table, and sql. Please note that primary indexes (keys) will be ignored.
If you have not enabled variables, I suggest you run these queries:

Read now
Unlock full access