MySQL slow query log viewer, myslow.cgi

myslow.cgi thumbnailI wrote a MySQL slow query log viewer/analyzer called myslow.cgi in Perl. (screenshot, source)

It lets you slice and dice the slow query log and scores various parameters. It has some clever CSS to cut the emitted HTML in half.

Suggestions so far:

  1. Apachez has suggested I use a MySQL table for the logs. (I understand there’s an option in 5.1 to do that already.)
  2. firewire has suggested I combine similar SQL statements and compute statistics for each statement. Sounds good to me.

How to optimize subqueries and joins in MySQL
MySQL Query Profiler
MySQL log analyzer and profiler

This entry was posted in MySQL, Perl, Tech. Bookmark the permalink.

One Response to MySQL slow query log viewer, myslow.cgi

  1. You may want to check out mysql_explain_slow_log to analyse which indexes are used by the queries in your slow log.

    See Mysql tools

Comments are closed.