Menu
Amazon Relational Database Service
User Guide (API Version 2014-10-31)

mysql.rds_kill_query

Terminates a query running against the MySQL server.

Syntax

Copy
CALL mysql.rds_kill_query(queryID);

Parameters

queryID

The identity of the query that will be terminated.

Usage Notes

To terminate a query running against the MySQL server, use the mysql_rds_kill_query procedure and pass in the ID of that query. To obtain the query ID, use the MySQL INFORMATION_SCHEMA PROCESSLIST command. The connection to the MySQL server is retained.

The mysql_rds_kill_query procedure is available in these versions of Amazon RDS MySQL:

  • MySQL 5.5

  • MySQL 5.6

  • MySQL 5.7

Related Topics

Examples

The following example terminates a query with a thread ID of 230040:

Copy
call mysql.rds_kill_query(230040);