pt-duplicate-key-checker

pt-duplicate-key-checker is a command-line tool to find duplicate indexes and foreign keys on MySQL tables.

ref:
https://www.percona.com/doc/percona-toolkit/2.2/pt-duplicate-key-checker.html

# check all tables
$ pt-duplicate-key-checker --user=abc --password=123 --databases=streetvoice

# check specific tables
$ pt-duplicate-key-checker --user=abc --password=123 --databases=streetvoice --tables=svapp_like