mysql分析慢查詢日誌工具mysqlsla安裝

1    配置perl
perl -MCPAN -e shell

cpan[1]>install Time:HiRes
cpan[1]>install File::Temp
cpan[1]>install Data::Dumper
icpan[1]>install DBI
cpan[1]>install Getopt::Long
cpan[1]>install Storable
cpan[1]>install Term::ReadKey

2    安裝工具
工具下載連結: 密碼: 4uak
使用root執行：
tar xvfz mysqlsla-2.03.tar.gz
ca mysqlsla*
perl Makefile.PL
make
make install

3    安裝完成後測試
which mysqlsla
/usr/local/bin/mysqlsla

mysqlsla -lt slow slow_query.log >ycr.output