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

Fixed WSL sshd: no hostkeys available -- exiting

PowerMTA pmta command

How to fix: mv: failed to preserve ownership