Comments on: How a set of queries can be killed in MySQL using Percona Toolkit’s pt-kill https://www.percona.com/blog/how-a-set-of-queries-can-be-killed-in-mysql-using-pt-kill/ Fri, 16 Feb 2024 23:15:53 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: gopal https://www.percona.com/blog/how-a-set-of-queries-can-be-killed-in-mysql-using-pt-kill/#comment-10966609 Thu, 16 Jun 2016 11:41:10 +0000 https://www.percona.com/blog/?p=26735#comment-10966609 Hi Arunjith, I just tried to test the tool, but it seems it is not working.
{code:sql}
root@localhost[(none)]>show full processlist;
+—-+——+—————–+——+———+——-+————-+———————–+
| Id | User | Host | db | Command | Time | State | Info |
+—-+——+—————–+——+———+——-+————-+———————–+
| 18 | root | localhost:58651 | NULL | Sleep | 78900 | cleaning up | PLUGIN |
| 25 | root | localhost | NULL | Sleep | 21 | | NULL |
| 26 | root | localhost | NULL | Sleep | 138 | | NULL |
| 27 | root | localhost | NULL | Query | 0 | starting | show full processlist |
+—-+——+—————–+——+———+——-+————-+———————–+
4 rows in set (0.00 sec)
{code}

Howevery pt-kill is not showing any output:

gopal@D252:~/Work/percona-toolkit-2.2.17/bin$ perl pt-kill –busy-time 60 –print -uroot -pchangeme –verbose
# 2016-06-16T13:39:47 pt-kill starting
# 2016-06-16T13:39:47 Connected to host D252
# 2016-06-16T13:39:47 Find spec: $VAR1 = {
all => undef,
busy_time => ’60’,
idle_time => undef,
ignore => {
Command => undef,
Host => undef,
Id => 28,
Info => undef,
State => ‘Locked’,
User => undef,
db => undef
},
match => {
Command => undef,
Host => undef,
Info => undef,
State => undef,
User => undef,
db => undef
},
replication_threads => undef
};

# 2016-06-16T13:39:47 Run-time: forever at 30 second intervals
# 2016-06-16T13:39:47 Checking processlist
# 2016-06-16T13:39:47 Matched 0 queries
# 2016-06-16T13:39:47 Sleeping 30 seconds after normal interval

MySQL Version – 5.7, also tried with 5.1
Percona-toolkit-version – 2.2.17

]]>