MariaDB High Performance

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


______________________________________________________________________ ...