百度智能云

All Product Document

          Relational Database Service

          Session Diagnosis

          Overview

          View and analyze the real-time session information and quickly locate lock wait, slow SQL, or other performance problems in the instance. Analyze the session statistics from multiple perspectives such as user, database, status, and source, and quickly locate exceptional sessions.

          Interpretation of Terms

          Real-time session: shows the processlist session information in real time and allows you to view the current session but not to perform any operation. Session statistics: allows you to accomplish the statistics from four perspectives, including user, access source, database, and session status.

          Operation Guide

          1. Log in to the Console of Baidu AI Cloud Database RDS.
          2. In the RDS console, select a MySQL dual-computer high-availability master instance, and click the instance name to enter the Instance Details.
          3. On the "Baidu AI Cloud Database RDS Instance Details" page, click SmartDBA to show the module information.
          4. Click Session Diagnosis and select "Real-time Session" or "Session Statistics" in the diagnosis type to view the relevant information.

          Real-time Session

          image.png

          Session Statistics

          image.png

          Previous
          Performance Diagnosis
          Next
          Space Diagnosis