Updated on 2023-12-13 GMT+08:00

Real-Time Sessions

The real-time session function allows you to query session snapshots of your instance and can sort out and display only the required snapshots. You can quickly search for slow or active sessions in multiple dimensions like users, host IP addresses, and database names. DAS allows you to kill sessions to restore your instance, securing your database availability.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner, and under Databases, click Data Admin Service.
  4. In the navigation pane, choose Intelligent O&M > Instance List.

    Alternatively, on the Overview page, click Go to Intelligent O&M.

  5. In the upper right corner of the Instance List page, search for instances by engine type, instance name, or instance IP.

    Figure 1 Searching for instances

  6. Locate the box containing your target instance and click Details.
  7. In the upper right corner of the page, click Go to Old Edition.

    Figure 2 Accessing Intelligent O&M of the old version

  8. Choose Sessions > Real-Time Sessions to view session statistics, sessions, and slow sessions.

    Figure 3 Real-time sessions
    In the statistical item list, you can view total sessions, running sessions, and longest running session time of the current instance. You can also view total sessions and active sessions by user, host, or database. In the All Sessions area, you can view session details and perform the following operations:
    • Select the abnormal session you want to end and click Kill for your database to recover.
      Figure 4 Killing a session
    • Toggle on or toggle off Hide System Sessions so that the system automatically filters or displays sessions.
    • Enable Auto Refresh. The task list is automatically refreshed every 30 seconds.
    In the All Sessions area, you can view slow session details and perform the following operations:
    • Set a slow session threshold and click the refresh button to search for the slow sessions that last longer than this threshold.
      Figure 5 Setting a slow session threshold
    • Toggle on or toggle off Hide System Sessions so that the system automatically filters or displays sessions.
    • Enable Auto Refresh. The task list is automatically refreshed every 30 seconds.
    • Select the session you want to end and click Kill for the databases to recover.
      Figure 6 Killing a session