mysqlsla是一个mysql日志分析工具
分析结果展示:
Report for slow logs: ./slow.log
91 queries total, 17 unique
Sorted by 't_sum'
Grand Totals: Time 979 s, Lock 0 s, Rows sent 2.24M, Rows Examined 79.15M
______________________________________________________________________ 001 ___
Count : 50 (54.95%)
Time : 460.152157 s total, 9.203043 s avg, 4.062903 s to 16.990555 s max (47.01%)
95% of Time : 410.343859 s total, 8.73072 s avg, 4.062903 s to 16.223201 s max
Lock Time (s) : 38.683 ms total, 774 祍 avg, 704 祍 to 1.424 ms max (58.58%)
95% of Lock : 35.006 ms total, 745 祍 avg, 704 祍 to 1.002 ms max
Rows sent : 9 avg, 1 to 31 max (0.02%)
Rows examined : 551.84k avg, 551.82k to 553.00k max (34.86%)
Database :
Users :
JLyFIusU@localhost : 100.00% (50) of query, 95.60% (87) of all users
Query abstract:
SET timestamp=N; SELECT * FROM biogg_view_pay_s13 WHERE ( post_no = 'S' );
Query sample:
SET timestamp=1388421339;
SELECT * FROM biogg_view_pay_s13 WHERE ( `post_no` = 'HS1380269164' );
安装过程:
下载mysqlsla的压缩包:
下载地址在:http://hackmysql.com/mysqlsla
下载之后放置在服务器上:
解压
命令如下:
tar -xzvf mysqlsla-2.03.tar.gz
然后:
cp mysqlsla-2.03/bin/mysqlsla /usr/local/bin
【如果提示“Can’t locate DBI.pm”;执行yum install perl-DBI perl-DBD-MySQL -y 】
然后就可以使用了,
语法如下:
mysqlsla -lt slow slow.log > result.txt
中间出现错误,大致是:Can't locate Time/HiRes.pm
解决方法:
yum -y install perl-Time-HiRes
注:文章参考---Mysql mysqlsla在Linux之下的正确操作