Database Autonomy Service (DAS) provides the inspection and scoring feature for ApsaraDB RDS for MySQL. You can use the feature to inspect and score all RDS instances on a daily basis. DAS allows you to specify RDS instances and inspection periods and manually initiate inspection and scoring. This helps you understand the status of ApsaraDB RDS for MySQL instances.

Prerequisites

DAS provides the inspection and scoring feature only for the following types of RDS instances:
  • MySQL 8.0 on RDS High-availability or Enterprise Edition
  • MySQL 5.7 on RDS High-availability or Enterprise Edition
  • MySQL 5.6 on RDS High-availability Edition
  • MySQL 5.5 on RDS High-availability Edition
Note DAS provides the inspection and scoring feature for ApsaraDB RDS for MySQL from May 20, 2022.

Procedure

  1. Log on to the ApsaraDB RDS console.
  2. In the left-side navigation pane, click Performance Center.
  3. On the Performance Center page, click the Inspection and Scoring tab.
  4. On the Inspection and Scoring tab, perform the following operations based on your business requirements:
    • Enable automatic inspection and scoring

      Perform the following operations the first time that you enable the feature: Click Enable. In the Configure Inspection and Scoring dialog box, configure the Select Engine parameter and click OK.

      Note After you enable this feature, the system scores each connected RDS instance once every day.
    • Manually initiate inspection and scoring
      1. On the Inspection and Scoring tab, click Start Inspection.
      2. In the Select Instances section of the Instance Inspection dialog box, select one or more RDS instances in the Available Instances section and click the Rightwards arrow icon to add the selected instances to the Selected Instances section.
      3. In the Inspection Time section, specify a time range.
        Note The start time of an inspection cannot be later than the current time. The minimum interval between the start time and the end time is 1 hour, and the maximum interval is 24 hours.
      4. Click Confirm. Manual inspections
    • View the inspection and scoring results

      After you enable the inspection and scoring feature, you can search for an RDS instance by name or alias to view the inspection and scoring results within a specific time period.

      • You can click Delete in the Actions column of the required RDS instance to delete the results.
      • You can click Deduction Details in the Actions column of the required RDS instance to view the deduction details in the Deduction Details dialog box.
      • You can click Report in the Actions column of the required RDS instance to view the scoring report details in the Scoring Report dialog box.
      • You can click the ID of the required RDS instance to view the performance trend of the RDS instance on the Performance Trends tab. For more information, see Performance trends.
      • You can click the Export icon icon to download the inspection and scoring results to your computer.

Scoring rules

Deduction item Description Sub-item Condition Deducted point
CPU Utilization (cpuUsage) The average daily CPU utilization. If an RDS instance has multiple CPU cores, the system calculates the CPU utilization of each core and then calculates the average CPU utilization of all cores. Warning 70% ≤ cpuUsage ≤ 80% 1 + (cpuUsage - 0.7) × 20
Critical cpuUsage ≥ 80% min[3 + (cpuUsage - 0.8) × 30,10]
Memory Usage (memUsage) The average daily memory usage. Warning 80% ≤ memUsage ≤ 90% 1 - (memUsage - 0.8) × 20
Critical memUsage > 0.9 min[(memUsage - 0.9) × 50,10]
Space Usage The storage usage is calculated by using the following formula: Storage usage = Average used storage during a day/Total storage × 100% Available days availableDays ≤ 30 15 - availableDays/3
Number of large tables bigTableCount > 0 min(bigTableCount,15)
Connection Usage (connectionRate) The connection usage is calculated by using the following formula: Connection usage = Average number of connections during a day/Maximum number of connections allowed at a point in time × 100% Warning 70% ≤ connectionRate ≤ 80% 1
Critical connectionRate > 80% 3
IOPS Usage (iopsUsage) The IOPS usage is calculated by using the following formula: IOPS usage = Average IOPS during a day/Maximum IOPS allowed × 100% Warning 70% < iopsUsage < 90% 3
Critical iopsUsage > 90% 5
Active Sessions (threadRunning) The number of active sessions generated in a day. Warning threadRunning > min(2 × cpuCores + 8,64) 3
Critical threadRunning > min(4 × cpuCores + 8,96) 9
Slow SQL Statements (slowSqlCount) The number of SQL statements that cause slow queries in a day.
Note You can click the number to view the five slow SQL statements that are most frequently executed.
Detected 0 < slowSqlCount < 100 1 + (slowSqlCount - 10)/30
Warning 100 ≤ slowSqlCount < 500 4 + (slowSqlCount - 100)/30
Critical slowSqlCount ≥ 500 min[18 + (slowSqlCount-50)/30,30)]
SQL security audit (sqlInjectionCount) The number of high-risk SQL statements and the number of SQL injection attacks. High-risk SQL statements riskSqlCount > 0 min(riskSqlCount,5)
SQL injection attacks sqlInjectionCount > 0 Min(sqlInjectionCount,5)
Deadlock Indicates whether a deadlock occurs during a day. Detected Detected 3