Mysql - logfile analysing: Difference between revisions
Jump to navigation
Jump to search
Created page with "Category:Linux = Mysql logfile analysis = == General log == This will focus on general log analysing. Will be using two fantastic tools: * pt-query-digest (on debian/ubu..." |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 9: | Line 9: | ||
* mysqlsla (must be downloaded: http://hackmysql.com/mysqlsla) | * mysqlsla (must be downloaded: http://hackmysql.com/mysqlsla) | ||
=== pt-query-digest === | |||
Sample output for a general log analysis: | Sample output for a general log analysis: | ||
<pre> | <pre> | ||
pt-query-digest --type=genlog mysql-general.log | pt-query-digest --type=genlog --filter '$event->{db} eq "wp-site42"' mysql-general.log | ||
</pre> | |||
=== mysqlsla === | |||
<pre> | |||
./mysqlsla --log-type general mysql-general.log | |||
</pre> | </pre> | ||
Latest revision as of 11:39, 13 March 2014
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