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...