Error starting query-history-all-5.1, check /var/lib/pt-agent/logs/start-stop.log and /var/lib/pt-agent/logs/query-history-all-5.1.run
I’m getting this as my status on both of the servers that I have set up.
There is nothing in the .log file and the .run file just has a timestamp from it first tried to run, which was over an hour ago. I’ve confirmed that the user the agent/my.cnf file has permission to access mysql. The only command from /var/lib/pt-agent/services/start-query-history-all-5.1 that couldn’t be run was SET GLOBAL slow_query_log_use_global_control=‘all’
ERROR 1193 (HY000): Unknown system variable ‘slow_query_log_use_global_control’
I’m running Server version: 5.1.61-rel13.2-log (Percona Server (GPL), 13.2, Revision 431) on both servers.