Mass Killing MySQL Connection
// how to mass kill all mysql connection
SELECT concat('KILL ',id,';') FROM information_schema.processlist WHERE user='root';
SELECT concat('KILL ',id,';') FROM information_schema.processlist WHERE user='root' INTO OUTFILE '/tmp/a.txt';
source /tmp/a.txt;
0 Comments