Updated on 2025-01-07 GMT+08:00

Scoring Rules

This section describes inspection scoring rules.

Points are deducted based on scoring rules. You can view scores on the console. For details, see Inspection Score.

Scoring Rules

Table 1 Scoring rules of RDS for MySQL instances

Score Deduction Item

Description

Sub-item

Condition

Score Calculation Rule

Memory usage

Average memory usage per day

Major event

Memory > 90%

min[3 + (Memory - 0.9) × 50, 10]

Warning

80% ≤ Memory ≤ 90%

1 + (Memory usage – 0.8) × 20

CPU usage

Average CPU usage per day

NOTE:

Multi-core CPUs need to be converted to single-core CPUs for calculation.

Major event

CPU usage ≥ 80%

min[3 + (CPU usage - 0.8) × 30, 10]

Warning

70% ≤ CPU usage ≤ 80%

1 + (CPU usage - 0.7) × 20

Space usage

(Average used space/Total space) x 100%

Major event

Space usage > 90%

min[3 + (Space usage - 0.9) × 40, 10]

Warning

70% ≤ Space usage ≤ 90%

1 + (Space usage - 0.7) × 20

Connection usage

Average connections per day/Maximum of connections allowed in a day

Major event

Connection usage > 80%

3

Warning

70% ≤ Connection rate ≤ 80%

1

IOPS usage

(Average IOPS per day/Maximum of IOPS allowed) x 100%

Major event

IOPS usage > 90%

5

Warning

70% < IOPS usage < 90%

3

Active sessions

Active sessions generated in a day

Major event

Active sessions > min(4 × CPU cores + 8, 96)

9

Warning

Active sessions > min(2 × CPU cores + 8, 64)

3

Slow SQL statements

Slow SQL statements executed per day

Major event

slowSqlCount>=500

18+(slowSqlCount-10)/30

Warning

100 ≤ Slow SQL statements < 500

4 + (Slow SQL statements - 100)/30

Optimization

0 < Slow SQL statements < 100

1 + (Slow SQL statements - 10)/30