MySQL kills long queries
mysql --login-path=root -e "SELECT CONCAT('kill ', ID, ';') FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'goyuninfo' AND TIME > 50 AND COMMAND = 'Query';" > kill_query.log
mysql --login-path=root -e "SELECT CONCAT('kill ', ID, ';') FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'goyuninfo' AND TIME > 50 AND COMMAND = 'Query';" > kill_query.log
Comments
Post a Comment