percona-toolkit 杀死慢的SQL语句

54321333

                      1、下载percona-toolkit-2.2.16.tar.gz
# wget
https://www.percona.com/downloads/percona-toolkit/2.2.16/tarball/percona-toolkit-2.2.16.tar.gz

2、安装
# ll
-rw-r--r-- 1 root root 1408239 11月  9 2015 percona-toolkit-2.2.16.tar.gz
# tar xf percona-toolkit-2.2.16.tar.gz
# cd percona-toolkit-2.2.16
# perl Makefile.PL

# yum -y install perl
# yum -y install perl-ExtUtils-MakeMaker.x86_64
# yum -y install perl-DBI.x86_64
# yum -y install perl-DBD-MySQL.x86_64
# perl Makefile.PL
# make
# make install

# yum -y install perl-Time-HiRes.x86_64

# /usr/local/bin/pt-kill -S /tmp/mysql.sock -u root -p"123456" \
--match-info "^(select|SELECT|Select)" \
--busy-time 5 --victim all --interval 3 --kill-query --print \
--log /usr/local/src/kill.txt --daemonize

--socket=s         -S  Socket file to use for connection
--user=s           -u  User for login if not current user
--password=s       -p  Password to use when connecting
--match-info=s         Match only queries whose Info (query) matches this Perl regex
--busy-time=m          Match queries that have been running for longer than
                         this time.  Optional suffix s=seconds, m=minutes, h=
                         hours, d=days; if no suffix, s is used.

--interval=m           How often to check for queries to kill.  Optional
                         suffix s=seconds, m=minutes, h=hours, d=days; if no
                         suffix, s is used.
--victims=s            Which of the matching queries in each class will be
                         killed (default oldest)

Actions:

  --execute-command=s    Execute this command when a query matches
  --kill                 Kill the connection for matching queries
  --kill-query           Kill matching queries
  --print                Print a KILL statement for matching queries; does not
                         actually kill queries
--log=s                Print all output to this file when daemonized
--daemonize            Fork to the background and detach from the shell