Mysql - logfile analysing

From Skytech
Revision as of 11:39, 13 March 2014 by Martin (talk | contribs) (→‎mysqlsla)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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

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