Find duplicate indexes and foreign keys on MySQL tables.
Find duplicate indexes on a database:
pt-duplicate-key-checker -d database
Read queries from a log and analyze how they use indexes.
pt-index-usage /var/log/mysql/mysql-slow.log
Check MySQL configuration for suggested changes.
Analyze queries and advise on possible problems.