MySQL Tools


mysql_explain_log is part of the standard MySQL distribution. It can be used to feed general MySQL logs back into MySQL and use EXPLAIN on all statements to analyse which indexes have been used and which queries didn't use any index.

Here is a updated version that is not (yet) included in the MySQL distribution.

mysql_explain_log script (Perl)
mysql_explain_log.1 man page (nroff)
mysql_explain_log.html man page (HTML)


mysql_explain_slow_log can be used on MySQL slow logs, like mysql_explain_log on general logs.

mysql_explain_slow_log script (Perl)
mysql_explain_slow_log.1 man page (nroff)
mysql_explain_slow_log.html man page (HTML)


Last updated: 19. Nov 2013
Page maintained by Jan Willamowius
Imprint/Impressum · Privacy/Datenschutz
English: Home | Linux | Perl | Java | Eiffel | Books | Music | Jan Willamowius | Updates | Site Map
Deutsch: Home | Badminton | ISBN-Suche | Musik-Suche | Rezepte | Jan Willamowius