How to kill RDS Mysql sessions or queries

Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud

This article exaplains the commands to terminate RDS Mysql sessions or queries.

Step1: Login to RDS MySQL DB

Step2: Run the following command to see the full process list.

SHOW FULL PROCESSLIST \G;

Step3: Note down the id of the thread that we need to terminate.

Step4: Kill the session using the following command.

CALL mysql.rds_kill(thread-ID)

Here we have to replace 'thread-ID' with the required id.

That's all…

Leave a Reply

Your email address will not be published. Required fields are marked *