The Diagnosis feature for PolarDB for MySQL integrates capabilities from Database Autonomy Service (DAS), letting you customize, create, and view diagnostic reports.
Procedure
- Log on to the PolarDB console.
In the upper-left corner, select the region where the cluster is deployed.
-
On the Clusters page, click the ID of the target cluster.
-
In the left-side navigation pane, choose .
-
Click the Diagnostic Report tab.
-
On the Diagnostic Report page, you can generate a diagnostic report in two ways:
-
Automatically generate reports on a schedule:
-
Click Auto-generating Diagnostic Report Settings next to the instance diagnostic report list.
-
In the dialog box, select the Scheduled Trigger checkbox.
-
Select the days for report generation, for example, by selecting the All checkbox, and set the generation time.
-
Click Confirm, and then click OK to complete the settings. The diagnostic report generation task may be delayed due to scheduling and system load. For example, if you set the generation time to 00:00, the report might not be generated until 00:10.
-
-
Manually generate a diagnostic report: You can click Create Reports to generate an on-demand diagnostic report. To do this, go to the instance diagnostic report list page and click Create Reports on the left.
-
-
In the instance diagnostic report list, find a completed report and click View Report in the Actions column.
-
The report details page shows the instance's health status, sessions, deadlock, and performance trends.
The top of the page displays a diagnostic score. The Instance Information section shows the instance ID, source, database engine, and database name. The Node Information table lists the role, specifications, and maximum connections for each node. In the left-side navigation pane, you can also access other sections, such as slow SQL, tablespace, and Download.