mysql.rds_kill_query - Amazon Relational Database Service

mysql.rds_kill_query

Ends a query running against the MySQL server.

Syntax

CALL mysql.rds_kill_query(queryID);

Parameters

queryID

The identity of the query to be ended.

Usage notes

To stop 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, query the MySQL INFORMATION_SCHEMA PROCESSLIST table. The connection to the MySQL server is retained.

Examples

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

call mysql.rds_kill_query(230040);