The Diagnosis feature for PolarDB for MySQL integrates several capabilities from DAS, including Autonomy Center, session management, real-time performance, storage analysis, lock analysis, Performance Insight, and diagnostic reports, to simplify database diagnosis and optimization.
Features
-
Autonomy Center: Use Autonomy Center to enable the autonomy service. After the service is enabled, DAS automatically performs root cause analysis when a database anomaly occurs, provides optimization or mitigation recommendations, and automatically runs optimization or mitigation tasks (optimization tasks require your authorization). For more information, see Autonomy Center.
-
Sessions: Use session management to view information such as session details and statistics for a target instance. For more information, see Session Management.
-
Real-time Performance: Use real-time performance to view metrics such as QPS, TPS, and network traffic for a target cluster. For more information, see Real-time Performance.
-
Storage Analysis: Use storage analysis to view a complete overview of storage for a target instance. This includes overall space utilization, the estimated days of available storage remaining, space usage for specific tables, storage fragmentation, and diagnostics for storage-related anomalies. For more information, see Storage Analysis.
-
Deadlock Analytics: Use lock analysis to visually inspect and analyze the most recent deadlock in your database. For more information, see Lock Analysis.
-
Performance Insight: Use Performance Insight to quickly assess your database workload, identify the root cause of performance bottlenecks, and improve overall stability. For more information, see Performance Insight (Old Version) or Performance Insight (New Version).
-
Diagnostic Report: Use the diagnostic reports feature to customize conditions for creating diagnostic reports and view them. For more information, see Diagnostic Reports.