MySQL Slow query analysis tool: Pt-query-digest for installation on Mac

System performance tuning in particular MySQL database tuning a primary basis is the slow query log. Originally there is a powerful tool on Ubantu or CentOS is Percona Toolkit, then how to use Pt-query-digest on Mac?

Download Percona Toolkit

Access Http://www.percona.com/downloads/percona-toolkit, use source code installation, download the latest stable version of 2.2.7.

650) this.width=650; "src=" http://img.blog.csdn.net/20160608212319520 "alt=" here write a picture describing "title=" "style=" border:none; "/ >

Install and pre-fill the holes in the installation process

Go to the download directory and open the training:

$ tar xvfz percona-toolkit-2.2.7.tar.gz$ CD percona-toolkit-2.2.171212

Note that the Perl version is more than 5.18.

Perl, the language of passion years ago, hehe. Try running Perl makefile.pl and look at the output:

Checking If your kit is complete ... Looks goodwarning:prerequisite dbd::mysql 3 not found. Warning:prerequisite DBI 1.46 not found.  Warning:name must be a package namegenerating a unix-style makefilewriting Makefile for percona-toolkitwriting MYMETA.yml and mymeta.json123456789101112131415123456789101112131415

Attention to these several warning, may be the pit, especially the dbd and dbi, without them, how to achieve database connection? Install the relevant Perl module.

$ perl-mcpan-e "Install DBI" $ perl-mcpan-e "Install Dbd::mysql" 1212

Note that if there is a permission problem, use sudo.

Now, Percona Toolkit can be installed, especially the path of mysql_config is specified.

$ perl makefile.pl--mysql_config=/local/mariadb/bin/mysql_config11

Then, the well-known make and make install is installed, and the installation is complete.

Inspection and use

There are two ways to test the installed module in Perl: One is to execute the command Perldoc perllocal, the other is to execute instmodsh, and for simplicity, here with INSTMODSH, run and output as follows:

$ instmodshavailable commands are:   l             - List all installed modules   m < module>   - select a module   q             - quit the programcmd? linstalled modules  are:   authen::sasl   cgi   cwd   dbd::mysql    DBI   Digest::HMAC   Digest::SHA1   Error    file::slurp::tiny   gssapi   git   html::P arser    HTML::Tagset   IO::Socket::SSL   Locale::gettext    NET::LIBIDN&NBSP;&NBSP;&NBSP;NET::SMTP::SSL&NBSP;&NBSP;&NBSP;NET::SSLEAY&NBSP;&NBSP;&NBSP, ..... 12345678910111213141516171819202122232425261234567891011121314151617181920212223242526 

Now you can use Percona Toolkit on your Mac like any other Linux platform. Back to the target topic, analyze slow queries:

$ pt-query-digest ~/mysql-slow.log11

Remote execution will be slow, here is to drag the slow query log to run locally, you can get more valuable analysis results.

This article from "I Believe" blog, reproduced please contact the author!

MySQL Slow query analysis tool: Pt-query-digest for installation on Mac