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

mysql.rds_kill

Terminates a connection to the MySQL server.

Syntax

Copy
CALL mysql.rds_kill(processID);

Parameters

processID

The identity of the connection thread that will be terminated.

Usage Notes

Each connection to the MySQL server runs in a separate thread. To terminate a connection, use the mysql_rds_kill procedure and pass in the thread ID of that connection. To obtain the thread ID, use the MySQL SHOW PROCESSLIST command.

The mysql.rds_kill 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 connection with a thread ID of 4243:

Copy
call mysql.rds_kill(4243);