Last Updated: November 21, 2018
·
42.78K
· cheneveld

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.

2 Responses
Add your response

Hi Craig,

should this work on Aurora RDS to kill process via an SQL statement? sorry for the newbie question. thanks

over 1 year ago ·

@crsronald It does, just used it myself now to kill a few thousand processes on my Aurora Master

over 1 year ago ·