Reference
Quick Start Guide >> http://hackmysql.com/mysqlsla_guide
Available Filter >> http://hackmysql.com/mysqlsla_filters
Command Line Option >> http://hackmysql.com/mysqlsla_documentation#command_line_options
Installation
- Download mysqlsla-2.03.tar.gz
- tar xvfz mysqlsla-2.03.tar.gz
- cd mysqlsla-2.03
- perl Makefile.PL
- make
- sudo make install
Cheat Sheet
analyze slow query log mysqlsla -lt slow /var/log/mysql/mysql-slow.loganalyze slow query log from specified user
mysqlsla -lt slow /var/log/mysql/mysql-slow.log -mf user=user1
analyze slow query log with rows examined > 10
mysqlsla -lt slow /var/log/mysql/mysql-slow.log -mf 're>10'analyze top 3 slow query log from specified user
mysqlsla -lt slow /var/log/mysql/mysql-slow.log -mf user=user1 --top 3analyze slow query log filter only select statement
mysqlsla -lt slow /var/log/mysql/mysql-slow.log -sf +selectanalyze slow query log filter only non-select statement
mysqlsla -lt slow /var/log/mysql/mysql-slow.log -sf -select
ไม่มีความคิดเห็น:
แสดงความคิดเห็น