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