Index advisor tool - suggestion required

MySQL & MariaDB
1

Hi Team,

Is there any tool available in Percona to suggest index creation and identify unused indexes?

I am experiencing some performance issues in MariaDB and want to rearrange the indexes.

Thanks

2

Hello @alwaysdba,
If you have a good slow query log file, you can send that through pt-index-usage — Percona Toolkit Documentation which will run EXPLAIN on every query and let you know about indexes.

Additionally, pt-duplicate-key-checker — Percona Toolkit Documentation will run through all your tables/databases and report on any duplicate indexes.

1 Like
3

Thanks for your solution @matthewb, Let me try and analysis my slow queries.