How to kill multiple MySQL processes in AWS RDS at once?

To Nha Notes | March 12, 2021, 4:01 p.m.

To kill a MySQL process in AWS RDS, call procedure from MySQL client console:

CALL mysql.rds_kill(processID);

To kill sleep connections, we can generage list of above kill commands based on below SQL:

SELECT CONCAT('CALL mysql.rds_kill ( ',id,')',';') FROM INFORMATION_SCHEMA.PROCESSLIST WHERE COMMAND='Sleep' AND TIME > 10 ;

The output look like below:

+---------------------------------------------+
| CONCAT('CALL mysql.rds_kill ( ',id,')',';') |
+---------------------------------------------+
| CALL mysql.rds_kill ( 5740758); |
| CALL mysql.rds_kill ( 5740802); |
| CALL mysql.rds_kill ( 5740745); |
| CALL mysql.rds_kill ( 5740612); |
| CALL mysql.rds_kill ( 5740587); |
| CALL mysql.rds_kill ( 5740660); |
+---------------------------------------------+
6 rows in set (0.02 sec)

Then, just copy above list of generated kill commands into MySQL client console to kill all of them at once.