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.
Written by Craig Heneveld
Related protips
2 Responses
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
·
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Mysql
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#