# /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 1408 Option rule: Specify at least one of --kill, --kill-query, --print, --execute-command or --stop. # OptionParser:282 1408 Option rule: --any-busy-time and --each-busy-time are mutually exclusive. # OptionParser:282 1408 Option rule: --kill and --kill-query are mutually exclusive. # OptionParser:282 1408 Option rule: --daemonize and --test-matching are mutually exclusive. # OptionParser:282 1408 Option rule: This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details. # OptionParser:291 1408 =item --ask-pass # OptionParser:310 1408 Option has no attributes # OptionParser:318 1408 Short help: Prompt for a password when connecting to MySQL # OptionParser:291 1408 =item --charset # OptionParser:318 1408 Short help: Default character set # OptionParser:291 1408 =item --config # OptionParser:318 1408 Short help: Read this comma-separated list of config files; if specified, this must be the first option on the command line # OptionParser:291 1408 =item --create-log-table # OptionParser:310 1408 Option has no attributes # OptionParser:318 1408 Short help: Create the --log-dsn table if it does not exist # OptionParser:291 1408 =item --daemonize # OptionParser:310 1408 Option has no attributes # OptionParser:318 1408 Short help: Fork to the background and detach from the shell # OptionParser:291 1408 =item --database # OptionParser:318 1408 Short help: The database to use for the connection # OptionParser:291 1408 =item --defaults-file # OptionParser:318 1408 Short help: Only read mysql options from the given file # OptionParser:291 1408 =item --filter # OptionParser:318 1408 Short help: Discard events for which this Perl code doesn't return true # OptionParser:291 1408 =item --group-by # OptionParser:318 1408 Short help: Apply matches to each class of queries grouped by this SHOW PROCESSLIST column # OptionParser:291 1408 =item --help # OptionParser:310 1408 Option has no attributes # OptionParser:318 1408 Short help: Show help and exit # OptionParser:291 1408 =item --host # OptionParser:318 1408 Short help: Connect to host # OptionParser:291 1408 =item --interval # OptionParser:318 1408 Short help: How often to check for queries to kill # OptionParser:291 1408 =item --log # OptionParser:318 1408 Short help: Print all output to this file when daemonized # OptionParser:291 1408 =item --log-dsn # OptionParser:318 1408 Short help: Store each query killed in this DSN # OptionParser:291 1408 =item --password # OptionParser:318 1408 Short help: Password to use when connecting # OptionParser:291 1408 =item --pid # OptionParser:318 1408 Short help: Create the given PID file # OptionParser:291 1408 =item --port # OptionParser:318 1408 Short help: Port number to use for connection # OptionParser:291 1408 =item --query-id # OptionParser:310 1408 Option has no attributes # OptionParser:318 1408 Short help: Prints an ID of the query that was just killed # OptionParser:291 1408 =item --run-time # OptionParser:318 1408 Short help: How long to run before exiting # OptionParser:291 1408 =item --sentinel # OptionParser:318 1408 Short help: Exit if this file exists # OptionParser:291 1408 =item --set-vars # OptionParser:318 1408 Short help: Set the MySQL variables in this comma-separated list of variable=value pairs # OptionParser:291 1408 =item --socket # OptionParser:318 1408 Short help: Socket file to use for connection # OptionParser:291 1408 =item --stop # OptionParser:310 1408 Option has no attributes # OptionParser:318 1408 Short help: Stop running instances by creating the --sentinel file # OptionParser:291 1408 =item --[no]strip-comments # OptionParser:318 1408 Short help: Remove SQL comments from queries in the Info column of the PROCESSLIST # OptionParser:291 1408 =item --user # OptionParser:318 1408 Short help: User for login if not current user # OptionParser:291 1408 =item --version # OptionParser:310 1408 Option has no attributes # OptionParser:318 1408 Short help: Show version and exit # OptionParser:291 1408 =item --[no]version-check # OptionParser:318 1408 Short help: Check for the latest version of Percona Toolkit, MySQL, and other programs # OptionParser:291 1408 =item --victims # OptionParser:318 1408 Short help: Which of the matching queries in each class will be killed # OptionParser:291 1408 =item --wait-after-kill # OptionParser:318 1408 Short help: Wait after killing a query, before looking for more to kill # OptionParser:291 1408 =item --wait-before-kill # OptionParser:318 1408 Short help: Wait before killing a query # OptionParser:291 1408 =item --busy-time # OptionParser:318 1408 Short help: Match queries that have been running for longer than this time # OptionParser:291 1408 =item --idle-time # OptionParser:318 1408 Short help: Match queries that have been idle/sleeping for longer than this time # OptionParser:291 1408 =item --ignore-command # OptionParser:318 1408 Short help: Ignore queries whose Command matches this Perl regex # OptionParser:291 1408 =item --ignore-db # OptionParser:318 1408 Short help: Ignore queries whose db (database) matches this Perl regex # OptionParser:291 1408 =item --ignore-host # OptionParser:318 1408 Short help: Ignore queries whose Host matches this Perl regex # OptionParser:291 1408 =item --ignore-info # OptionParser:318 1408 Short help: Ignore queries whose Info (query) matches this Perl regex # OptionParser:291 1408 =item --[no]ignore-self # OptionParser:318 1408 Short help: Don't kill pt-kill's own connection # OptionParser:291 1408 =item --ignore-state # OptionParser:318 1408 Short help: Ignore queries whose State matches this Perl regex # OptionParser:291 1408 =item --ignore-user # OptionParser:318 1408 Short help: Ignore queries whose user matches this Perl regex # OptionParser:291 1408 =item --match-all # OptionParser:318 1408 Short help: Match all queries that are not ignored # OptionParser:291 1408 =item --match-command # OptionParser:318 1408 Short help: Match only queries whose Command matches this Perl regex # OptionParser:291 1408 =item --match-db # OptionParser:318 1408 Short help: Match only queries whose db (database) matches this Perl regex # OptionParser:291 1408 =item --match-host # OptionParser:318 1408 Short help: Match only queries whose Host matches this Perl regex # OptionParser:291 1408 =item --match-info # OptionParser:318 1408 Short help: Match only queries whose Info (query) matches this Perl regex # OptionParser:291 1408 =item --match-state # OptionParser:318 1408 Short help: Match only queries whose State matches this Perl regex # OptionParser:291 1408 =item --match-user # OptionParser:318 1408 Short help: Match only queries whose User matches this Perl regex # OptionParser:291 1408 =item --replication-threads # OptionParser:318 1408 Short help: Allow matching and killing replication threads # OptionParser:291 1408 =item --test-matching # OptionParser:318 1408 Short help: Files with processlist snapshots to test matching options against # OptionParser:291 1408 =item --any-busy-time # OptionParser:318 1408 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 1408 =item --each-busy-time # OptionParser:318 1408 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 1408 =item --query-count # OptionParser:318 1408 Short help: Match query class if it has at least this many queries # OptionParser:291 1408 =item --verbose # OptionParser:318 1408 Short help: Print information to STDOUT about what is being done # OptionParser:291 1408 =item --execute-command # OptionParser:318 1408 Short help: Execute this command when a query matches # OptionParser:291 1408 =item --kill # OptionParser:318 1408 Short help: Kill the connection for matching queries # OptionParser:291 1408 =item --kill-query # OptionParser:318 1408 Short help: Kill matching queries # OptionParser:291 1408 =item --print # OptionParser:318 1408 Short help: Print a KILL statement for matching queries; does not actually kill queries # OptionParser:357 1408 Parsing opt spec: group => default spec => ask-pass desc => Prompt for a password when connecting to MySQL # OptionParser:395 1408 ask-pass type: undef # OptionParser:357 1408 Parsing opt spec: group => default spec => charset|A=s desc => Default character set # OptionParser:395 1408 charset type: s # OptionParser:357 1408 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 1408 config type: A # OptionParser:357 1408 Parsing opt spec: group => default spec => create-log-table desc => Create the --log-dsn table if it does not exist # OptionParser:395 1408 create-log-table type: undef # OptionParser:357 1408 Parsing opt spec: group => default spec => daemonize desc => Fork to the background and detach from the shell # OptionParser:395 1408 daemonize type: undef # OptionParser:357 1408 Parsing opt spec: group => default spec => database|D=s desc => The database to use for the connection # OptionParser:395 1408 database type: s # OptionParser:357 1408 Parsing opt spec: group => default spec => defaults-file|F=s desc => Only read mysql options from the given file # OptionParser:395 1408 defaults-file type: s # OptionParser:357 1408 Parsing opt spec: group => default spec => filter=s desc => Discard events for which this Perl code doesn't return true # OptionParser:395 1408 filter type: s # OptionParser:357 1408 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 1408 group-by type: s # OptionParser:357 1408 Parsing opt spec: group => default spec => help desc => Show help and exit # OptionParser:395 1408 help type: undef # OptionParser:357 1408 Parsing opt spec: group => default spec => host|h=s desc => Connect to host (default localhost) # OptionParser:395 1408 host type: s # OptionParser:402 1408 host default: localhost # OptionParser:357 1408 Parsing opt spec: group => default spec => interval=m desc => How often to check for queries to kill # OptionParser:395 1408 interval type: m # OptionParser:357 1408 Parsing opt spec: group => default spec => log=s desc => Print all output to this file when daemonized # OptionParser:395 1408 log type: s # OptionParser:357 1408 Parsing opt spec: group => default spec => log-dsn=d desc => Store each query killed in this DSN # OptionParser:395 1408 log-dsn type: d # OptionParser:357 1408 Parsing opt spec: group => default spec => password|p=s desc => Password to use when connecting # OptionParser:395 1408 password type: s # OptionParser:357 1408 Parsing opt spec: group => default spec => pid=s desc => Create the given PID file # OptionParser:395 1408 pid type: s # OptionParser:357 1408 Parsing opt spec: group => default spec => port|P=i desc => Port number to use for connection # OptionParser:395 1408 port type: i # OptionParser:357 1408 Parsing opt spec: group => default spec => query-id desc => Prints an ID of the query that was just killed # OptionParser:395 1408 query-id type: undef # OptionParser:357 1408 Parsing opt spec: group => default spec => run-time=m desc => How long to run before exiting # OptionParser:395 1408 run-time type: m # OptionParser:357 1408 Parsing opt spec: group => default spec => sentinel=s desc => Exit if this file exists (default /tmp/pt-kill-sentinel) # OptionParser:395 1408 sentinel type: s # OptionParser:402 1408 sentinel default: /tmp/pt-kill-sentinel # OptionParser:357 1408 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 1408 set-vars type: A # OptionParser:357 1408 Parsing opt spec: group => default spec => socket|S=s desc => Socket file to use for connection # OptionParser:395 1408 socket type: s # OptionParser:357 1408 Parsing opt spec: group => default spec => stop desc => Stop running instances by creating the --sentinel file # OptionParser:395 1408 stop type: undef # OptionParser:357 1408 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 1408 strip-comments type: undef # OptionParser:402 1408 strip-comments default: yes # OptionParser:357 1408 Parsing opt spec: group => default spec => user|u=s desc => User for login if not current user # OptionParser:395 1408 user type: s # OptionParser:357 1408 Parsing opt spec: group => default spec => version desc => Show version and exit # OptionParser:395 1408 version type: undef # OptionParser:357 1408 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 1408 version-check type: undef # OptionParser:402 1408 version-check default: yes # OptionParser:357 1408 Parsing opt spec: group => default spec => victims=s desc => Which of the matching queries in each class will be killed (default oldest) # OptionParser:395 1408 victims type: s # OptionParser:402 1408 victims default: oldest # OptionParser:357 1408 Parsing opt spec: group => default spec => wait-after-kill=m desc => Wait after killing a query, before looking for more to kill # OptionParser:395 1408 wait-after-kill type: m # OptionParser:357 1408 Parsing opt spec: group => default spec => wait-before-kill=m desc => Wait before killing a query # OptionParser:395 1408 wait-before-kill type: m # OptionParser:357 1408 Parsing opt spec: group => Query Matches spec => busy-time=m desc => Match queries that have been running for longer than this time # OptionParser:395 1408 busy-time type: m # OptionParser:357 1408 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 1408 idle-time type: m # OptionParser:357 1408 Parsing opt spec: group => Query Matches spec => ignore-command=s desc => Ignore queries whose Command matches this Perl regex # OptionParser:395 1408 ignore-command type: s # OptionParser:357 1408 Parsing opt spec: group => Query Matches spec => ignore-db=s desc => Ignore queries whose db (database) matches this Perl regex # OptionParser:395 1408 ignore-db type: s # OptionParser:357 1408 Parsing opt spec: group => Query Matches spec => ignore-host=s desc => Ignore queries whose Host matches this Perl regex # OptionParser:395 1408 ignore-host type: s # OptionParser:357 1408 Parsing opt spec: group => Query Matches spec => ignore-info=s desc => Ignore queries whose Info (query) matches this Perl regex # OptionParser:395 1408 ignore-info type: s # OptionParser:357 1408 Parsing opt spec: group => Query Matches spec => ignore-self! desc => Don't kill pt-kill's own connection (default yes) # OptionParser:395 1408 ignore-self type: undef # OptionParser:402 1408 ignore-self default: yes # OptionParser:357 1408 Parsing opt spec: group => Query Matches spec => ignore-state=s desc => Ignore queries whose State matches this Perl regex (default Locked) # OptionParser:395 1408 ignore-state type: s # OptionParser:402 1408 ignore-state default: Locked # OptionParser:357 1408 Parsing opt spec: group => Query Matches spec => ignore-user=s desc => Ignore queries whose user matches this Perl regex # OptionParser:395 1408 ignore-user type: s # OptionParser:357 1408 Parsing opt spec: group => Query Matches spec => match-all desc => Match all queries that are not ignored # OptionParser:395 1408 match-all type: undef # OptionParser:357 1408 Parsing opt spec: group => Query Matches spec => match-command=s desc => Match only queries whose Command matches this Perl regex # OptionParser:395 1408 match-command type: s # OptionParser:357 1408 Parsing opt spec: group => Query Matches spec => match-db=s desc => Match only queries whose db (database) matches this Perl regex # OptionParser:395 1408 match-db type: s # OptionParser:357 1408 Parsing opt spec: group => Query Matches spec => match-host=s desc => Match only queries whose Host matches this Perl regex # OptionParser:395 1408 match-host type: s # OptionParser:357 1408 Parsing opt spec: group => Query Matches spec => match-info=s desc => Match only queries whose Info (query) matches this Perl regex # OptionParser:395 1408 match-info type: s # OptionParser:357 1408 Parsing opt spec: group => Query Matches spec => match-state=s desc => Match only queries whose State matches this Perl regex # OptionParser:395 1408 match-state type: s # OptionParser:357 1408 Parsing opt spec: group => Query Matches spec => match-user=s desc => Match only queries whose User matches this Perl regex # OptionParser:395 1408 match-user type: s # OptionParser:357 1408 Parsing opt spec: group => Query Matches spec => replication-threads desc => Allow matching and killing replication threads # OptionParser:395 1408 replication-threads type: undef # OptionParser:357 1408 Parsing opt spec: group => Query Matches spec => test-matching=a desc => Files with processlist snapshots to test matching options against # OptionParser:395 1408 test-matching type: a # OptionParser:357 1408 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 1408 any-busy-time type: m # OptionParser:357 1408 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 1408 each-busy-time type: m # OptionParser:357 1408 Parsing opt spec: group => Class Matches spec => query-count=i desc => Match query class if it has at least this many queries # OptionParser:395 1408 query-count type: i # OptionParser:357 1408 Parsing opt spec: group => default spec => verbose|v desc => Print information to STDOUT about what is being done # OptionParser:395 1408 verbose type: undef # OptionParser:357 1408 Parsing opt spec: group => Actions spec => execute-command=s desc => Execute this command when a query matches # OptionParser:395 1408 execute-command type: s # OptionParser:357 1408 Parsing opt spec: group => Actions spec => kill desc => Kill the connection for matching queries # OptionParser:395 1408 kill type: undef # OptionParser:357 1408 Parsing opt spec: group => Actions spec => kill-query desc => Kill matching queries # OptionParser:395 1408 kill-query type: undef # OptionParser:357 1408 Parsing opt spec: group => Actions spec => print desc => Print a KILL statement for matching queries; does not actually kill queries # OptionParser:395 1408 print type: undef # OptionParser:417 1408 Parsing rule: Specify at least one of --kill, --kill-query, --print, --execute-command or --stop. # OptionParser:473 1408 Participants for Specify at least one of --kill, --kill-query, --print, --execute-command or --stop. : kill kill-query print execute-command stop # OptionParser:430 1408 kill kill-query print execute-command stop require at least one # OptionParser:417 1408 Parsing rule: --any-busy-time and --each-busy-time are mutually exclusive. # OptionParser:473 1408 Participants for --any-busy-time and --each-busy-time are mutually exclusive. : any-busy-time each-busy-time # OptionParser:425 1408 any-busy-time each-busy-time are mutually exclusive # OptionParser:417 1408 Parsing rule: --kill and --kill-query are mutually exclusive. # OptionParser:473 1408 Participants for --kill and --kill-query are mutually exclusive. : kill kill-query # OptionParser:425 1408 kill kill-query are mutually exclusive # OptionParser:417 1408 Parsing rule: --daemonize and --test-matching are mutually exclusive. # OptionParser:473 1408 Participants for --daemonize and --test-matching are mutually exclusive. : daemonize test-matching # OptionParser:425 1408 daemonize test-matching are mutually exclusive # OptionParser:417 1408 Parsing rule: This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details. # OptionParser:473 1408 Participants for This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details. : # OptionParser:449 1408 Strict mode disabled by rule # OptionParser:201 1408 Parsing DSN OPTIONS # OptionParser:291 1408 =item * A # OptionParser:318 1408 Short help: Default character set # OptionParser:291 1408 =item * D # OptionParser:318 1408 Short help: Default database # OptionParser:291 1408 =item * F # OptionParser:318 1408 Short help: Only read default options from the given file # OptionParser:291 1408 =item * h # OptionParser:318 1408 Short help: Connect to host # OptionParser:291 1408 =item * p # OptionParser:318 1408 Short help: Password to use when connecting # OptionParser:291 1408 =item * P # OptionParser:318 1408 Short help: Port number to use for connection # OptionParser:291 1408 =item * S # OptionParser:318 1408 Short help: Socket file to use for connection # OptionParser:291 1408 =item * u # OptionParser:318 1408 Short help: User for login if not current user # OptionParser:291 1408 =item * t # OptionParser:310 1408 Option has no attributes # OptionParser:318 1408 Short help: Table to log actions in, if passed through --log-dsn # DSNParser:1867 1408 DSN option: copy=1, dsn=charset, desc=Default character set, key=A # DSNParser:1867 1408 DSN option: copy=1, dsn=database, desc=Default database, key=D # DSNParser:1867 1408 DSN option: copy=1, dsn=mysql_read_default_file, desc=Only read default options from the given file, key=F # DSNParser:1867 1408 DSN option: copy=1, dsn=host, desc=Connect to host, key=h # DSNParser:1867 1408 DSN option: copy=1, dsn=password, desc=Password to use when connecting, key=p # DSNParser:1867 1408 DSN option: copy=1, dsn=port, desc=Port number to use for connection, key=P # DSNParser:1867 1408 DSN option: copy=1, dsn=mysql_socket, desc=Socket file to use for connection, key=S # DSNParser:1867 1408 DSN option: copy=1, dsn=user, desc=User for login if not current user, key=u # DSNParser:1867 1408 DSN option: copy=undef, dsn=undef, desc=Table to log actions in, if passed through --log-dsn, key=t # OptionParser:245 1408 pt-kill 2.2.14 # OptionParser:567 1408 Cannot open /etc/percona-toolkit/percona-toolkit.conf: No such file or directory # # OptionParser:567 1408 Cannot open /etc/percona-toolkit/pt-kill.conf: No such file or directory # # OptionParser:567 1408 Cannot open /root/.percona-toolkit.conf: No such file or directory # # OptionParser:535 1408 Got option busy-time = 30s # OptionParser:535 1408 Got option log = /root/pt_kill.log # OptionParser:535 1408 Got option pid = /root/pt_kill.pid # OptionParser:535 1408 Got option match-info = ^SELECT # OptionParser:535 1408 Got option execute-command = (date >> /root/execute.log) # OptionParser:535 1408 Got option kill = 1 # OptionParser:535 1408 Got option print = 1 # OptionParser:755 1408 Nothing to validate for option match-state type s value undef # OptionParser:755 1408 Nothing to validate for option sentinel type s value /tmp/pt-kill-sentinel # OptionParser:755 1408 Nothing to validate for option log-dsn type d value undef # OptionParser:755 1408 Nothing to validate for option wait-after-kill type m value undef # OptionParser:755 1408 Nothing to validate for option password type s value undef # OptionParser:755 1408 Nothing to validate for option ignore-host type s value undef # OptionParser:755 1408 Nothing to validate for option pid type s value /root/pt_kill.pid # OptionParser:755 1408 Nothing to validate for option user type s value undef # OptionParser:755 1408 Nothing to validate for option match-user type s value undef # OptionParser:706 1408 Parsing option busy-time as a time value # OptionParser:720 1408 Setting option busy-time to 30 # OptionParser:755 1408 Nothing to validate for option charset type s value undef # OptionParser:755 1408 Nothing to validate for option interval type m value undef # OptionParser:755 1408 Nothing to validate for option port type i value undef # OptionParser:755 1408 Nothing to validate for option socket type s value undef # OptionParser:755 1408 Nothing to validate for option ignore-user type s value undef # OptionParser:755 1408 Nothing to validate for option victims type s value oldest # OptionParser:755 1408 Nothing to validate for option each-busy-time type m value undef # OptionParser:755 1408 Nothing to validate for option ignore-state type s value Locked # OptionParser:755 1408 Nothing to validate for option query-count type i value undef # OptionParser:755 1408 Nothing to validate for option run-time type m value undef # OptionParser:755 1408 Nothing to validate for option ignore-command type s value undef # OptionParser:755 1408 Nothing to validate for option match-host type s value undef # OptionParser:755 1408 Nothing to validate for option group-by type s value undef # OptionParser:755 1408 Nothing to validate for option log type s value /root/pt_kill.log # OptionParser:755 1408 Nothing to validate for option idle-time type m value undef # OptionParser:755 1408 Nothing to validate for option filter type s value undef # OptionParser:755 1408 Nothing to validate for option test-matching type a value undef # OptionParser:755 1408 Nothing to validate for option host type s value localhost # OptionParser:755 1408 Nothing to validate for option defaults-file type s value undef # OptionParser:755 1408 Nothing to validate for option match-db type s value undef # OptionParser:755 1408 Nothing to validate for option database type s value undef # OptionParser:755 1408 Nothing to validate for option any-busy-time type m value undef # OptionParser:755 1408 Nothing to validate for option match-command type s value undef # OptionParser:755 1408 Nothing to validate for option ignore-db type s value undef # OptionParser:755 1408 Nothing to validate for option match-info type s value ^SELECT # OptionParser:755 1408 Nothing to validate for option wait-before-kill type m value undef # OptionParser:755 1408 Nothing to validate for option execute-command type s value (date >> /root/execute.log) # OptionParser:755 1408 Nothing to validate for option ignore-info type s value undef # OptionParser:1149 1408 --set-vars: $VAR1 = { # wait_timeout => { # default => 1, # val => '10000' # } # }; # # DSNParser:1883 1408 Setting set-vars property # OptionParser:829 1408 Getting description and usage from SYNOPSIS in /usr/bin/pt-kill # OptionParser:1082 1408 Parsing SYNOPSIS in /usr/bin/pt-kill # OptionParser:1095 1408 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 1408 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 1408 Getting processlist from MySQL # DSNParser:1955 1408 DSN string made from options: h=localhost # DSNParser:1895 1408 Parsing h=localhost # DSNParser:1914 1408 Finding value for S # DSNParser:1924 1408 Copying value for S from defaults # DSNParser:1914 1408 Finding value for F # DSNParser:1924 1408 Copying value for F from defaults # DSNParser:1914 1408 Finding value for A # DSNParser:1924 1408 Copying value for A from defaults # DSNParser:1914 1408 Finding value for P # DSNParser:1924 1408 Copying value for P from defaults # DSNParser:1914 1408 Finding value for p # DSNParser:1924 1408 Copying value for p from defaults # DSNParser:1914 1408 Finding value for u # DSNParser:1924 1408 Copying value for u from defaults # DSNParser:1914 1408 Finding value for h # DSNParser:1914 1408 Finding value for D # DSNParser:1924 1408 Copying value for D from defaults # DSNParser:1914 1408 Finding value for t # DSNParser:1924 1408 Copying value for t from defaults # DSNParser:1895 1408 Parsing h=localhost # DSNParser:1914 1408 Finding value for S # DSNParser:1924 1408 Copying value for S from defaults # DSNParser:1914 1408 Finding value for F # DSNParser:1924 1408 Copying value for F from defaults # DSNParser:1914 1408 Finding value for A # DSNParser:1924 1408 Copying value for A from defaults # DSNParser:1914 1408 Finding value for P # DSNParser:1924 1408 Copying value for P from defaults # DSNParser:1914 1408 Finding value for p # DSNParser:1924 1408 Copying value for p from defaults # DSNParser:1914 1408 Finding value for u # DSNParser:1924 1408 Copying value for u from defaults # DSNParser:1914 1408 Finding value for h # DSNParser:1914 1408 Finding value for D # DSNParser:1924 1408 Copying value for D from defaults # DSNParser:1914 1408 Finding value for t # DSNParser:1924 1408 Copying value for t from defaults # DSNParser:2008 1408 DBI:mysql:;host=localhost;mysql_read_default_group=client # DSNParser:2057 1408 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 1408 DBI::db=HASH(0x160f2d0) SELECT @@SQL_MODE # DSNParser:2216 1408 DBI::db=HASH(0x160f2d0) SET SESSION wait_timeout=10000 # DSNParser:2116 1408 DBI::db=HASH(0x160f2d0) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION'*/ # DSNParser:2125 1408 DBH info: DBI::db=HASH(0x160f2d0) $VAR1 = { # '@@hostname' => 'tslls.net', # 'CONNECTION_ID()' => '6', # '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 1408 DBI::db=HASH(0x160f2d0) Setting dbh # Cxn:5215 1408 DBI::db=HASH(0x160f2d0) SELECT @@server_id /*!50038 , @@hostname*/ # Cxn:5217 1408 DBI::db=HASH(0x160f2d0) hostname: tslls.net 0 # Cxn:5198 1408 DBI::db=HASH(0x160f2d0) Connected dbh to tslls.net h=localhost # Daemon:2344 1408 Checking PID file /root/pt_kill.pid # Daemon:2354 1408 PID file exists; it contains PID 1387 Overwriting PID file /root/pt_kill.pid because the PID that it contains, 1387, is not running at /usr/bin/pt-kill line 2362. # Daemon:2281 1408 Daemonized child will log to /root/pt_kill.log # Daemon:2344 1408 Checking PID file /root/pt_kill.pid # Daemon:2354 1408 PID file exists; it contains PID 1387 Overwriting PID file /root/pt_kill.pid because the PID that it contains, 1387, is not running at /usr/bin/pt-kill line 2362. # Daemon:2405 1408 Created PID file: /root/pt_kill.pid # VersionCheck:6075 1408 FindBin::Bin: /usr/bin # VersionCheck:6235 1408 SELECT CONCAT(@@hostname, @@port) # VersionCheck:6256 1408 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 1408 Version check file percona-version-check in /tmp # VersionCheck:6170 1408 Version check file /tmp/percona-version-check contents: 0,1433025813 # 1fd50191122cdde284e2635a978b836e,1433025813 # VersionCheck:6178 1408 Intsance 1fd50191122cdde284e2635a978b836e last checked 1433025813 now 1433048740 diff 22927 hours until next check 17.63 # VersionCheck:6178 1408 Intsance 0 last checked 1433025813 now 1433048740 diff 22927 hours until next check 17.63 # VersionCheck:6098 1408 0 instances to check # pt_kill:7225 1408 /usr/bin/pt-kill starting # pt_kill:7225 1408 Connected to host tslls.net # pt_kill:7225 1408 Find spec: $VAR1 = { # all => undef, # busy_time => '30', # idle_time => undef, # ignore => { # Command => undef, # Host => undef, # Id => 6, # 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 1408 Run-time: forever at 15 second intervals # pt_kill:7225 1408 Checking processlist # Retry:5068 1408 Try 1 of 1200 # Retry:5085 1408 Try code succeeded # pt_kill:7247 1408 Grouping queries by undef # pt_kill:7062 1408 Finding matching queries in class default # Processlist:3468 1408 find specs: $VAR1 = { # all => undef, # busy_time => '30', # idle_time => undef, # ignore => { # Command => undef, # Host => undef, # Id => 6, # 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 1408 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '6', # Info => 'SHOW FULL PROCESSLIST', # Rows_examined => '0', # Rows_sent => '0', # State => 'init', # Time => '0', # User => 'root', # db => undef # }; # # MasterSlave:4339 1408 Not system user # MasterSlave:4356 1408 Matches all replication thread: no ; match: 0 # Processlist:3486 1408 Query isn't running long enough # pt_kill:7065 1408 0 queries in class default # pt_kill:7225 1408 Matched 0 queries # pt_kill:7225 1408 Sleeping 15 seconds after normal interval # pt_kill:7225 1408 Checking processlist # Retry:5068 1408 Try 1 of 1200 # Retry:5085 1408 Try code succeeded # pt_kill:7247 1408 Grouping queries by undef # pt_kill:7062 1408 Finding matching queries in class default # Processlist:3468 1408 find specs: $VAR1 = { # all => undef, # busy_time => '30', # idle_time => undef, # ignore => { # Command => undef, # Host => undef, # Id => 6, # 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 1408 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '6', # Info => 'SHOW FULL PROCESSLIST', # Rows_examined => '0', # Rows_sent => '0', # State => 'init', # Time => '0', # User => 'root', # db => undef # }; # # MasterSlave:4339 1408 Not system user # MasterSlave:4356 1408 Matches all replication thread: no ; match: 0 # Processlist:3486 1408 Query isn't running long enough # Processlist:3474 1408 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '7', # Info => 'SELECT @@server_id, SLEEP(65) /* First Query */', # Rows_examined => '0', # Rows_sent => '0', # State => 'User sleep', # Time => '3', # User => 'root', # db => undef # }; # # MasterSlave:4339 1408 Not system user # MasterSlave:4356 1408 Matches all replication thread: no ; match: 0 # Processlist:3486 1408 Query isn't running long enough # pt_kill:7065 1408 0 queries in class default # pt_kill:7225 1408 Matched 0 queries # pt_kill:7225 1408 Sleeping 15 seconds after normal interval # pt_kill:7225 1408 Checking processlist # Retry:5068 1408 Try 1 of 1200 # Retry:5085 1408 Try code succeeded # pt_kill:7247 1408 Grouping queries by undef # pt_kill:7062 1408 Finding matching queries in class default # Processlist:3468 1408 find specs: $VAR1 = { # all => undef, # busy_time => '30', # idle_time => undef, # ignore => { # Command => undef, # Host => undef, # Id => 6, # 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 1408 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '6', # Info => 'SHOW FULL PROCESSLIST', # Rows_examined => '0', # Rows_sent => '0', # State => 'init', # Time => '0', # User => 'root', # db => undef # }; # # MasterSlave:4339 1408 Not system user # MasterSlave:4356 1408 Matches all replication thread: no ; match: 0 # Processlist:3486 1408 Query isn't running long enough # Processlist:3474 1408 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '7', # Info => 'SELECT @@server_id, SLEEP(65) /* First Query */', # Rows_examined => '0', # Rows_sent => '0', # State => 'User sleep', # Time => '18', # User => 'root', # db => undef # }; # # MasterSlave:4339 1408 Not system user # MasterSlave:4356 1408 Matches all replication thread: no ; match: 0 # Processlist:3486 1408 Query isn't running long enough # pt_kill:7065 1408 0 queries in class default # pt_kill:7225 1408 Matched 0 queries # pt_kill:7225 1408 Sleeping 15 seconds after normal interval # pt_kill:7225 1408 Checking processlist # Retry:5068 1408 Try 1 of 1200 # Retry:5085 1408 Try code succeeded # pt_kill:7247 1408 Grouping queries by undef # pt_kill:7062 1408 Finding matching queries in class default # Processlist:3468 1408 find specs: $VAR1 = { # all => undef, # busy_time => '30', # idle_time => undef, # ignore => { # Command => undef, # Host => undef, # Id => 6, # 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 1408 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '6', # Info => 'SHOW FULL PROCESSLIST', # Rows_examined => '0', # Rows_sent => '0', # State => 'init', # Time => '0', # User => 'root', # db => undef # }; # # MasterSlave:4339 1408 Not system user # MasterSlave:4356 1408 Matches all replication thread: no ; match: 0 # Processlist:3486 1408 Query isn't running long enough # Processlist:3474 1408 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '7', # Info => 'SELECT @@server_id, SLEEP(65) /* First Query */', # Rows_examined => '0', # Rows_sent => '0', # State => 'User sleep', # Time => '33', # User => 'root', # db => undef # }; # # MasterSlave:4339 1408 Not system user # MasterSlave:4356 1408 Matches all replication thread: no ; match: 0 # Processlist:3490 1408 Exceeds busy time # Processlist:3521 1408 Query matches Info spec # Processlist:3527 1408 Query matched one or more specs, adding # pt_kill:7065 1408 1 queries in class default # pt_kill:7122 1408 1 queries to kill in class default # pt_kill:7225 1408 Matched 1 queries # pt_kill:7204 1408 exec cmd: (date >> /root/execute.log) # pt_kill:7210 1408 child pid: 1415 # pt_kill:7225 1408 Executed (date >> /root/execute.log) # pt_kill:6802 1408 Killing process 7 # Retry:5068 1408 Try 1 of 2 # Retry:5085 1408 Try code succeeded # pt_kill:7225 1408 Killed 7 # pt_kill:7225 1408 Sleeping 15 seconds after normal interval # pt_kill:7218 1415 child exit status: 72057594037927935 # Cxn:5324 1415 Destroying cxn # Cxn:5333 1415 DBI::db=HASH(0x160f2d0) Disconnecting dbh on tslls.net h=localhost # pt_kill:7225 1408 Checking processlist # Retry:5068 1408 Try 1 of 1200 # Retry:5074 1408 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 1408 DBI:mysql:;host=localhost;mysql_read_default_group=client # DSNParser:2057 1408 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 1408 DBI::db=HASH(0x1ce8ff8) SELECT @@SQL_MODE # DSNParser:2216 1408 DBI::db=HASH(0x1ce8ff8) SET SESSION wait_timeout=10000 # DSNParser:2116 1408 DBI::db=HASH(0x1ce8ff8) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION'*/ # DSNParser:2125 1408 DBH info: DBI::db=HASH(0x1ce8ff8) $VAR1 = { # '@@hostname' => 'tslls.net', # 'CONNECTION_ID()' => '9', # '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 1408 DBI::db=HASH(0x1ce8ff8) Setting dbh # Cxn:5215 1408 DBI::db=HASH(0x1ce8ff8) SELECT @@server_id /*!50038 , @@hostname*/ # Cxn:5217 1408 DBI::db=HASH(0x1ce8ff8) hostname: tslls.net 0 # Cxn:5198 1408 DBI::db=HASH(0x1ce8ff8) Connected dbh to tslls.net h=localhost # pt_kill:7225 1408 Reconnected to tslls.net # Retry:5080 1408 Calling wait code # Retry:5068 1408 Try 2 of 1200 # Retry:5085 1408 Try code succeeded # pt_kill:7247 1408 Grouping queries by undef # pt_kill:7062 1408 Finding matching queries in class default # Processlist:3468 1408 find specs: $VAR1 = { # all => undef, # busy_time => '30', # idle_time => undef, # ignore => { # Command => undef, # Host => undef, # Id => 6, # 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 1408 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '8', # Info => 'SELECT @@server_id, SLEEP(65) /* Second Query */', # Rows_examined => '0', # Rows_sent => '0', # State => 'User sleep', # Time => '10', # User => 'root', # db => undef # }; # # MasterSlave:4339 1408 Not system user # MasterSlave:4356 1408 Matches all replication thread: no ; match: 0 # Processlist:3486 1408 Query isn't running long enough # Processlist:3474 1408 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '9', # Info => 'SHOW FULL PROCESSLIST', # Rows_examined => '0', # Rows_sent => '0', # State => 'init', # Time => '0', # User => 'root', # db => undef # }; # # MasterSlave:4339 1408 Not system user # MasterSlave:4356 1408 Matches all replication thread: no ; match: 0 # Processlist:3486 1408 Query isn't running long enough # pt_kill:7065 1408 0 queries in class default # pt_kill:7225 1408 Matched 0 queries # pt_kill:7225 1408 Sleeping 15 seconds after normal interval # pt_kill:7225 1408 Checking processlist # Retry:5068 1408 Try 1 of 1200 # Retry:5085 1408 Try code succeeded # pt_kill:7247 1408 Grouping queries by undef # pt_kill:7062 1408 Finding matching queries in class default # Processlist:3468 1408 find specs: $VAR1 = { # all => undef, # busy_time => '30', # idle_time => undef, # ignore => { # Command => undef, # Host => undef, # Id => 6, # 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 1408 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '8', # Info => 'SELECT @@server_id, SLEEP(65) /* Second Query */', # Rows_examined => '0', # Rows_sent => '0', # State => 'User sleep', # Time => '25', # User => 'root', # db => undef # }; # # MasterSlave:4339 1408 Not system user # MasterSlave:4356 1408 Matches all replication thread: no ; match: 0 # Processlist:3486 1408 Query isn't running long enough # Processlist:3474 1408 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '9', # Info => 'SHOW FULL PROCESSLIST', # Rows_examined => '0', # Rows_sent => '0', # State => 'init', # Time => '0', # User => 'root', # db => undef # }; # # MasterSlave:4339 1408 Not system user # MasterSlave:4356 1408 Matches all replication thread: no ; match: 0 # Processlist:3486 1408 Query isn't running long enough # pt_kill:7065 1408 0 queries in class default # pt_kill:7225 1408 Matched 0 queries # pt_kill:7225 1408 Sleeping 15 seconds after normal interval # pt_kill:7225 1408 Checking processlist # Retry:5068 1408 Try 1 of 1200 # Retry:5085 1408 Try code succeeded # pt_kill:7247 1408 Grouping queries by undef # pt_kill:7062 1408 Finding matching queries in class default # Processlist:3468 1408 find specs: $VAR1 = { # all => undef, # busy_time => '30', # idle_time => undef, # ignore => { # Command => undef, # Host => undef, # Id => 6, # 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 1408 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '8', # Info => 'SELECT @@server_id, SLEEP(65) /* Second Query */', # Rows_examined => '0', # Rows_sent => '0', # State => 'User sleep', # Time => '40', # User => 'root', # db => undef # }; # # MasterSlave:4339 1408 Not system user # MasterSlave:4356 1408 Matches all replication thread: no ; match: 0 # Processlist:3490 1408 Exceeds busy time # Processlist:3521 1408 Query matches Info spec # Processlist:3527 1408 Query matched one or more specs, adding # Processlist:3474 1408 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '9', # Info => 'SHOW FULL PROCESSLIST', # Rows_examined => '0', # Rows_sent => '0', # State => 'init', # Time => '0', # User => 'root', # db => undef # }; # # MasterSlave:4339 1408 Not system user # MasterSlave:4356 1408 Matches all replication thread: no ; match: 0 # Processlist:3486 1408 Query isn't running long enough # pt_kill:7065 1408 1 queries in class default # pt_kill:7122 1408 1 queries to kill in class default # pt_kill:7225 1408 Matched 1 queries # pt_kill:7204 1408 exec cmd: (date >> /root/execute.log) # pt_kill:7210 1408 child pid: 1422 # pt_kill:7225 1408 Executed (date >> /root/execute.log) # pt_kill:6802 1408 Killing process 8 # Retry:5068 1408 Try 1 of 2 # Retry:5074 1408 Try code failed: DBD::mysql::st execute failed: MySQL server has gone away [for Statement "KILL ?" with ParamValues: 0=8] at /usr/bin/pt-kill line 6806. # # Cxn:5206 1408 DBI::db=HASH(0x1ce8ff8) Already set dbh # Cxn:5198 1408 DBI::db=HASH(0x1ce8ff8) Connected dbh to tslls.net h=localhost # pt_kill:7225 1408 Reconnected to tslls.net # Retry:5080 1408 Calling wait code # pt_kill:7218 1422 child exit status: 72057594037927935 # Cxn:5324 1422 Destroying cxn # Cxn:5333 1422 DBI::db=HASH(0x1ce8ff8) Disconnecting dbh on tslls.net h=localhost # Retry:5068 1408 Try 2 of 2 # Retry:5074 1408 Try code failed: DBD::mysql::st execute failed: MySQL server has gone away [for Statement "KILL ?" with ParamValues: 0=8] at /usr/bin/pt-kill line 6806. # # Retry:5090 1408 Try code did not succeed # pt_kill:7225 1408 Error killing 8: DBD::mysql::st execute failed: MySQL server has gone away [for Statement "KILL ?" with ParamValues: 0=8] at /usr/bin/pt-kill line 6806. # # pt_kill:7225 1408 Sleeping 15 seconds after normal interval # pt_kill:7225 1408 Checking processlist # Retry:5068 1408 Try 1 of 1200 # Retry:5074 1408 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 1408 DBI:mysql:;host=localhost;mysql_read_default_group=client # DSNParser:2057 1408 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 1408 DBI::db=HASH(0x1aa3bb0) SELECT @@SQL_MODE # DSNParser:2216 1408 DBI::db=HASH(0x1aa3bb0) SET SESSION wait_timeout=10000 # DSNParser:2116 1408 DBI::db=HASH(0x1aa3bb0) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION'*/ # DSNParser:2125 1408 DBH info: DBI::db=HASH(0x1aa3bb0) $VAR1 = { # '@@hostname' => 'tslls.net', # 'CONNECTION_ID()' => '10', # '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 1408 DBI::db=HASH(0x1aa3bb0) Setting dbh # Cxn:5215 1408 DBI::db=HASH(0x1aa3bb0) SELECT @@server_id /*!50038 , @@hostname*/ # Cxn:5217 1408 DBI::db=HASH(0x1aa3bb0) hostname: tslls.net 0 # Cxn:5198 1408 DBI::db=HASH(0x1aa3bb0) Connected dbh to tslls.net h=localhost # pt_kill:7225 1408 Reconnected to tslls.net # Retry:5080 1408 Calling wait code # Retry:5068 1408 Try 2 of 1200 # Retry:5085 1408 Try code succeeded # pt_kill:7247 1408 Grouping queries by undef # pt_kill:7062 1408 Finding matching queries in class default # Processlist:3468 1408 find specs: $VAR1 = { # all => undef, # busy_time => '30', # idle_time => undef, # ignore => { # Command => undef, # Host => undef, # Id => 6, # 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 1408 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '8', # Info => 'SELECT @@server_id, SLEEP(65) /* Second Query */', # Rows_examined => '0', # Rows_sent => '0', # State => 'User sleep', # Time => '59', # User => 'root', # db => undef # }; # # MasterSlave:4339 1408 Not system user # MasterSlave:4356 1408 Matches all replication thread: no ; match: 0 # Processlist:3490 1408 Exceeds busy time # Processlist:3521 1408 Query matches Info spec # Processlist:3527 1408 Query matched one or more specs, adding # Processlist:3474 1408 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '10', # Info => 'SHOW FULL PROCESSLIST', # Rows_examined => '0', # Rows_sent => '0', # State => 'init', # Time => '0', # User => 'root', # db => undef # }; # # MasterSlave:4339 1408 Not system user # MasterSlave:4356 1408 Matches all replication thread: no ; match: 0 # Processlist:3486 1408 Query isn't running long enough # pt_kill:7065 1408 1 queries in class default # pt_kill:7122 1408 1 queries to kill in class default # pt_kill:7225 1408 Matched 1 queries # pt_kill:7204 1408 exec cmd: (date >> /root/execute.log) # pt_kill:7210 1408 child pid: 1425 # pt_kill:7225 1408 Executed (date >> /root/execute.log) # pt_kill:6802 1408 Killing process 8 # Retry:5068 1408 Try 1 of 2 # Retry:5074 1408 Try code failed: DBD::mysql::st execute failed: MySQL server has gone away [for Statement "KILL ?" with ParamValues: 0=8] at /usr/bin/pt-kill line 6806. # # Cxn:5206 1408 DBI::db=HASH(0x1aa3bb0) Already set dbh # Cxn:5198 1408 DBI::db=HASH(0x1aa3bb0) Connected dbh to tslls.net h=localhost # pt_kill:7225 1408 Reconnected to tslls.net # Retry:5080 1408 Calling wait code # pt_kill:7218 1425 child exit status: 72057594037927935 # Cxn:5324 1425 Destroying cxn # Cxn:5333 1425 DBI::db=HASH(0x1aa3bb0) Disconnecting dbh on tslls.net h=localhost # Retry:5068 1408 Try 2 of 2 # Retry:5074 1408 Try code failed: DBD::mysql::st execute failed: MySQL server has gone away [for Statement "KILL ?" with ParamValues: 0=8] at /usr/bin/pt-kill line 6806. # # Retry:5090 1408 Try code did not succeed # pt_kill:7225 1408 Error killing 8: DBD::mysql::st execute failed: MySQL server has gone away [for Statement "KILL ?" with ParamValues: 0=8] at /usr/bin/pt-kill line 6806. # # pt_kill:7225 1408 Sleeping 15 seconds after normal interval # pt_kill:7225 1408 Checking processlist # Retry:5068 1408 Try 1 of 1200 # Retry:5074 1408 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 1408 DBI:mysql:;host=localhost;mysql_read_default_group=client # DSNParser:2057 1408 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 1408 DBI::db=HASH(0x1cf3d60) SELECT @@SQL_MODE # DSNParser:2216 1408 DBI::db=HASH(0x1cf3d60) SET SESSION wait_timeout=10000 # DSNParser:2116 1408 DBI::db=HASH(0x1cf3d60) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION'*/ # DSNParser:2125 1408 DBH info: DBI::db=HASH(0x1cf3d60) $VAR1 = { # '@@hostname' => 'tslls.net', # 'CONNECTION_ID()' => '11', # '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 1408 DBI::db=HASH(0x1cf3d60) Setting dbh # Cxn:5215 1408 DBI::db=HASH(0x1cf3d60) SELECT @@server_id /*!50038 , @@hostname*/ # Cxn:5217 1408 DBI::db=HASH(0x1cf3d60) hostname: tslls.net 0 # Cxn:5198 1408 DBI::db=HASH(0x1cf3d60) Connected dbh to tslls.net h=localhost # pt_kill:7225 1408 Reconnected to tslls.net # Retry:5080 1408 Calling wait code # Retry:5068 1408 Try 2 of 1200 # Retry:5085 1408 Try code succeeded # pt_kill:7247 1408 Grouping queries by undef # pt_kill:7062 1408 Finding matching queries in class default # Processlist:3468 1408 find specs: $VAR1 = { # all => undef, # busy_time => '30', # idle_time => undef, # ignore => { # Command => undef, # Host => undef, # Id => 6, # 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 1408 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '11', # Info => 'SHOW FULL PROCESSLIST', # Rows_examined => '0', # Rows_sent => '0', # State => 'init', # Time => '0', # User => 'root', # db => undef # }; # # MasterSlave:4339 1408 Not system user # MasterSlave:4356 1408 Matches all replication thread: no ; match: 0 # Processlist:3486 1408 Query isn't running long enough # pt_kill:7065 1408 0 queries in class default # pt_kill:7225 1408 Matched 0 queries # pt_kill:7225 1408 Sleeping 15 seconds after normal interval # pt_kill:7225 1408 Checking processlist # Retry:5068 1408 Try 1 of 1200 # Retry:5085 1408 Try code succeeded # pt_kill:7247 1408 Grouping queries by undef # pt_kill:7062 1408 Finding matching queries in class default # Processlist:3468 1408 find specs: $VAR1 = { # all => undef, # busy_time => '30', # idle_time => undef, # ignore => { # Command => undef, # Host => undef, # Id => 6, # 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 1408 Checking query $VAR1 = { # Command => 'Query', # Host => 'localhost', # Id => '11', # Info => 'SHOW FULL PROCESSLIST', # Rows_examined => '0', # Rows_sent => '0', # State => 'init', # Time => '0', # User => 'root', # db => undef # }; # # MasterSlave:4339 1408 Not system user # MasterSlave:4356 1408 Matches all replication thread: no ; match: 0 # Processlist:3486 1408 Query isn't running long enough # pt_kill:7065 1408 0 queries in class default # pt_kill:7225 1408 Matched 0 queries # pt_kill:7225 1408 Sleeping 15 seconds after normal interval # pt_kill:7225 1408 Sentinel file /tmp/pt-kill-sentinel exists # pt_kill:7225 1408 /usr/bin/pt-kill ending # Daemon:2414 1408 Removed PID file # Cxn:5324 1408 Destroying cxn # Cxn:5333 1408 DBI::db=HASH(0x1cf3d60) Disconnecting dbh on tslls.net h=localhost