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 aleemb
Related protips
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#