yum -y install perl-ExtUtils-CBuilder perl-ExtUtils-MakeMaker
yum -y install perl-DBI perl-DBD-MySQL
yum -y install perl-CPAN

perl -MCPAN -e shell

cpan > install YAML
cpan > install Time::HiRes
# 以上安裝有提示東西都輸入 yes    

wget http://hackmysql.com/scripts/mysqlsla-2.03.tar.gz
tar xvfz mysqlsla-2.03.tar.gz
cd mysqlsla-2.03
perl Makefile.PL
make && make install

mysqlsla -lt slow -sort t_sum -top 1000  /tmp/slow_query.log

Report for slow logs: slowquery.log
1.59k queries total, 69 unique
Sorted by 't_sum'
Grand Totals: Time 109 s, Lock 0 s, Rows sent 142.02k, Rows Examined 21.26M
______________________________________________________________________ 001 ___
Count : 26 (1.64%)
Time : 6.121513 s total, 235.443 ms avg, 202.917 ms to 311.527 ms max (5.63%)
  95% of Time : 5.538256 s total, 230.761 ms avg, 202.917 ms to 271.056 ms max
Lock Time (s) : 2.407 ms total, 93 µs avg, 84 µs to 139 µs max (1.55%)
  95% of Lock : 2.152 ms total, 90 µs avg, 84 µs to 99 µs max
Rows sent : 0 avg, 0 to 0 max (0.00%)
Rows examined : 153.68k avg, 153.67k to 153.69k max (18.79%)
Database :
Users :
 root@localhost 127.0.0.1 : 100.00% (26) of query, 100.00% (1586) of all users

Query abstract:
SET timestamp=N; SELECT order_pid FROM wfc_delivery WHERE ( order_pid IN (S1) ) AND ( status IN (S3) ) GROUP BY order_pid;

Query sample:
SET timestamp=1387964641;
SELECT `order_pid` FROM `wfc_delivery` WHERE ( `order_pid` IN ('8831') ) AND ( `status` IN ('1','4','24') ) GROUP BY order_pid;