Mysql - logfile analysing: Difference between revisions

From Skytech
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

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