The diagnosis feature of PolarDB for MySQL integrates with Database Autonomy Service (DAS). This allows you to view database diagnostics and optimization results on multiple tabs. On the Diagnostic Reports tab, you can view and customize the diagnostic reports that are generated based on the specified conditions.

Procedure

  1. Log on to the PolarDB console.
  2. On the top of the page, select the region where the target cluster is located.
  3. In the left-side navigation pane, click Clusters to go to the Clusters page, and click the target cluster ID. The Overview page appears.
  4. In the left-side navigation pane, choose Diagnostics and Optimization > Diagnosis.
  5. Click the Diagnostic Reports tab.
    Diagnostic reports
  6. On the Diagnostic Reports tab, you can generate diagnostic reports by using the following methods:
    • Automatically generate diagnostic reports:
      1. Click Auto-generating Diagnostic Report Settings on the Diagnostic Reports tab.
      2. In the dialog box that appears, select Scheduled Trigger.
      3. Select All or other check boxes to specify one or more dates, and set the time that diagnostic reports are generated.
      4. Click OK.Automatic generation
    • Manually generate diagnostic reports: Click Create Reports to manually generate diagnostic reports.Create reports
  7. Find the completed diagnostic report, and click View Report in the Actions column for the report.
    View a report
  8. In the diagnostic report that appears, you can view the diagnostic results for the instance, including the health status, sessions, deadlocks, and performance trends.
    Instance