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…
nJoy