Mysql - logfile analysing

Mysql logfile analysis

General log

This will focus on general log analysing.

Will be using two fantastic tools:

• pt-query-digest (on debian/ubuntu part of the percona-toolkit package)
• mysqlsla (must be downloaded: http://hackmysql.com/mysqlsla)

pt-query-digest

Sample output for a general log analysis:

pt-query-digest --type=genlog --filter '$event->{db} eq "wp-site42"' mysql-general.log

mysqlsla

./mysqlsla -lt general mysql-general.log