Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to install mysqlsla, a slow query log tool for mysql analysis. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

1 configure 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 installation tools

Tool download link: https://pan.baidu.com/s/1hs5XXY0 password: 4uak

Run using root:

Tar xvfz mysqlsla-2.03.tar.gz

Ca mysqlsla*

Perl Makefile.PL

Make

Make install

3 testing after installation is complete

Which mysqlsla

/ usr/local/bin/mysqlsla

Mysqlsla-lt slow slow_query.log > ycr.output

On "mysql analysis slow query log tool mysqlsla how to install" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, please share it out for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.