Scoring rules

Item

Description

Sub-item

Condition

Deducted points

CPU Utilization (cpuUsage)

The average CPU utilization during a day. If an instance has multiple CPU cores, the system calculates the CPU utilization of each core and then calculates the average CPU utilization of all cores.

Major

70%<=cpuUsage<=80%

1 + (cpuUsage - 0.7) × 20

Critical

cpuUsage>=80%

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

Memory Usage (memUsage)

The average memory usage during a day.

Major

80%<=memUsage<=90%

1 + (memUsage - 0.8) × 20

Critical

memUsage>90%

min[(memUsage - 0.9) × 50, 10]

Space Usage (Space Usage)

The storage usage is calculated based on 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 based on the following formula: Connection usage = Average number of connections during a day/Maximum number of connections allowed at a point in time × 100%

Major

70%<=connectionRate<=80%

1

Critical

connectionRate>80%

3

IOPS Usage (iopsUsage)

The IOPS usage is calculated based on the following formula: IOPS usage = Average IOPS during a day/Maximum IOPS allowed × 100%

Major

70%<iopsUsage<90%

3

Critical

iopsUsage>90%

5

Active Sessions (threadRunning)

The number of active sessions generated in one day.

Major

threadRunning>min(2 × cpuCores + 8,64)

3

Critical

threadRunning>min(4 × cpuCores + 8,96)

9

Slow SQL Statements (slowSqlCount)

The number of slow SQL statements generated in one day.

Minor

0<slowSqlCount<100

1 + (slowSqlCount - 10)/30

Major

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

sqlInjectionCount>0

min(sqlInjectionCount,5)

Deadlock

Indicates whether a deadlock occurs during a day.

Minor

Minor

3

Item

Description

Sub-item

Condition

Deducted points

CPU Utilization (cpuUsage)

The average CPU utilization during a day. If an instance has multiple CPU cores, the system calculates the CPU utilization of each core and then calculates the average CPU utilization of all cores.

Major

70%<=cpuUsage<=80%

1 + (cpuUsage - 0.7) × 20

Critical

cpuUsage>=80%

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

Memory Usage (memUsage)

The average memory usage during a day.

Major

80%<=memUsage<=90%

1 + (memUsage - 0.8) × 20

Critical

memUsage>90%

min[(memUsage - 0.9) × 50, 10]

Connection Usage (connectionRate)

The connection usage is calculated based on the following formula: Connection usage = Average number of connections during a day/Maximum number of connections allowed at a point in time × 100%

Major

70%<=connectionRate<=80%

1

Critical

connectionRate>80%

3

Traffic Usage (FlowRate)

The traffic usage is calculated based on the following formula: Traffic usage = Average traffic during a day/Maximum traffic allowed at a point in time × 100%

Major

80% <= FlowRate <= 85% (Both inbound traffic and outbound traffic count.)

1

Critical

flowRate>85%

3

Critical

iopsUsage>90%

5

Hot Keys (HotKey)

The information about hot keys appears.

Minor

Minor

3

Slow SQL Statements (slowSqlCount)

The total number of slow SQL statements generated in one day. You can click the number to view the five slow SQL statements that are most frequently executed.

Minor

0<slowSqlCount<100

1 + (slowSqlCount - 10)/30

Major

100<=slowSqlCount<500

4 + (slowSqlCount - 100)/30

Critical

slowSqlCount>=500

min[18 + (slowSqlCount - 50)/30, 30)]

Memory Fragmentation Ratio (HighMemoryFragment)

The memory fragmentation ratio is calculated based on the following formula: mem_fragmentation_ratio = used_memory_rss/used_memory

• used_memory_rss: the amount of physical memory that the operating system allocates to Redis. The sizes of memory fragments are counted in this value.

• used_memory: the amount of memory that Redis requests to store data.

For more information about memory fragments and the memory fragmentation ratio, see Memory Fragmentation.

Minor

HighMemoryFragment>1.5

min(HighMemoryFragment × 2, 5)