mysqlidxchk

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.

Download mysqlidxchk

Latest version Mar 29 2007 v1.0 (changelog)
Download mysqlidxchk with documentation and guide tar/gz or zip
— or —
View and save mysqlidxchk from your web browser
— or —
wget hackmysql.com/scripts/mysqlidxchk from your terminal

Help With mysqlidxchk

Guide To Using mysqlidxchk: Quick and basic guide demonstrating how to use mysqlidxchk. Also covers common problems and pitfalls.

mysqlidxchk Documentation: Detailed explanation for all mysqlidxchk command line options.

mysqlidxchk Bugs & Problems: If mysqlidxchk will not work for you, please read this brief guide to submitting bug and problem reports.

Version 1.0 Means Debug

mysqlidxchk is brand new and although I have spent weeks running it through trials and tribulations, the first release version of any program is bound to have a few bugs.

Please do not hesitate to contact me about bugs and problems. And please also read mysqlidxchk Bugs & Problems.