Digital Marketing

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

Comments

Popular posts from this blog

MySQL Sandbox with the Sakila sample database