mysqlsla

mysqlsla (MySQL Statement Log Analyzer) analyzes MySQL slow and general log files. It also analyzes "raw" log files: flat files containing semi-colon new-line terminated SQL statements. For each type of log, mysqlsla generates a sortable report on valuable metrics calculated from the queries in the log. The report is useful for MySQL tuning and peformance optimization.

Download mysqlsla

Latest version Nov 8 2007 v1.7a (changelog)
Download the mysqlsla and documentation tar/gz
— or —
View and save mysqlsla from your web browser
— or —
wget hackmysql.com/scripts/mysqlsla-1.7a.tgz from your terminal
Special release: v1.8 DEBUG — Read the blog post mysqlsla: v1.8 released, v2 coming for more information about this special release.

mysqlsla Documentation

The mysqlsla Documentation outlines all the available command line options and lists known limitations.