:How do I terminate sessions on an ApsaraDB RDS for MySQL instance?

Overview

This topic describes how to terminate sessions on an ApsaraDB RDS for MySQL instance.

Procedure

You can terminate sessions on an RDS instance by using one of the following methods:

• Use Data Management (DMS).

• Use the kill command.

Use DMS to terminate sessions on an RDS instance

1. Log on to the RDS instance. For more information, see Use DMS to log on to an ApsaraDB RDS for MySQL instance.

2. Right-click the instance ID and choose Performance > Instance session.

3. In the dialog box that appears, select the new version of the DAS console and authorize the user to access DAS. Authorization is required only for the first logon.

4. Click Kill Selected to terminate the session that you select. You can select multiple sessions.

Use the kill command to terminate sessions on an RDS instance

1. Connect to the RDS instance by using the MySQL command-line tool. For more information, see Use a database client or the CLI to connect to an ApsaraDB RDS for MySQL instance.

   Note

   When the number of connections to the RDS instance reaches the upper limit, you cannot connect to the RDS instance by using DMS or the MySQL command-line tool. In this case, we recommend that you set the wait_timeout parameter to a small value (unit: seconds), such as 60, in the ApsaraDB RDS console. If you set this parameter to 60, the RDS instance automatically terminates the connections that are idle for more than 60 seconds. This way, you can connect to the RDS instance by using DMS or the MySQL command-line tool.

2. Execute the following statement to record the ID of the session that you want to terminate:

   show processlist;

   The following figure shows a sample output.

3. Run the following command to terminate the session:

kill [$ID];

The following figure shows a sample output.

Applicable scope

• ApsaraDB RDS for MySQL