PolarDB for MySQL integrates with Database Autonomy Service (DAS) to provide a unified set of diagnostic and optimization tools. Use these tools to detect exceptions early, investigate active sessions and storage health, and identify the root causes of performance issues.
Tools overview
The following table summarizes each tool and its primary purpose.
Tool | What it does |
Automatically detect exceptions, perform root cause analysis, and apply optimization or stop-loss actions | |
Inspect active sessions and connection statistics for an instance | |
Track QPS, TPS, network traffic, and other key metrics for a cluster in real time | |
Review storage health: days of storage remaining, tablespace usage, fragmentation percentage, and anomalies | |
Examine the most recent deadlock and its analysis details | |
Estimate database workload and identify the root cause of performance issues | |
Generate on-demand diagnostic reports with customizable conditions |
Automated tools
The following tools run continuously and act on database exceptions without manual intervention.
Autonomy Center
Enable the autonomy service on the Autonomy Center tab to let DAS handle routine exception management. When an exception occurs, DAS automatically performs root cause analysis, provides optimization or stop-loss suggestions, and runs optimization or stop-loss tasks. Optimization tasks are allowed based on your authorization.
For more information, see Autonomy center.
Manual tools
The following tools give you on-demand visibility into specific aspects of database health.
Session Management
On the Session Management tab, inspect session details and connection statistics for a target instance to understand who is connected and what they are running.
For more information, see Session Management.
Real-time Monitoring
On the Real-time Monitoring tab, track live metrics for a target cluster, including queries per second (QPS), transactions per second (TPS), and network traffic.
For more information, see Real-time Monitoring.
Storage Analysis
On the Storage Analysis tab, review the storage health of a target instance. See how many days of storage remain, examine tablespace usage and fragmentation percentage, and review exception analysis results.
For more information, see Storage analysis.
Deadlock Analysis
On the Deadlock Analysis tab, examine the most recent deadlock and check the analysis details.
For more information, see Deadlock analysis.
Performance Insight
On the Performance Insight tab, estimate the workload on your databases and identify the root cause of performance issues to improve database performance and stability. Two versions are available:
Diagnostic Reports
On the Diagnostic Reports tab, generate diagnostic reports on demand by customizing the time range and other conditions, then review the results in one place.
For more information, see Diagnostic reports.