Last Updated: February 25, 2016
·
536
· aleemb

MySQL RDS Kill Connections/Queries

Run the following to get output of commands to run

select concat('CALL mysql.rds_kill( ',id,');') from information_schema.processlist where user='USER_NAME' and DB='DB_NAME';

This will generate lines like:

CALL mysql.rds_kill( 640);

run all the commands generated.

@via https://coderwall.com/p/6x1bmq