Help Center/ Relational Database Service/ Performance White Paper/ RDS for MySQL/ RDS for MySQL 5.7 Test Data/ General-Enhanced DB Instances
Updated on 2022-10-31 GMT+08:00
View PDF
Share

General-Enhanced DB Instances

About IOPS

The input/output operations per second (IOPS) supported by RDS for MySQL depends on the I/O performance of Elastic Volume Service (EVS) disks. For details, see Disk Types and Performance in the Elastic Volume Service Service Overview.

Test Data

The Maximum Connections (Stress Testing) columns in the following tables indicate the results of the RDS performance stress testing. For running services on the live network, set the parameter max_connections.

Table 1 vCPU:Memory =1:2

vCPUs

Memory (GB)

Maximum Connections (Stress Testing)

TPS

QPS

IOPS

1

2

800

236.59

4,731.85

See About IOPS.

2

4

1,500

470.35

9,400.04

4

8

2,500

969.14

19,382.91

8

16

5,000

1,768.01

35,360.39

16

32

10,000

2,630.5

52,000.99

32

64

18,000

3,011.89

60,237.87

60

128

30,000

4,471.39

88,428.09
Table 2 vCPU:Memory = 1:4

vCPUs

Memory (GB)

Maximum Connections (Stress Testing)

TPS

QPS

IOPS

1

4

1,500

468.11

9,362.23

See About IOPS.

2

8

2,500

620.7

12,393.97

4

16

5,000

1,230.39

24,607.81

8

32

10,000

2,514.48

50,289.62

16

64

18,000

3,016.84

60,336.77

32

128

30,000

4,367.67

87,353.69

60

256

60,000

4,536.41

90,728.55
Table 3 vCPU:Memory = 1:8

vCPUs

Memory (GB)

Maximum Connections (Stress Testing)

TPS

QPS

IOPS

1

8

2,500

612.75

12,255.01

See About IOPS.

2

16

5,000

675.66

13,513.18

4

32

10,000

1,488.25

29,765.06

8

64

18,000

2,810.79

56,215.81

16

128

30,000

4,095.49

81,909.79

60

512

100,000

4,626.18

96,823.95

Test Results

Figure 1 vCPU:Memory =1:2
Figure 2 vCPU:Memory = 1:4
Figure 3 vCPU:Memory = 1:8