mysqlsla

mysqlsla is a parser of MySQL/MariaDB slow, binary, and microslow logs. It filters and analyzes logs in order to create a custom report from the desired logs and their meta-property values.

To install mysqlsla, get the latest version, install it, and create a symbolic link in order to get it in your classic PATH environment:

> wget http://hackmysql.com/scripts/mysqlsla
> chmod +x mysqlsla

You're now ready to make a report from the slow query logs; for example:

> mysqlsla -lt slow /var/log/mysql/mariadb-slow.log
Report for msl logs: /var/log/mysql/mariadb-slow.log
183 queries total, 31 unique
Sorted by 't_sum'
Grand Totals: Time 559 s, Lock 0 s, Rows sent 460, Rows Examined 0


______________________________________________________________________ 001 ___
Count         : 11  (6.01%)
Time          : 558.794256 s total, 50.799478 s avg, 13.793118 s to 59.643728 s max  (99.98%)
  95% of Time : 499.150528 s total, 49.915053 s avg, 13.793118 s to 58.413305 s max
Lock Time (s...