Updated on 2023-12-07 GMT+08:00

Scoring Rules

This section describes scoring rules of the inspection scoring function.

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

Average memory usage per day

Major event

Memory > 90%

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

Warning

80% ≤ Memory ≤ 90%

1 + (Memory - 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 usage ≤ 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

0 < Slow SQL statements < 100

1 + (Slow SQL statements - 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