MySQL Slow Log Analyzer

About the MySQL Slow Log Analyzer

MySQL Slow Log Analyzer is a Java-based (and therefore cross-platform) GUI interface for MySQL's slow query log.

Slow Log Analyzer features:

  • Lists unique queries in the log and aggregate data on each query
  • Select a query to view EXPLAIN details
  • Formats query SQL and parsed SQL automatically
  • Gives full deatil of MySQL EXPLAIN response
  • Remembers DB connection information
  • Self-contained -- copy to a thumb drive and take it anywhere, no installation necessary.

Requirements: Java 1.5.0 or newer (available free from Oracle), access to a MySQL database (for storing parsed log files), access to a copy of the database the log was generated for (for running EXPLAIN).

Latest Version

The current (beta) version of MySQL Slow Log Analyzer is v0.2.0. It is free to use (at your own risk) but not free to redistribute. Download MySQL Slow Log Analyzer v0.2.0 (1.4 MB).