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...") |
(No difference)
|
Revision as of 10:52, 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)
Sample output for a general log analysis:
pt-query-digest --type=genlog mysql-general.log