This topic describes the diagnosis feature provided by PolarDB for MySQL. The diagnosis feature integrates with Database Autonomy Service (DAS) and allows you to use the session management feature to view the session statistics of a target instance.

Procedure

  1. Log on to the PolarDB console.
  2. In the upper-left corner of the console, select the region where the cluster that you want to manage is deployed.
  3. On the Clusters page, click the ID of the target cluster.
  4. In the left-side navigation pane, choose Diagnostics and Optimization > Diagnosis.
  5. Click the Session Management tab.
    Session Management
  6. On the Session Management page, you can view the Instance Sessions and Session Statistics sections.
    • Instance Sessions: provides information about exceptional sessions, active sessions, and CPU usage.Instance Sessions
      Note
      • In the upper-right corner of the Diagnosis page, you can click 10s SQL Analysis to view the most frequently executed SQL statements and slow queries within 10 seconds. For more information, see 10-Second SQL Analysis.
      • You can click SQL Throttling to control the number of database requests and the number of SQL concurrent requests to ensure the availability of services. For more information, see SQL Throttling .
      • You can click Optimize to diagnose and optimize SQL statements. For more information, see SQL optimization.
    • Session Statistics: provides the total number of sessions, session runtime, and other session statistics collected based on different metrics. For example, the system calculates the number of sessions initiated by different users.Instance sessions