kill mysql process which is ideal for N seconds

step 1:

login mysql through putty

step 2:

execute – SELECT GROUP_CONCAT(‘KILL ‘,id,’; ‘ SEPARATOR ‘ ‘) FROM information_schema.processlist WHERE time > 500 AND user<>’system user’;

step 3:

you will get a string as output. copy that string and paste into mysql command prompt and press enter…


Posted in mysql