Updated on 2025-01-17 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.

Scoring rules

Table 1 Scoring rules of TaurusDB instances

Deduction Item

Description

Sub-item

Condition

Calculation Rule

Memory usage

Average memory usage per day

Major event

Memory usage > 90%

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

Warning

80% ≤ Memory usage ≤ 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.

Major event

CPU usage ≥ 80%

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

Warning

70% ≤ CPU usage ≤ 80%

1 + (CPU usage – 0.7) × 20

Connection rate

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

Major event

Connection rate > 80%

3

Warning

70% ≤ Connection rate ≤ 80%

1

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

Slow SQL statements ≥ 500

18 + (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