mysqlidxchk (MySQL Index Checker) checks MySQL databases/tables for unused indexes.
Given one or more slow, general, or "raw" log files, mysqlidxchk reports which
indexes in the database schema are not used by the queries in the log files.
Latest version November 11 2007 v1.1 (changelog
View and save mysqlidxchk
from your web browser
— or —
wget hackmysql.com/scripts/mysqlidxchk-1.1 from your terminal
Help With mysqlidxchk
mysqlidxchk has not been extensively tested in the real world. Although it
shouldn't do any harm to your server, don't expect it to work perfectly.
Please report any bugs
or other problems that you encounter.
And please also read mysqlidxchk Bugs & Problems