Session Management is a visualized tool that lets you monitor and control connections and session status in ApsaraDB for SelectDB. Use it to view real-time and historical sessions, and terminate abnormal sessions to ensure the efficient, secure, and reliable operation of your databases.
Prerequisites
Before you begin, ensure that you have:
An ApsaraDB for SelectDB instance running version 3.0.7 or later. To create one, see Create an instance
View and stop sessions
Log on to the ApsaraDB for SelectDB console.
In the top navigation bar, select the region where your instance resides.
In the left-side navigation pane, click Instances. On the Instances page, click the instance ID to go to the Instance Details page.
In the left-side navigation pane, click Data Development and Management (Studio) > Session Management.
NoteIf this is your first time using Data Development and Management (Studio), a prompt appears asking you to add your machine's public IP address to the webui_whitelist IP address whitelist. Click OK to proceed.
If this is your first time using Session Management and you are not yet logged on to the WebUI, the WebUI logon page appears. Log on with the admin account. If you have forgotten the admin password, see Reset the password of an account.
On the Session Management page, do the following based on your needs:
View active sessions: Click the Search icon and enter a query ID or SQL statement in the search box to filter sessions.
Terminate active sessions: Select the connection IDs of the sessions you want to terminate, then click Terminate Query in the upper-left corner.
ImportantAfter you click Terminate Query, the terminated queries cannot be recovered.