ApsaraDB RDS:Performance optimization and diagnosis

Features

The autonomy service for RDS MySQL includes the following features:

• Quick diagnostics

  Diagnose your instance and view visualized diagnostic results.

• Autonomy center

  View anomalies, optimization events, auto scaling events, and other events that occurred within a specified time range.

• Session management

  View, export, and terminate sessions on an instance. You can also perform 10-second SQL analysis, SQL throttling, and optimization.

• Real-time performance

  View real-time performance trends and metric data for your database instance.

• Lock analysis

  View and analyze the most recent deadlock in the database.

• Capacity assessment

  View capacity assessment suggestions, performance capacity status, storage capacity usage, and remaining storage days. This feature also uses machine learning and capacity algorithms to predict future storage usage.

• Storage analysis

  View the storage overview, remaining storage days, table-level storage usage, storage fragmentation, and storage anomaly diagnoses for your database instance. This helps you promptly detect storage anomalies and ensure database stability.

• Parameter diagnostics

  Diagnose the parameters of your database instance and view static parameter diagnostic results and the parameter modification history from the last seven days.

• Performance Insight (New Version)

  Uses the Performance Schema of MySQL to collect SQL information, assess database load, identify the root causes of performance issues, and provide governance solutions to ensure database stability.

• Performance Insight (Old Version)

  Monitors and analyzes database load to help you quickly assess performance, identify the root causes of issues, and ensure database stability.

• Performance Trend

  Provides a wide range of performance monitoring metrics with custom chart support. Automatically detects and diagnoses events on your database instance, delivering root cause analysis and suggestions. You can also manually run diagnostics for a specific time range.

• Slow Log Analysis

  View slow SQL statement trends, execution details, and optimization suggestions.

• Query Governance

  Analyzes and automatically tags all slow SQL statements generated on all instances from the previous day using offline data analysis. This process runs at 01:00 every day, helping you classify and prioritize slow SQL statements for governance. It also provides governance suggestions and data exporting.

• SQL Explorer and Audit

  Combines full request logging, security auditing, SQL Explorer, traffic playback, and stress testing. Helps you retrieve detailed SQL statement information, troubleshoot performance issues, identify high-risk sources, and validate instance types.

• Diagnostic reports

  Automatically or manually diagnose instances to view instance health status, alerts, and slow SQL statements.

• Inspection and Scoring

  Performs scheduled daily inspections and scoring for all database instances. You can also select specific instances and inspection periods to manually trigger scoring.

• Monitoring dashboard

  Select the database instances and metrics to monitor, compare metrics across instances, and use filter interaction for multiple metrics.

• Event subscription

  Notifies you of triggered events based on your subscription settings.

• Automatic SQL optimization

  Automatically diagnoses and optimizes SQL statements and creates indexes. When slow SQL statements occur, they are promptly diagnosed and optimized to keep your database running in an optimal state.

• Automatic SQL throttling

  Set trigger conditions for automatic SQL throttling. When the conditions are met, throttling is automatically triggered to control database requests and concurrent SQL statements, ensuring service availability.

• Automatic space expansion

  Monitors the storage of your database instance and automatically expands capacity when storage is insufficient, ensuring uninterrupted business operations.

• Automatic scaling for performance optimization

  Quickly scales your database instance to handle traffic peaks, ensuring business stability. Also monitors average CPU utilization in real time and supports automatic scale-in when utilization decreases over a specified period.

• Automatic fragment reclamation

  Automatically optimizes storage space. After you enable this feature, the primary instance runs the OPTIMIZE TABLE or ALTER TABLE command to reclaim tablespace fragments and organize physical space.

• Prediction-based auto scaling

  Predicts performance metric values for the next 24 hours based on historical data from the last 10 days.

• Scheduled auto scaling

  Scales out the instance type of your database instance at a scheduled time based on a preset policy. The instance automatically reverts to its original instance type after the scale-out duration ends, helping you manage predictable, periodic changes in database load while controlling costs.

Authorization

To use DAS features, you must grant the required permissions to Resource Access Management (RAM) users.

• You can grant permissions to RAM users by attaching a system policy. For more information, see Manage RAM user permissions.

  The system policies for DAS are as follows:

  • AliyunHDMFullAccess: Grants the RAM user full permissions to manage DAS.

  • AliyunHDMReadOnlyAccess: Grants the RAM user read-only permissions on DAS.

  • AliyunHDMReadOnlyWithSQLLogArchiveAccess: Grants the RAM user read-only permissions on DAS and permissions to use the Search feature (including data exporting) of SQL Explorer and Audit.

• You can grant permissions to RAM users by creating a custom policy. For more information, see Create a custom policy.

  For example, to grant a RAM user read-only permissions:

  {
             
              "Action": [
                  "hdm:Get*",
                  
                  "hdm:Describe*",
                  
                  "hdm:Query*",
                  
                  "hdm:Support*"
              
              ],
              
                  "Effect": "Allow",
              
                  "Resource": "acs:rds:*:*:*"
          
  }

References

What is Database Autonomy Service (DAS)?