mysql.rds_kill_query
Terminates a query running against the MySQL server.
Syntax
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:
call mysql.rds_kill_query(230040);