All Products
Search
Document Center

Database Autonomy Service:Session management

Last Updated:Feb 21, 2024

When performance issues or operation exceptions occur on a database, you can troubleshoot the issues or exceptions based on the session information about the database. The session management feature allows you to view the statistics about sessions between an instance and clients in real time. The statistics include the client information, commands that are run, and connection duration. You can also terminate abnormal sessions based on your business requirements.

Prerequisites

The database instance is connected to Data Autonomy Service (DAS) and is in the Normal Access state.

Limits

For ApsaraDB for Redis instances deployed in the cluster architecture, you cannot obtain the session information that is generated in direct connection mode.

Procedure

  1. Log on to the DAS console.

  2. In the left-side navigation pane, click Instance Monitoring.

  3. On the page that appears, find the database instance that you want to manage and click the instance ID. The instance details page appears.

  4. In the left-side navigation pane, click Instance Sessions.

  5. On the Instance Sessions tab, perform the following operations in the Instance Sessions and Session Statistics sections:

    • Terminate sessions.

    • View summary information and session statistics by access source. The summary information includes the total number of clients and the number of active clients.

    • Export summary information and session statistics by access source.

    Note

    In the Instance Sessions section, you can move the pointer over a parameter name in the corresponding column in the table to view the description of the parameter.

Related API operations

API

Description

GetRedisAllSession

Queries the current sessions of an ApsaraDB for Redis instance.

KillInstanceAllSession

Terminates all sessions of an ApsaraDB for Redis instance.