6x1bmq
Last Updated: November 21, 2018
·
9.993K
· 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

31020

Hi Craig,

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

3 months ago ·
31292

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

about 2 months ago ·