Comment 4 for bug 1460354

Revision history for this message
Nilnandan Joshi (nilnandan-joshi) wrote :

Verified with 2.2.14.

nilnandan@desktop:~$ pt-show-grants --version
pt-show-grants 2.2.14
nilnandan@desktop:~$

nilnandan@desktop:~$ cat .pt-kill.conf
busy-time=30s
log=/home/nilnandan/pt_kill.log
pid=/home/nilnandan/pt_kill.pid
execute-command=(date >> /home/nilnandan/execute.log)
match-info=^SELECT
kill
print
nilnandan@desktop:~$

nilnandan@desktop:~$ date; mysql --comments -e "SELECT @@server_id, SLEEP(65) /* First Query */;"; date
Mon Jun 1 15:22:02 IST 2015
ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query
Mon Jun 1 15:22:33 IST 2015
nilnandan@desktop:~$

nilnandan@desktop:~$ cat .pt-kill.conf
busy-time=30s
log=/home/nilnandan/pt_kill.log
pid=/home/nilnandan/pt_kill.pid
#execute-command=(date >> /home/nilnandan/execute.log)
match-info=^SELECT
kill
print
nilnandan@desktop:~$ date; mysql --comments -e "SELECT @@server_id, SLEEP(65) /* First Query */;"; date
Mon Jun 1 15:23:45 IST 2015
+-------------+-----------+
| @@server_id | SLEEP(65) |
+-------------+-----------+
| 10000 | 0 |
+-------------+-----------+
Mon Jun 1 15:24:50 IST 2015
nilnandan@desktop:~$
nilnandan@desktop:~$ cat execute.log
Mon Jun 1 15:22:33 IST 2015
Mon Jun 1 15:24:40 IST 2015
nilnandan@desktop:~$