[root@tslls ~]# PTDEBUG=1 pt-kill # /usr/bin/perl 5.010001 # Linux tslls.net 2.6.32-504.16.2.el6.x86_64 #1 SMP Wed Apr 22 06:48:29 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux # Arguments: # OptionParser:282 2173 Option rule: Specify at least one of --kill, --kill-query, --print, --execute-command or --stop. # OptionParser:282 2173 Option rule: --any-busy-time and --each-busy-time are mutually exclusive. # OptionParser:282 2173 Option rule: --kill and --kill-query are mutually exclusive. # OptionParser:282 2173 Option rule: --daemonize and --test-matching are mutually exclusive. # OptionParser:282 2173 Option rule: This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details. # OptionParser:291 2173 =item --ask-pass # OptionParser:310 2173 Option has no attributes # OptionParser:318 2173 Short help: Prompt for a password when connecting to MySQL # OptionParser:291 2173 =item --charset # OptionParser:318 2173 Short help: Default character set # OptionParser:291 2173 =item --config # OptionParser:318 2173 Short help: Read this comma-separated list of config files; if specified, this must be the first option on the command line # OptionParser:291 2173 =item --create-log-table # OptionParser:310 2173 Option has no attributes # OptionParser:318 2173 Short help: Create the --log-dsn table if it does not exist # OptionParser:291 2173 =item --daemonize # OptionParser:310 2173 Option has no attributes # OptionParser:318 2173 Short help: Fork to the background and detach from the shell # OptionParser:291 2173 =item --database # OptionParser:318 2173 Short help: The database to use for the connection # OptionParser:291 2173 =item --defaults-file # OptionParser:318 2173 Short help: Only read mysql options from the given file # OptionParser:291 2173 =item --filter # OptionParser:318 2173 Short help: Discard events for which this Perl code doesn't return true # OptionParser:291 2173 =item --group-by # OptionParser:318 2173 Short help: Apply matches to each class of queries grouped by this SHOW PROCESSLIST column # OptionParser:291 2173 =item --help # OptionParser:310 2173 Option has no attributes # OptionParser:318 2173 Short help: Show help and exit # OptionParser:291 2173 =item --host # OptionParser:318 2173 Short help: Connect to host # OptionParser:291 2173 =item --interval # OptionParser:318 2173 Short help: How often to check for queries to kill # OptionParser:291 2173 =item --log # OptionParser:318 2173 Short help: Print all output to this file when daemonized # OptionParser:291 2173 =item --log-dsn # OptionParser:318 2173 Short help: Store each query killed in this DSN # OptionParser:291 2173 =item --password # OptionParser:318 2173 Short help: Password to use when connecting # OptionParser:291 2173 =item --pid # OptionParser:318 2173 Short help: Create the given PID file # OptionParser:291 2173 =item --port # OptionParser:318 2173 Short help: Port number to use for connection # OptionParser:291 2173 =item --query-id # OptionParser:310 2173 Option has no attributes # OptionParser:318 2173 Short help: Prints an ID of the query that was just killed # OptionParser:291 2173 =item --run-time # OptionParser:318 2173 Short help: How long to run before exiting # OptionParser:291 2173 =item --sentinel # OptionParser:318 2173 Short help: Exit if this file exists # OptionParser:291 2173 =item --set-vars # OptionParser:318 2173 Short help: Set the MySQL variables in this comma-separated list of variable=value pairs # OptionParser:291 2173 =item --socket # OptionParser:318 2173 Short help: Socket file to use for connection # OptionParser:291 2173 =item --stop # OptionParser:310 2173 Option has no attributes # OptionParser:318 2173 Short help: Stop running instances by creating the --sentinel file # OptionParser:291 2173 =item --[no]strip-comments # OptionParser:318 2173 Short help: Remove SQL comments from queries in the Info column of the PROCESSLIST # OptionParser:291 2173 =item --user # OptionParser:318 2173 Short help: User for login if not current user # OptionParser:291 2173 =item --version # OptionParser:310 2173 Option has no attributes # OptionParser:318 2173 Short help: Show version and exit # OptionParser:291 2173 =item --[no]version-check # OptionParser:318 2173 Short help: Check for the latest version of Percona Toolkit, MySQL, and other programs # OptionParser:291 2173 =item --victims # OptionParser:318 2173 Short help: Which of the matching queries in each class will be killed # OptionParser:291 2173 =item --wait-after-kill # OptionParser:318 2173 Short help: Wait after killing a query, before looking for more to kill # OptionParser:291 2173 =item --wait-before-kill # OptionParser:318 2173 Short help: Wait before killing a query # OptionParser:291 2173 =item --busy-time # OptionParser:318 2173 Short help: Match queries that have been running for longer than this time # OptionParser:291 2173 =item --idle-time # OptionParser:318 2173 Short help: Match queries that have been idle/sleeping for longer than this time # OptionParser:291 2173 =item --ignore-command # OptionParser:318 2173 Short help: Ignore queries whose Command matches this Perl regex # OptionParser:291 2173 =item --ignore-db # OptionParser:318 2173 Short help: Ignore queries whose db (database) matches this Perl regex # OptionParser:291 2173 =item --ignore-host # OptionParser:318 2173 Short help: Ignore queries whose Host matches this Perl regex # OptionParser:291 2173 =item --ignore-info # OptionParser:318 2173 Short help: Ignore queries whose Info (query) matches this Perl regex # OptionParser:291 2173 =item --[no]ignore-self # OptionParser:318 2173 Short help: Don't kill pt-kill's own connection # OptionParser:291 2173 =item --ignore-state # OptionParser:318 2173 Short help: Ignore queries whose State matches this Perl regex # OptionParser:291 2173 =item --ignore-user # OptionParser:318 2173 Short help: Ignore queries whose user matches this Perl regex # OptionParser:291 2173 =item --match-all # OptionParser:318 2173 Short help: Match all queries that are not ignored # OptionParser:291 2173 =item --match-command # OptionParser:318 2173 Short help: Match only queries whose Command matches this Perl regex # OptionParser:291 2173 =item --match-db # OptionParser:318 2173 Short help: Match only queries whose db (database) matches this Perl regex # OptionParser:291 2173 =item --match-host # OptionParser:318 2173 Short help: Match only queries whose Host matches this Perl regex # OptionParser:291 2173 =item --match-info # OptionParser:318 2173 Short help: Match only queries whose Info (query) matches this Perl regex # OptionParser:291 2173 =item --match-state # OptionParser:318 2173 Short help: Match only queries whose State matches this Perl regex # OptionParser:291 2173 =item --match-user # OptionParser:318 2173 Short help: Match only queries whose User matches this Perl regex # OptionParser:291 2173 =item --replication-threads # OptionParser:318 2173 Short help: Allow matching and killing replication threads # OptionParser:291 2173 =item --test-matching # OptionParser:318 2173 Short help: Files with processlist snapshots to test matching options against # OptionParser:291 2173 =item --any-busy-time # OptionParser:318 2173 Short help: Match query class if any query has been running for longer than this time. "Longer than" means that if you specify 10, for example, the class will only match if there's at least one query that has been running for greater than 10 seconds # OptionParser:291 2173 =item --each-busy-time # OptionParser:318 2173 Short help: Match query class if each query has been running for longer than this time. "Longer than" means that if you specify 10, for example, the class will only match if each and every query has been running for greater than 10 seconds # OptionParser:291 2173 =item --query-count # OptionParser:318 2173 Short help: Match query class if it has at least this many queries # OptionParser:291 2173 =item --verbose # OptionParser:318 2173 Short help: Print information to STDOUT about what is being done # OptionParser:291 2173 =item --execute-command # OptionParser:318 2173 Short help: Execute this command when a query matches # OptionParser:291 2173 =item --kill # OptionParser:318 2173 Short help: Kill the connection for matching queries # OptionParser:291 2173 =item --kill-query # OptionParser:318 2173 Short help: Kill matching queries # OptionParser:291 2173 =item --print # OptionParser:318 2173 Short help: Print a KILL statement for matching queries; does not actually kill queries # OptionParser:357 2173 Parsing opt spec: group => default spec => ask-pass desc => Prompt for a password when connecting to MySQL # OptionParser:395 2173 ask-pass type: undef # OptionParser:357 2173 Parsing opt spec: group => default spec => charset|A=s desc => Default character set # OptionParser:395 2173 charset type: s # OptionParser:357 2173 Parsing opt spec: group => default spec => config=A desc => Read this comma-separated list of config files; if specified, this must be the first option on the command line # OptionParser:395 2173 config type: A # OptionParser:357 2173 Parsing opt spec: group => default spec => create-log-table desc => Create the --log-dsn table if it does not exist # OptionParser:395 2173 create-log-table type: undef # OptionParser:357 2173 Parsing opt spec: group => default spec => daemonize desc => Fork to the background and detach from the shell # OptionParser:395 2173 daemonize type: undef # OptionParser:357 2173 Parsing opt spec: group => default spec => database|D=s desc => The database to use for the connection # OptionParser:395 2173 database type: s # OptionParser:357 2173 Parsing opt spec: group => default spec => defaults-file|F=s desc => Only read mysql options from the given file # OptionParser:395 2173 defaults-file type: s # OptionParser:357 2173 Parsing opt spec: group => default spec => filter=s desc => Discard events for which this Perl code doesn't return true # OptionParser:395 2173 filter type: s # OptionParser:357 2173 Parsing opt spec: group => default spec => group-by=s desc => Apply matches to each class of queries grouped by this SHOW PROCESSLIST column # OptionParser:395 2173 group-by type: s # OptionParser:357 2173 Parsing opt spec: group => default spec => help desc => Show help and exit # OptionParser:395 2173 help type: undef # OptionParser:357 2173 Parsing opt spec: group => default spec => host|h=s desc => Connect to host (default localhost) # OptionParser:395 2173 host type: s # OptionParser:402 2173 host default: localhost # OptionParser:357 2173 Parsing opt spec: group => default spec => interval=m desc => How often to check for queries to kill # OptionParser:395 2173 interval type: m # OptionParser:357 2173 Parsing opt spec: group => default spec => log=s desc => Print all output to this file when daemonized # OptionParser:395 2173 log type: s # OptionParser:357 2173 Parsing opt spec: group => default spec => log-dsn=d desc => Store each query killed in this DSN # OptionParser:395 2173 log-dsn type: d # OptionParser:357 2173 Parsing opt spec: group => default spec => password|p=s desc => Password to use when connecting # OptionParser:395 2173 password type: s # OptionParser:357 2173 Parsing opt spec: group => default spec => pid=s desc => Create the given PID file # OptionParser:395 2173 pid type: s # OptionParser:357 2173 Parsing opt spec: group => default spec => port|P=i desc => Port number to use for connection # OptionParser:395 2173 port type: i # OptionParser:357 2173 Parsing opt spec: group => default spec => query-id desc => Prints an ID of the query that was just killed # OptionParser:395 2173 query-id type: undef # OptionParser:357 2173 Parsing opt spec: group => default spec => run-time=m desc => How long to run before exiting # OptionParser:395 2173 run-time type: m # OptionParser:357 2173 Parsing opt spec: group => default spec => sentinel=s desc => Exit if this file exists (default /tmp/pt-kill-sentinel) # OptionParser:395 2173 sentinel type: s # OptionParser:402 2173 sentinel default: /tmp/pt-kill-sentinel # OptionParser:357 2173 Parsing opt spec: group => default spec => set-vars=A desc => Set the MySQL variables in this comma-separated list of variable=value pairs # OptionParser:395 2173 set-vars type: A # OptionParser:357 2173 Parsing opt spec: group => default spec => socket|S=s desc => Socket file to use for connection # OptionParser:395 2173 socket type: s # OptionParser:357 2173 Parsing opt spec: group => default spec => stop desc => Stop running instances by creating the --sentinel file # OptionParser:395 2173 stop type: undef # OptionParser:357 2173 Parsing opt spec: group => default spec => strip-comments! desc => Remove SQL comments from queries in the Info column of the PROCESSLIST (default yes) # OptionParser:395 2173 strip-comments type: undef # OptionParser:402 2173 strip-comments default: yes # OptionParser:357 2173 Parsing opt spec: group => default spec => user|u=s desc => User for login if not current user # OptionParser:395 2173 user type: s # OptionParser:357 2173 Parsing opt spec: group => default spec => version desc => Show version and exit # OptionParser:395 2173 version type: undef # OptionParser:357 2173 Parsing opt spec: group => default spec => version-check! desc => Check for the latest version of Percona Toolkit, MySQL, and other programs (default yes) # OptionParser:395 2173 version-check type: undef # OptionParser:402 2173 version-check default: yes # OptionParser:357 2173 Parsing opt spec: group => default spec => victims=s desc => Which of the matching queries in each class will be killed (default oldest) # OptionParser:395 2173 victims type: s # OptionParser:402 2173 victims default: oldest # OptionParser:357 2173 Parsing opt spec: group => default spec => wait-after-kill=m desc => Wait after killing a query, before looking for more to kill # OptionParser:395 2173 wait-after-kill type: m # OptionParser:357 2173 Parsing opt spec: group => default spec => wait-before-kill=m desc => Wait before killing a query # OptionParser:395 2173 wait-before-kill type: m # OptionParser:357 2173 Parsing opt spec: group => Query Matches spec => busy-time=m desc => Match queries that have been running for longer than this time # OptionParser:395 2173 busy-time type: m # OptionParser:357 2173 Parsing opt spec: group => Query Matches spec => idle-time=m desc => Match queries that have been idle/sleeping for longer than this time # OptionParser:395 2173 idle-time type: m # OptionParser:357 2173 Parsing opt spec: group => Query Matches spec => ignore-command=s desc => Ignore queries whose Command matches this Perl regex # OptionParser:395 2173 ignore-command type: s # OptionParser:357 2173 Parsing opt spec: group => Query Matches spec => ignore-db=s desc => Ignore queries whose db (database) matches this Perl regex # OptionParser:395 2173 ignore-db type: s # OptionParser:357 2173 Parsing opt spec: group => Query Matches spec => ignore-host=s desc => Ignore queries whose Host matches this Perl regex # OptionParser:395 2173 ignore-host type: s # OptionParser:357 2173 Parsing opt spec: group => Query Matches spec => ignore-info=s desc => Ignore queries whose Info (query) matches this Perl regex # OptionParser:395 2173 ignore-info type: s # OptionParser:357 2173 Parsing opt spec: group => Query Matches spec => ignore-self! desc => Don't kill pt-kill's own connection (default yes) # OptionParser:395 2173 ignore-self type: undef # OptionParser:402 2173 ignore-self default: yes # OptionParser:357 2173 Parsing opt spec: group => Query Matches spec => ignore-state=s desc => Ignore queries whose State matches this Perl regex (default Locked) # OptionParser:395 2173 ignore-state type: s # OptionParser:402 2173 ignore-state default: Locked # OptionParser:357 2173 Parsing opt spec: group => Query Matches spec => ignore-user=s desc => Ignore queries whose user matches this Perl regex # OptionParser:395 2173 ignore-user type: s # OptionParser:357 2173 Parsing opt spec: group => Query Matches spec => match-all desc => Match all queries that are not ignored # OptionParser:395 2173 match-all type: undef # OptionParser:357 2173 Parsing opt spec: group => Query Matches spec => match-command=s desc => Match only queries whose Command matches this Perl regex # OptionParser:395 2173 match-command type: s # OptionParser:357 2173 Parsing opt spec: group => Query Matches spec => match-db=s desc => Match only queries whose db (database) matches this Perl regex # OptionParser:395 2173 match-db type: s # OptionParser:357 2173 Parsing opt spec: group => Query Matches spec => match-host=s desc => Match only queries whose Host matches this Perl regex # OptionParser:395 2173 match-host type: s # OptionParser:357 2173 Parsing opt spec: group => Query Matches spec => match-info=s desc => Match only queries whose Info (query) matches this Perl regex # OptionParser:395 2173 match-info type: s # OptionParser:357 2173 Parsing opt spec: group => Query Matches spec => match-state=s desc => Match only queries whose State matches this Perl regex # OptionParser:395 2173 match-state type: s # OptionParser:357 2173 Parsing opt spec: group => Query Matches spec => match-user=s desc => Match only queries whose User matches this Perl regex # OptionParser:395 2173 match-user type: s # OptionParser:357 2173 Parsing opt spec: group => Query Matches spec => replication-threads desc => Allow matching and killing replication threads # OptionParser:395 2173 replication-threads type: undef # OptionParser:357 2173 Parsing opt spec: group => Query Matches spec => test-matching=a desc => Files with processlist snapshots to test matching options against # OptionParser:395 2173 test-matching type: a # OptionParser:357 2173 Parsing opt spec: group => Class Matches spec => any-busy-time=m desc => Match query class if any query has been running for longer than this time. "Longer than" means that if you specify 10, for example, the class will only match if there's at least one query that has been running for greater than 10 seconds # OptionParser:395 2173 any-busy-time type: m # OptionParser:357 2173 Parsing opt spec: group => Class Matches spec => each-busy-time=m desc => Match query class if each query has been running for longer than this time. "Longer than" means that if you specify 10, for example, the class will only match if each and every query has been running for greater than 10 seconds # OptionParser:395 2173 each-busy-time type: m # OptionParser:357 2173 Parsing opt spec: group => Class Matches spec => query-count=i desc => Match query class if it has at least this many queries # OptionParser:395 2173 query-count type: i # OptionParser:357 2173 Parsing opt spec: group => default spec => verbose|v desc => Print information to STDOUT about what is being done # OptionParser:395 2173 verbose type: undef # OptionParser:357 2173 Parsing opt spec: group => Actions spec => execute-command=s desc => Execute this command when a query matches # OptionParser:395 2173 execute-command type: s # OptionParser:357 2173 Parsing opt spec: group => Actions spec => kill desc => Kill the connection for matching queries # OptionParser:395 2173 kill type: undef # OptionParser:357 2173 Parsing opt spec: group => Actions spec => kill-query desc => Kill matching queries # OptionParser:395 2173 kill-query type: undef # OptionParser:357 2173 Parsing opt spec: group => Actions spec => print desc => Print a KILL statement for matching queries; does not actually kill queries # OptionParser:395 2173 print type: undef # OptionParser:417 2173 Parsing rule: Specify at least one of --kill, --kill-query, --print, --execute-command or --stop. # OptionParser:473 2173 Participants for Specify at least one of --kill, --kill-query, --print, --execute-command or --stop. : kill kill-query print execute-command stop # OptionParser:430 2173 kill kill-query print execute-command stop require at least one # OptionParser:417 2173 Parsing rule: --any-busy-time and --each-busy-time are mutually exclusive. # OptionParser:473 2173 Participants for --any-busy-time and --each-busy-time are mutually exclusive. : any-busy-time each-busy-time # OptionParser:425 2173 any-busy-time each-busy-time are mutually exclusive # OptionParser:417 2173 Parsing rule: --kill and --kill-query are mutually exclusive. # OptionParser:473 2173 Participants for --kill and --kill-query are mutually exclusive. : kill kill-query # OptionParser:425 2173 kill kill-query are mutually exclusive # OptionParser:417 2173 Parsing rule: --daemonize and --test-matching are mutually exclusive. # OptionParser:473 2173 Participants for --daemonize and --test-matching are mutually exclusive. : daemonize test-matching # OptionParser:425 2173 daemonize test-matching are mutually exclusive # OptionParser:417 2173 Parsing rule: This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details. # OptionParser:473 2173 Participants for This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details. : # OptionParser:449 2173 Strict mode disabled by rule # OptionParser:201 2173 Parsing DSN OPTIONS # OptionParser:291 2173 =item * A # OptionParser:318 2173 Short help: Default character set # OptionParser:291 2173 =item * D # OptionParser:318 2173 Short help: Default database # OptionParser:291 2173 =item * F # OptionParser:318 2173 Short help: Only read default options from the given file # OptionParser:291 2173 =item * h # OptionParser:318 2173 Short help: Connect to host # OptionParser:291 2173 =item * p # OptionParser:318 2173 Short help: Password to use when connecting # OptionParser:291 2173 =item * P # OptionParser:318 2173 Short help: Port number to use for connection # OptionParser:291 2173 =item * S # OptionParser:318 2173 Short help: Socket file to use for connection # OptionParser:291 2173 =item * u # OptionParser:318 2173 Short help: User for login if not current user # OptionParser:291 2173 =item * t # OptionParser:310 2173 Option has no attributes # OptionParser:318 2173 Short help: Table to log actions in, if passed through --log-dsn # DSNParser:1867 2173 DSN option: copy=1, dsn=charset, desc=Default character set, key=A # DSNParser:1867 2173 DSN option: copy=1, dsn=database, desc=Default database, key=D # DSNParser:1867 2173 DSN option: copy=1, dsn=mysql_read_default_file, desc=Only read default options from the given file, key=F # DSNParser:1867 2173 DSN option: copy=1, dsn=host, desc=Connect to host, key=h # DSNParser:1867 2173 DSN option: copy=1, dsn=password, desc=Password to use when connecting, key=p # DSNParser:1867 2173 DSN option: copy=1, dsn=port, desc=Port number to use for connection, key=P # DSNParser:1867 2173 DSN option: copy=1, dsn=mysql_socket, desc=Socket file to use for connection, key=S # DSNParser:1867 2173 DSN option: copy=1, dsn=user, desc=User for login if not current user, key=u # DSNParser:1867 2173 DSN option: copy=undef, dsn=undef, desc=Table to log actions in, if passed through --log-dsn, key=t # OptionParser:245 2173 pt-kill 2.2.14 # OptionParser:567 2173 Cannot open /etc/percona-toolkit/percona-toolkit.conf: No such file or directory # # OptionParser:567 2173 Cannot open /etc/percona-toolkit/pt-kill.conf: No such file or directory # # OptionParser:567 2173 Cannot open /root/.percona-toolkit.conf: No such file or directory # # OptionParser:535 2173 Got option busy-time = 30s # OptionParser:535 2173 Got option log = /root/pt_kill.log # OptionParser:535 2173 Got option pid = /root/pt_kill.pid # OptionParser:535 2173 Got option execute-command = (date >> /root/execute.log) # OptionParser:535 2173 Got option match-info = ^SELECT # OptionParser:535 2173 Got option kill = 1 # OptionParser:535 2173 Got option print = 1 # OptionParser:755 2173 Nothing to validate for option match-state type s value undef # OptionParser:755 2173 Nothing to validate for option sentinel type s value /tmp/pt-kill-sentinel # OptionParser:755 2173 Nothing to validate for option log-dsn type d value undef # OptionParser:755 2173 Nothing to validate for option wait-after-kill type m value undef # OptionParser:755 2173 Nothing to validate for option password type s value undef # OptionParser:755 2173 Nothing to validate for option ignore-host type s value undef # OptionParser:755 2173 Nothing to validate for option pid type s value /root/pt_kill.pid # OptionParser:755 2173 Nothing to validate for option user type s value undef # OptionParser:755 2173 Nothing to validate for option match-user type s value undef # OptionParser:706 2173 Parsing option busy-time as a time value # OptionParser:720 2173 Setting option busy-time to 30 # OptionParser:755 2173 Nothing to validate for option charset type s value undef # OptionParser:755 2173 Nothing to validate for option interval type m value undef # OptionParser:755 2173 Nothing to validate for option port type i value undef # OptionParser:755 2173 Nothing to validate for option socket type s value undef # OptionParser:755 2173 Nothing to validate for option ignore-user type s value undef # OptionParser:755 2173 Nothing to validate for option victims type s value oldest # OptionParser:755 2173 Nothing to validate for option each-busy-time type m value undef # OptionParser:755 2173 Nothing to validate for option ignore-state type s value Locked # OptionParser:755 2173 Nothing to validate for option query-count type i value undef # OptionParser:755 2173 Nothing to validate for option run-time type m value undef # OptionParser:755 2173 Nothing to validate for option ignore-command type s value undef # OptionParser:755 2173 Nothing to validate for option match-host type s value undef # OptionParser:755 2173 Nothing to validate for option group-by type s value undef # OptionParser:755 2173 Nothing to validate for option log type s value /root/pt_kill.log # OptionParser:755 2173 Nothing to validate for option idle-time type m value undef # OptionParser:755 2173 Nothing to validate for option filter type s value undef # OptionParser:755 2173 Nothing to validate for option test-matching type a value undef # OptionParser:755 2173 Nothing to validate for option host type s value localhost # OptionParser:755 2173 Nothing to validate for option defaults-file type s value undef # OptionParser:755 2173 Nothing to validate for option match-db type s value undef # OptionParser:755 2173 Nothing to validate for option database type s value undef # OptionParser:755 2173 Nothing to validate for option any-busy-time type m value undef # OptionParser:755 2173 Nothing to validate for option match-command type s value undef # OptionParser:755 2173 Nothing to validate for option ignore-db type s value undef # OptionParser:755 2173 Nothing to validate for option match-info type s value ^SELECT # OptionParser:755 2173 Nothing to validate for option wait-before-kill type m value undef # OptionParser:755 2173 Nothing to validate for option execute-command type s value (date >> /root/execute.log) # OptionParser:755 2173 Nothing to validate for option ignore-info type s value undef # OptionParser:1149 2173 --set-vars: $VAR1 = { # wait_timeout => { # default => 1, # val => '10000' # } # }; # # DSNParser:1883 2173 Setting set-vars property # OptionParser:829 2173 Getting description and usage from SYNOPSIS in /usr/bin/pt-kill # OptionParser:1082 2173 Parsing SYNOPSIS in /usr/bin/pt-kill # OptionParser:1095 2173 Raw SYNOPSIS text: Usage: pt-kill [OPTIONS] [DSN] # # pt-kill kills MySQL connections. pt-kill connects to MySQL and gets queries # from SHOW PROCESSLIST if no FILE is given. Else, it reads queries from one # or more FILE which contains the output of SHOW PROCESSLIST. If FILE is -, # pt-kill reads from STDIN. # # # OptionParser:833 2173 Description: pt-kill kills MySQL connections. pt-kill connects to MySQL and gets queries from SHOW PROCESSLIST if no FILE is given. Else, it reads queries from one or more FILE which contains the output of SHOW PROCESSLIST. If FILE is -, pt-kill reads from STDIN. # Usage: pt-kill [OPTIONS] [DSN] # pt_kill:6750 2173 Getting processlist from MySQL # DSNParser:1955 2173 DSN string made from options: h=localhost # DSNParser:1895 2173 Parsing h=localhost # DSNParser:1914 2173 Finding value for S # DSNParser:1924 2173 Copying value for S from defaults # DSNParser:1914 2173 Finding value for F # DSNParser:1924 2173 Copying value for F from defaults # DSNParser:1914 2173 Finding value for A # DSNParser:1924 2173 Copying value for A from defaults # DSNParser:1914 2173 Finding value for P # DSNParser:1924 2173 Copying value for P from defaults # DSNParser:1914 2173 Finding value for p # DSNParser:1924 2173 Copying value for p from defaults # DSNParser:1914 2173 Finding value for u # DSNParser:1924 2173 Copying value for u from defaults # DSNParser:1914 2173 Finding value for h # DSNParser:1914 2173 Finding value for D # DSNParser:1924 2173 Copying value for D from defaults # DSNParser:1914 2173 Finding value for t # DSNParser:1924 2173 Copying value for t from defaults # DSNParser:1895 2173 Parsing h=localhost # DSNParser:1914 2173 Finding value for S # DSNParser:1924 2173 Copying value for S from defaults # DSNParser:1914 2173 Finding value for F # DSNParser:1924 2173 Copying value for F from defaults # DSNParser:1914 2173 Finding value for A # DSNParser:1924 2173 Copying value for A from defaults # DSNParser:1914 2173 Finding value for P # DSNParser:1924 2173 Copying value for P from defaults # DSNParser:1914 2173 Finding value for p # DSNParser:1924 2173 Copying value for p from defaults # DSNParser:1914 2173 Finding value for u # DSNParser:1924 2173 Copying value for u from defaults # DSNParser:1914 2173 Finding value for h # DSNParser:1914 2173 Finding value for D # DSNParser:1924 2173 Copying value for D from defaults # DSNParser:1914 2173 Finding value for t # DSNParser:1924 2173 Copying value for t from defaults # DSNParser:2008 2173 DBI:mysql:;host=localhost;mysql_read_default_group=client # DSNParser:2057 2173 DBI:mysql:;host=localhost;mysql_read_default_group=client undef undef mysql_enable_utf8=>0, ShowErrorStatement=>1, AutoCommit=>1, RaiseError=>1, PrintError=>0 # DSNParser:2085 2173 DBI::db=HASH(0x1f202d0) SELECT @@SQL_MODE # DSNParser:2216 2173 DBI::db=HASH(0x1f202d0) SET SESSION wait_timeout=10000 # DSNParser:2116 2173 DBI::db=HASH(0x1f202d0) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION'*/ # DSNParser:2125 2173 DBH info: DBI::db=HASH(0x1f202d0) $VAR1 = { # '@@hostname' => 'tslls.net', # 'CONNECTION_ID()' => '33', # 'DATABASE()' => undef, # 'VERSION()' => '5.6.24-72.2' # }; # Connection info: Localhost via UNIX socket Character set info: $VAR1 = [ # { # Value => 'latin1', # Variable_name => 'character_set_client' # }, # { # Value => 'latin1', # Variable_name => 'character_set_connection' # }, # { # Value => 'latin1', # Variable_name => 'character_set_database' # }, # { # Value => 'binary', # Variable_name => 'character_set_filesystem' # }, # { # Value => 'latin1', # Variable_name => 'character_set_results' # }, # { # Value => 'latin1', # Variable_name => 'character_set_server' # }, # { # Value => 'utf8', # Variable_name => 'character_set_system' # }, # { # Value => '/usr/share/percona-server/charsets/', # Variable_name => 'character_sets_dir' # } # ]; # $DBD::mysql::VERSION: 4.013 $DBI::VERSION: 1.609 # Cxn:5210 2173 DBI::db=HASH(0x1f202d0) Setting dbh # Cxn:5215 2173 DBI::db=HASH(0x1f202d0) SELECT @@server_id /*!50038 , @@hostname*/ # Cxn:5217 2173 DBI::db=HASH(0x1f202d0) hostname: tslls.net 0 # Cxn:5198 2173 DBI::db=HASH(0x1f202d0) Connected dbh to tslls.net h=localhost # Daemon:2344 2173 Checking PID file /root/pt_kill.pid # Daemon:2372 2173 No PID file # Daemon:2281 2173 Daemonized child will log to /root/pt_kill.log # Daemon:2344 2173 Checking PID file /root/pt_kill.pid # Daemon:2372 2173 No PID file # Daemon:2405 2173 Created PID file: /root/pt_kill.pid # VersionCheck:6075 2173 FindBin::Bin: /usr/bin # VersionCheck:6235 2173 SELECT CONCAT(@@hostname, @@port) # VersionCheck:6256 2173 MySQL instance: 1fd50191122cdde284e2635a978b836e tslls.net3306 $VAR1 = { # A => undef, # D => undef, # F => undef, # P => undef, # S => undef, # h => 'localhost', # p => undef, # t => undef, # u => undef # }; # # VersionCheck:6055 2173 Version check file percona-version-check in /tmp # VersionCheck:6170 2173 Version check file /tmp/percona-version-check contents: 0,1433025813 # 1fd50191122cdde284e2635a978b836e,1433025813 # VersionCheck:6178 2173 Intsance 1fd50191122cdde284e2635a978b836e last checked 1433025813 now 1433027417 diff 1604 hours until next check 23.55 # VersionCheck:6178 2173 Intsance 0 last checked 1433025813 now 1433027417 diff 1604 hours until next check 23.55 # VersionCheck:6098 2173 0 instances to check # pt_kill:7225 2173 /usr/bin/pt-kill starting # pt_kill:7225 2173 Connected to host tslls.net # pt_kill:7225 2173 Find spec: $VAR1 = { # all => undef, # busy_time => '30', # idle_time => undef, # ignore => { # Command => undef, # Host => undef, # Id => 33, # Info => undef, # State => 'Locked', # User => undef, # db => undef # }, # match => { # Command => undef, # Host => undef, # Info => '^SELECT', # State => undef, # User => undef, # db => undef # }, # replication_threads => undef # }; # # pt_kill:7225 2173 Run-time: forever at 15 second intervals # pt_kill:7225 2173 Checking processlist # Retry:5068 2173 Try 1 of 1200 # Retry:5085 2173 Try code succeeded # pt_kill:7247 2173 Grouping queries by undef # pt_kill:7062 2173 Finding matching queries in class default # Processlist:3468 2173 find specs: $VAR1 = { # all => undef, # busy_time => '30', # idle_time => undef, # ignore => { # Command => undef, # Host => undef, # Id => 33, # Info => undef, # State => 'Locked', # User => undef, # db => undef # }, # match => { # Command => undef, # Host => undef, # Info => '^SELECT', # State => undef, # User => undef, # db => undef # }, # replication_threads => undef # }; # # Processlist:3474 2173 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '33', # Info => 'SHOW FULL PROCESSLIST', # Rows_examined => '0', # Rows_sent => '0', # State => 'init', # Time => '0', # User => 'root', # db => undef # }; # # MasterSlave:4339 2173 Not system user # MasterSlave:4356 2173 Matches all replication thread: no ; match: 0 # Processlist:3486 2173 Query isn't running long enough # pt_kill:7065 2173 0 queries in class default # pt_kill:7225 2173 Matched 0 queries # pt_kill:7225 2173 Sleeping 15 seconds after normal interval # pt_kill:7225 2173 Checking processlist # Retry:5068 2173 Try 1 of 1200 # Retry:5085 2173 Try code succeeded # pt_kill:7247 2173 Grouping queries by undef # pt_kill:7062 2173 Finding matching queries in class default # Processlist:3468 2173 find specs: $VAR1 = { # all => undef, # busy_time => '30', # idle_time => undef, # ignore => { # Command => undef, # Host => undef, # Id => 33, # Info => undef, # State => 'Locked', # User => undef, # db => undef # }, # match => { # Command => undef, # Host => undef, # Info => '^SELECT', # State => undef, # User => undef, # db => undef # }, # replication_threads => undef # }; # # Processlist:3474 2173 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '33', # Info => 'SHOW FULL PROCESSLIST', # Rows_examined => '0', # Rows_sent => '0', # State => 'init', # Time => '0', # User => 'root', # db => undef # }; # # MasterSlave:4339 2173 Not system user # MasterSlave:4356 2173 Matches all replication thread: no ; match: 0 # Processlist:3486 2173 Query isn't running long enough # Processlist:3474 2173 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '34', # Info => 'SELECT @@server_id, SLEEP(65) /* First Query */', # Rows_examined => '0', # Rows_sent => '0', # State => 'User sleep', # Time => '4', # User => 'root', # db => undef # }; # # MasterSlave:4339 2173 Not system user # MasterSlave:4356 2173 Matches all replication thread: no ; match: 0 # Processlist:3486 2173 Query isn't running long enough # pt_kill:7065 2173 0 queries in class default # pt_kill:7225 2173 Matched 0 queries # pt_kill:7225 2173 Sleeping 15 seconds after normal interval # pt_kill:7225 2173 Checking processlist # Retry:5068 2173 Try 1 of 1200 # Retry:5085 2173 Try code succeeded # pt_kill:7247 2173 Grouping queries by undef # pt_kill:7062 2173 Finding matching queries in class default # Processlist:3468 2173 find specs: $VAR1 = { # all => undef, # busy_time => '30', # idle_time => undef, # ignore => { # Command => undef, # Host => undef, # Id => 33, # Info => undef, # State => 'Locked', # User => undef, # db => undef # }, # match => { # Command => undef, # Host => undef, # Info => '^SELECT', # State => undef, # User => undef, # db => undef # }, # replication_threads => undef # }; # # Processlist:3474 2173 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '33', # Info => 'SHOW FULL PROCESSLIST', # Rows_examined => '0', # Rows_sent => '0', # State => 'init', # Time => '0', # User => 'root', # db => undef # }; # # MasterSlave:4339 2173 Not system user # MasterSlave:4356 2173 Matches all replication thread: no ; match: 0 # Processlist:3486 2173 Query isn't running long enough # Processlist:3474 2173 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '34', # Info => 'SELECT @@server_id, SLEEP(65) /* First Query */', # Rows_examined => '0', # Rows_sent => '0', # State => 'User sleep', # Time => '19', # User => 'root', # db => undef # }; # # MasterSlave:4339 2173 Not system user # MasterSlave:4356 2173 Matches all replication thread: no ; match: 0 # Processlist:3486 2173 Query isn't running long enough # pt_kill:7065 2173 0 queries in class default # pt_kill:7225 2173 Matched 0 queries # pt_kill:7225 2173 Sleeping 15 seconds after normal interval # pt_kill:7225 2173 Checking processlist # Retry:5068 2173 Try 1 of 1200 # Retry:5085 2173 Try code succeeded # pt_kill:7247 2173 Grouping queries by undef # pt_kill:7062 2173 Finding matching queries in class default # Processlist:3468 2173 find specs: $VAR1 = { # all => undef, # busy_time => '30', # idle_time => undef, # ignore => { # Command => undef, # Host => undef, # Id => 33, # Info => undef, # State => 'Locked', # User => undef, # db => undef # }, # match => { # Command => undef, # Host => undef, # Info => '^SELECT', # State => undef, # User => undef, # db => undef # }, # replication_threads => undef # }; # # Processlist:3474 2173 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '33', # Info => 'SHOW FULL PROCESSLIST', # Rows_examined => '0', # Rows_sent => '0', # State => 'init', # Time => '0', # User => 'root', # db => undef # }; # # MasterSlave:4339 2173 Not system user # MasterSlave:4356 2173 Matches all replication thread: no ; match: 0 # Processlist:3486 2173 Query isn't running long enough # Processlist:3474 2173 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '34', # Info => 'SELECT @@server_id, SLEEP(65) /* First Query */', # Rows_examined => '0', # Rows_sent => '0', # State => 'User sleep', # Time => '34', # User => 'root', # db => undef # }; # # MasterSlave:4339 2173 Not system user # MasterSlave:4356 2173 Matches all replication thread: no ; match: 0 # Processlist:3490 2173 Exceeds busy time # Processlist:3521 2173 Query matches Info spec # Processlist:3527 2173 Query matched one or more specs, adding # pt_kill:7065 2173 1 queries in class default # pt_kill:7122 2173 1 queries to kill in class default # pt_kill:7225 2173 Matched 1 queries # 2015-05-30T23:11:02 KILL 34 (Query 34 sec) SELECT @@server_id, SLEEP(65) /* First Query */ # pt_kill:7204 2173 exec cmd: (date >> /root/execute.log) # pt_kill:7210 2173 child pid: 2177 # pt_kill:7225 2173 Executed (date >> /root/execute.log) # pt_kill:6802 2173 Killing process 34 # Retry:5068 2173 Try 1 of 2 # Retry:5085 2173 Try code succeeded # pt_kill:7225 2173 Killed 34 # pt_kill:7225 2173 Sleeping 15 seconds after normal interval # pt_kill:7218 2177 child exit status: 72057594037927935 # Cxn:5324 2177 Destroying cxn # Cxn:5333 2177 DBI::db=HASH(0x1f202d0) Disconnecting dbh on tslls.net h=localhost # pt_kill:7225 2173 Checking processlist # Retry:5068 2173 Try 1 of 1200 # Retry:5074 2173 Try code failed: DBD::mysql::st execute failed: MySQL server has gone away [for Statement "SHOW FULL PROCESSLIST"] at /usr/bin/pt-kill line 6772. # # DSNParser:2008 2173 DBI:mysql:;host=localhost;mysql_read_default_group=client # DSNParser:2057 2173 DBI:mysql:;host=localhost;mysql_read_default_group=client undef undef mysql_enable_utf8=>0, ShowErrorStatement=>1, AutoCommit=>1, RaiseError=>1, PrintError=>0 # DSNParser:2085 2173 DBI::db=HASH(0x25ff960) SELECT @@SQL_MODE # DSNParser:2216 2173 DBI::db=HASH(0x25ff960) SET SESSION wait_timeout=10000 # DSNParser:2116 2173 DBI::db=HASH(0x25ff960) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION'*/ # DSNParser:2125 2173 DBH info: DBI::db=HASH(0x25ff960) $VAR1 = { # '@@hostname' => 'tslls.net', # 'CONNECTION_ID()' => '35', # 'DATABASE()' => undef, # 'VERSION()' => '5.6.24-72.2' # }; # Connection info: Localhost via UNIX socket Character set info: $VAR1 = [ # { # Value => 'latin1', # Variable_name => 'character_set_client' # }, # { # Value => 'latin1', # Variable_name => 'character_set_connection' # }, # { # Value => 'latin1', # Variable_name => 'character_set_database' # }, # { # Value => 'binary', # Variable_name => 'character_set_filesystem' # }, # { # Value => 'latin1', # Variable_name => 'character_set_results' # }, # { # Value => 'latin1', # Variable_name => 'character_set_server' # }, # { # Value => 'utf8', # Variable_name => 'character_set_system' # }, # { # Value => '/usr/share/percona-server/charsets/', # Variable_name => 'character_sets_dir' # } # ]; # $DBD::mysql::VERSION: 4.013 $DBI::VERSION: 1.609 # Cxn:5210 2173 DBI::db=HASH(0x25ff960) Setting dbh # Cxn:5215 2173 DBI::db=HASH(0x25ff960) SELECT @@server_id /*!50038 , @@hostname*/ # Cxn:5217 2173 DBI::db=HASH(0x25ff960) hostname: tslls.net 0 # Cxn:5198 2173 DBI::db=HASH(0x25ff960) Connected dbh to tslls.net h=localhost # pt_kill:7225 2173 Reconnected to tslls.net # Retry:5080 2173 Calling wait code # Retry:5068 2173 Try 2 of 1200 # Retry:5085 2173 Try code succeeded # pt_kill:7247 2173 Grouping queries by undef # pt_kill:7062 2173 Finding matching queries in class default # Processlist:3468 2173 find specs: $VAR1 = { # all => undef, # busy_time => '30', # idle_time => undef, # ignore => { # Command => undef, # Host => undef, # Id => 33, # Info => undef, # State => 'Locked', # User => undef, # db => undef # }, # match => { # Command => undef, # Host => undef, # Info => '^SELECT', # State => undef, # User => undef, # db => undef # }, # replication_threads => undef # }; # # Processlist:3474 2173 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '35', # Info => 'SHOW FULL PROCESSLIST', # Rows_examined => '0', # Rows_sent => '0', # State => 'init', # Time => '0', # User => 'root', # db => undef # }; # # MasterSlave:4339 2173 Not system user # MasterSlave:4356 2173 Matches all replication thread: no ; match: 0 # Processlist:3486 2173 Query isn't running long enough # pt_kill:7065 2173 0 queries in class default # pt_kill:7225 2173 Matched 0 queries # pt_kill:7225 2173 Sleeping 15 seconds after normal interval # pt_kill:7225 2173 Checking processlist # Retry:5068 2173 Try 1 of 1200 # Retry:5085 2173 Try code succeeded # pt_kill:7247 2173 Grouping queries by undef # pt_kill:7062 2173 Finding matching queries in class default # Processlist:3468 2173 find specs: $VAR1 = { # all => undef, # busy_time => '30', # idle_time => undef, # ignore => { # Command => undef, # Host => undef, # Id => 33, # Info => undef, # State => 'Locked', # User => undef, # db => undef # }, # match => { # Command => undef, # Host => undef, # Info => '^SELECT', # State => undef, # User => undef, # db => undef # }, # replication_threads => undef # }; # # Processlist:3474 2173 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '35', # Info => 'SHOW FULL PROCESSLIST', # Rows_examined => '0', # Rows_sent => '0', # State => 'init', # Time => '0', # User => 'root', # db => undef [root@tslls ~]# cat .pt-kill.conf busy-time=30s log=/root/pt_kill.log pid=/root/pt_kill.pid execute-command=(date >> /root/execute.log) match-info=^SELECT kill print [root@tslls ~]# pt-kill --version pt-kill 2.2.14 [root@tslls ~]# yum list installed Percona* | grep -i server Percona-Server-client-56.x86_64 5.6.24-rel72.2.el6 @percona-release-x86_64 Percona-Server-server-56.x86_64 5.6.24-rel72.2.el6 @percona-release-x86_64 Percona-Server-shared-56.x86_64 5.6.24-rel72.2.el6 @percona-release-x86_64 [root@tslls ~]# yum list installed Percona* | grep -i server-server Percona-Server-server-56.x86_64 5.6.24-rel72.2.el6 @percona-release-x86_64 [root@tslls ~]# mysqld --version mysqld Ver 5.6.24-72.2 for Linux on x86_64 (Percona Server (GPL), Release 72.2, Revision 8d0f85b) [root@tslls ~]# pt-kill --version pt-kill 2.2.14 [root@tslls ~]# ll total 12 -rw-r--r--. 1 root root 29 May 30 23:11 execute.log -rw-r--r--. 1 root root 4 May 30 23:10 pt_kill.pid -rw-r--r--. 1 root root 197 May 30 22:48 temp_pt-kill.conf [root@tslls ~]# cat execute.log Sat May 30 23:11:02 UTC 2015 [root@tslls ~]# cat execute.log Sat May 30 23:11:02 UTC 2015 [root@tslls ~]# cat execute.log Sat May 30 23:11:02 UTC 2015 [root@tslls ~]# cat execute.log Sat May 30 23:11:02 UTC 2015 [root@tslls ~]# cat execute.log Sat May 30 23:11:02 UTC 2015 [root@tslls ~]# cat .pt-kill.conf busy-time=30s # pt_kill:7204 2173 exec cmd: (date >> /root/execute.log) # pt_kill:7210 2173 child pid: 2193 # pt_kill:7225 2173 Executed (date >> /root/execute.log) # pt_kill:6802 2173 Killing process 36 # Retry:5068 2173 Try 1 of 2 # Retry:5074 2173 Try code failed: DBD::mysql::st execute failed: MySQL server has gone away [for Statement "KILL ?" with ParamValues: 0=36] at /usr/bin/pt-kill line 6806. # # Cxn:5206 2173 DBI::db=HASH(0x25ff960) Already set dbh # Cxn:5198 2173 DBI::db=HASH(0x25ff960) Connected dbh to tslls.net h=localhost # pt_kill:7225 2173 Reconnected to tslls.net # Retry:5080 2173 Calling wait code # pt_kill:7218 2193 child exit status: 72057594037927935 # Cxn:5324 2193 Destroying cxn # Cxn:5333 2193 DBI::db=HASH(0x25ff960) Disconnecting dbh on tslls.net h=localhost # Retry:5068 2173 Try 2 of 2 # Retry:5074 2173 Try code failed: DBD::mysql::st execute failed: MySQL server has gone away [for Statement "KILL ?" with ParamValues: 0=36] at /usr/bin/pt-kill line 6806. # # Retry:5090 2173 Try code did not succeed # pt_kill:7225 2173 Error killing 36: DBD::mysql::st execute failed: MySQL server has gone away [for Statement "KILL ?" with ParamValues: 0=36] at /usr/bin/pt-kill line 6806. # # pt_kill:7225 2173 Sleeping 15 seconds after normal interval # pt_kill:7225 2173 Checking processlist # Retry:5068 2173 Try 1 of 1200 # Retry:5074 2173 Try code failed: DBD::mysql::st execute failed: MySQL server has gone away [for Statement "SHOW FULL PROCESSLIST"] at /usr/bin/pt-kill line 6772. # # DSNParser:2008 2173 DBI:mysql:;host=localhost;mysql_read_default_group=client # DSNParser:2057 2173 DBI:mysql:;host=localhost;mysql_read_default_group=client undef undef mysql_enable_utf8=>0, ShowErrorStatement=>1, AutoCommit=>1, RaiseError=>1, PrintError=>0 # DSNParser:2085 2173 DBI::db=HASH(0x23b4bb0) SELECT @@SQL_MODE # DSNParser:2216 2173 DBI::db=HASH(0x23b4bb0) SET SESSION wait_timeout=10000 # DSNParser:2116 2173 DBI::db=HASH(0x23b4bb0) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION'*/ # DSNParser:2125 2173 DBH info: DBI::db=HASH(0x23b4bb0) $VAR1 = { # '@@hostname' => 'tslls.net', # 'CONNECTION_ID()' => '37', # 'DATABASE()' => undef, # 'VERSION()' => '5.6.24-72.2' # }; # Connection info: Localhost via UNIX socket Character set info: $VAR1 = [ # { # Value => 'latin1', # Variable_name => 'character_set_client' # }, # { # Value => 'latin1', # Variable_name => 'character_set_connection' # }, # { # Value => 'latin1', # Variable_name => 'character_set_database' # }, # { # Value => 'binary', # Variable_name => 'character_set_filesystem' # }, # { # Value => 'latin1', # Variable_name => 'character_set_results' # }, # { # Value => 'latin1', # Variable_name => 'character_set_server' # }, # { # Value => 'utf8', # Variable_name => 'character_set_system' # }, # { # Value => '/usr/share/percona-server/charsets/', # Variable_name => 'character_sets_dir' # } # ]; # $DBD::mysql::VERSION: 4.013 $DBI::VERSION: 1.609 # Cxn:5210 2173 DBI::db=HASH(0x23b4bb0) Setting dbh # Cxn:5215 2173 DBI::db=HASH(0x23b4bb0) SELECT @@server_id /*!50038 , @@hostname*/ # Cxn:5217 2173 DBI::db=HASH(0x23b4bb0) hostname: tslls.net 0 # Cxn:5198 2173 DBI::db=HASH(0x23b4bb0) Connected dbh to tslls.net h=localhost # pt_kill:7225 2173 Reconnected to tslls.net # Retry:5080 2173 Calling wait code # Retry:5068 2173 Try 2 of 1200 # Retry:5085 2173 Try code succeeded # pt_kill:7247 2173 Grouping queries by undef # pt_kill:7062 2173 Finding matching queries in class default # Processlist:3468 2173 find specs: $VAR1 = { # all => undef, # busy_time => '30', # idle_time => undef, # ignore => { # Command => undef, # Host => undef, # Id => 33, # Info => undef, # State => 'Locked', # User => undef, # db => undef # }, # match => { # Command => undef, # Host => undef, # Info => '^SELECT', # State => undef, # User => undef, # db => undef # }, # replication_threads => undef # }; # # Processlist:3474 2173 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '36', # Info => 'SELECT @@server_id, SLEEP(65) /* Second Query */', # Rows_examined => '0', # Rows_sent => '0', # State => 'User sleep', # Time => '56', # User => 'root', # db => undef # }; # # MasterSlave:4339 2173 Not system user # MasterSlave:4356 2173 Matches all replication thread: no ; match: 0 # Processlist:3490 2173 Exceeds busy time # Processlist:3521 2173 Query matches Info spec # Processlist:3527 2173 Query matched one or more specs, adding # Processlist:3474 2173 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '37', # Info => 'SHOW FULL PROCESSLIST', # Rows_examined => '0', # Rows_sent => '0', # State => 'init', # Time => '0', # User => 'root', # db => undef # }; # # MasterSlave:4339 2173 Not system user # MasterSlave:4356 2173 Matches all replication thread: no ; match: 0 # Processlist:3486 2173 Query isn't running long enough # pt_kill:7065 2173 1 queries in class default # pt_kill:7122 2173 1 queries to kill in class default # pt_kill:7225 2173 Matched 1 queries # 2015-05-30T23:12:39 KILL 36 (Query 56 sec) SELECT @@server_id, SLEEP(65) /* Second Query */ # pt_kill:7204 2173 exec cmd: (date >> /root/execute.log) # pt_kill:7210 2173 child pid: 2200 # pt_kill:7225 2173 Executed (date >> /root/execute.log) # pt_kill:6802 2173 Killing process 36 # Retry:5068 2173 Try 1 of 2 # Retry:5074 2173 Try code failed: DBD::mysql::st execute failed: MySQL server has gone away [for Statement "KILL ?" with ParamValues: 0=36] at /usr/bin/pt-kill line 6806. # # Cxn:5206 2173 DBI::db=HASH(0x23b4bb0) Already set dbh # Cxn:5198 2173 DBI::db=HASH(0x23b4bb0) Connected dbh to tslls.net h=localhost # pt_kill:7225 2173 Reconnected to tslls.net # Retry:5080 2173 Calling wait code # pt_kill:7218 2200 child exit status: 72057594037927935 # Cxn:5324 2200 Destroying cxn # Cxn:5333 2200 DBI::db=HASH(0x23b4bb0) Disconnecting dbh on tslls.net h=localhost # Retry:5068 2173 Try 2 of 2 # Retry:5074 2173 Try code failed: DBD::mysql::st execute failed: MySQL server has gone away [for Statement "KILL ?" with ParamValues: 0=36] at /usr/bin/pt-kill line 6806. # # Retry:5090 2173 Try code did not succeed # pt_kill:7225 2173 Error killing 36: DBD::mysql::st execute failed: MySQL server has gone away [for Statement "KILL ?" with ParamValues: 0=36] at /usr/bin/pt-kill line 6806. # # pt_kill:7225 2173 Sleeping 15 seconds after normal interval # pt_kill:7225 2173 Checking processlist # Retry:5068 2173 Try 1 of 1200 # Retry:5074 2173 Try code failed: DBD::mysql::st execute failed: MySQL server has gone away [for Statement "SHOW FULL PROCESSLIST"] at /usr/bin/pt-kill line 6772. # # DSNParser:2008 2173 DBI:mysql:;host=localhost;mysql_read_default_group=client # DSNParser:2057 2173 DBI:mysql:;host=localhost;mysql_read_default_group=client undef undef mysql_enable_utf8=>0, ShowErrorStatement=>1, AutoCommit=>1, RaiseError=>1, PrintError=>0 # DSNParser:2085 2173 DBI::db=HASH(0x25fb020) SELECT @@SQL_MODE # DSNParser:2216 2173 DBI::db=HASH(0x25fb020) SET SESSION wait_timeout=10000 # DSNParser:2116 2173 DBI::db=HASH(0x25fb020) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION'*/ # DSNParser:2125 2173 DBH info: DBI::db=HASH(0x25fb020) $VAR1 = { # '@@hostname' => 'tslls.net', # 'CONNECTION_ID()' => '38', # 'DATABASE()' => undef, # 'VERSION()' => '5.6.24-72.2' # }; # Connection info: Localhost via UNIX socket Character set info: $VAR1 = [ # { # Value => 'latin1', # Variable_name => 'character_set_client' # }, # { # Value => 'latin1', # Variable_name => 'character_set_connection' # }, # { # Value => 'latin1', # Variable_name => 'character_set_database' # }, # { # Value => 'binary', # Variable_name => 'character_set_filesystem' # }, # { # Value => 'latin1', # Variable_name => 'character_set_results' # }, # { # Value => 'latin1', # Variable_name => 'character_set_server' # }, # { # Value => 'utf8', # Variable_name => 'character_set_system' # }, # { # Value => '/usr/share/percona-server/charsets/', # Variable_name => 'character_sets_dir' # } # ]; # $DBD::mysql::VERSION: 4.013 $DBI::VERSION: 1.609 # Cxn:5210 2173 DBI::db=HASH(0x25fb020) Setting dbh # Cxn:5215 2173 DBI::db=HASH(0x25fb020) SELECT @@server_id /*!50038 , @@hostname*/ # Cxn:5217 2173 DBI::db=HASH(0x25fb020) hostname: tslls.net 0 # Cxn:5198 2173 DBI::db=HASH(0x25fb020) Connected dbh to tslls.net h=localhost # pt_kill:7225 2173 Reconnected to tslls.net # Retry:5080 2173 Calling wait code # Retry:5068 2173 Try 2 of 1200 # Retry:5085 2173 Try code succeeded # pt_kill:7247 2173 Grouping queries by undef # pt_kill:7062 2173 Finding matching queries in class default # Processlist:3468 2173 find specs: $VAR1 = { # all => undef, # busy_time => '30', # idle_time => undef, # ignore => { # Command => undef, # Host => undef, # Id => 33, # Info => undef, # State => 'Locked', # User => undef, # db => undef # }, # match => { # Command => undef, # Host => undef, # Info => '^SELECT', # State => undef, # User => undef, # db => undef # }, # replication_threads => undef # }; # # Processlist:3474 2173 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '38', # Info => 'SHOW FULL PROCESSLIST', # Rows_examined => '0', # Rows_sent => '0', # State => 'init', # Time => '0', # User => 'root', # db => undef # }; # # MasterSlave:4339 2173 Not system user # MasterSlave:4356 2173 Matches all replication thread: no ; match: 0 # Processlist:3486 2173 Query isn't running long enough # pt_kill:7065 2173 0 queries in class default # pt_kill:7225 2173 Matched 0 queries # pt_kill:7225 2173 Sleeping 15 seconds after normal interval # pt_kill:7225 2173 Sentinel file /tmp/pt-kill-sentinel exists # pt_kill:7225 2173 /usr/bin/pt-kill ending # Daemon:2414 2173 Removed PID file # Cxn:5324 2173 Destroying cxn # Cxn:5333 2173 DBI::db=HASH(0x25fb020) Disconnecting dbh on tslls.net h=localhost