kill mysql processlist in whose time more than 200

Solutions on MaxInterview for kill mysql processlist in whose time more than 200 by the best coders in the world

showing results for - "kill mysql processlist in whose time more than 200"

María Fernanda

1mysql> select group_concat(concat('KILL ',id,';')) from 
2information_schema.processlist where user='root' and time > 500;
3
4mysql> source /tmp/a.txt;

similar questions

postgres kill running query kill mysqld safe process mariadb mysql kill show all event schedular on mysql myswql show full processlist sql developer kill session psql kill pid bulk kill mysql processlist sql developer kill query mysql event last execution oracle kill session by sql id

queries leading to this page

killmall process list mysql kill mysql all process mysql kill all processes bulk kill mysql processlist kill all mysql processes php kill all query sql kill all process in mysql mysql kill more than one mysql kill multiple querys kill mysql processlist in whose time more than 200 job to kill longer sessions in mysql mysql how to kill all process kill mysql processlist in whose time more than 200