rds_kill_query in MySQL RDS

Use the mysql_rds_kill_query procedure with the query’s ID to terminate any queries that are currently being processed by the MySQL server.

You can query the MySQL INFORMATION_SCHEMA PROCESSLIST table to get the query ID. However, note that the server connection to MySQL is retained.

CALL mysql.rds_kill_query(queryID);

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s