Mysql - logfile analysing
Jump to navigation
Jump to search
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 --log-type general mysql-general.log