All Products
Search
Document Center

ApsaraDB for SelectDB:Manage sessions

Last Updated:Dec 04, 2024

Session Management is a tool that allows you to manage the connections and status of ApsaraDB for SelectDB databases in a visualized manner. You can use this tool to view real-time and historical sessions and terminate abnormal sessions in your databases. This ensures the efficient, secure, and reliable operation of your databases. This topic describes how to use the Session Management tool of ApsaraDB for SelectDB.

Prerequisites

  • An ApsaraDB for SelectDB instance is created. For more information, see Create an instance.

  • The version of the instance is 3.0.7 or later.

Procedure

  1. Log on to the ApsaraDB for SelectDB console.

  2. In the top navigation bar, select the region in which the instance that you want to manage resides.

  3. In the left-side navigation pane, click Instances. On the Instances page, find the instance and click its ID to go to the Instance Details page.

  4. Click Data Development and Management in the upper-right corner.

    Note

    If you use the tools of Data Development and Management for the first time, a message appears and prompts you to add the public IP address of your machine to the IP address whitelist named webui_whitelist of the instance. Read the message and click OK.

  5. Select Session Management from the drop-down list.

    Note

    If you use Session Management for the first time and have not logged on to the WebUI system, the WebUI logon page appears.

    • You can use the admin account to log on to the WebUI system.

    • If you do not know or forget the password of the admin account, you can reset the password. For more information, see Reset the password of an account.

  6. On the Session Management page, perform the following operations based on your business requirements:

    • View active sessions: In the upper part of the page, click the Search icon and enter the query ID or SQL statement that you want to query in the search box. Then, view the queried active sessions.

    • Terminate active sessions: Select the connection IDs of the sessions that you want to terminate and click Terminate Query in the upper-left corner.

      Important

      After you click Terminate Query, the terminated queries cannot be recovered.

Related API operations

ResetAccountPassword

DescribeSecurityIPList

ModifySecurityIPList

References

Create an instance

Reset the password of an account

Configure an IP address whitelist

SQL reference