Mysql batch kill locked progress Method

Mysql tutorial> select concat ('Kill ', id,'; ') from information_schema.processlist where user = 'root ';
+ ------------------------ +
| Concat ('Kill ', id ,';')
+ ------------------------ +
| Kill 3101;
| Kill 2946;
+ ------------------------ +
2 rows in set (0.00 sec)

Mysql> select concat ('Kill ', id,'; ') from information_schema.processlist where user = 'root' into outfile'/tmp/a.txt ';
Query OK, 2 rows affected (0.00 sec)

Mysql> source/tmp/a.txt;
Query OK, 0 rows affected (0.00 sec)

Method 2: Go to mysql and find all processlist of information_schema.