Hello, I have installed the latest version of percona mysql server and percona-toolkit on a redhat 6 server. I would like to use the toolkit pt-kill utility to automatically kill queries that’re running too long but so far am having trouble getting it to do so. I currently have it running with:
perl /usr/bin/pt-kill localhost —daemonize --busy-time 4 --kill --log /tmp/killed --ignore-command .DBWATCHER_IMMUNITY. --execute-command /etc/zabbix/externalscripts/query_kill_notifier.sh
For testing purposes, but just ran a query that was 12 seconds long and pt-kill did not catch it and kill it. Is the order of parameters incorrect or…?