myslog
MySQL slow query log parser
Install
gem install myslog
Usage
myslog = MySlog.new
f = open("mysql-slow-query.log")
lines = f.read.split("\n")
f.close
logs = myslog.parse(lines)
logs
is Array of Hash
log = logs.first
log[:date]
log[:user]
log[:host]
log[:host_ip]
log[:query_time]
log[:lock_time]
log[:rows_sent]
log[:rows_examined]
log[:sql]