Some time ago, I needed to parse some slow query logs from MySQL. Since I couldn’t find any decent solutions out there, I decided to hack my own formatter in the awesome Request-log-analyzer bij the Railsdoctors.
They recently included my formatter in the 1.5 version of R-L-A, so it’s just a matter of:
gem install request-log-analyzer
Visit r-l-a on github: http://github.com/wvanbergen/request-log-analyzer
View my formatter directly: http://github.com/wvanbergen/request-log-analyzer/blob/master/lib/request_log_analyzer/file_format/mysql.rb