Help Center/ Relational Database Service/ Performance White Paper/ RDS for MySQL/ RDS for MySQL 5.6 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

197.19

3,943.85

See About IOPS.

2

4

1,500

470.4

9,400.32

4

8

2,500

768.23

15,364.64

8

16

5,000

1,728.84

34,576.84

16

32

10,000

2,947.42

58,948.35

32

64

18,000

3,239.9

64,798.05

60

128

30,000

4,735.63

94,712.67
Table 2 vCPU:Memory = 1:4

vCPUs

Memory (GB)

Maximum Connections (Stress Testing)

TPS

QPS

IOPS

1

4

1,500

466.73

9,334.62

See About IOPS.

2

8

2,500

519.24

10,384.74

4

16

5,000

1,191.98

23,839.68

8

32

10,000

2,698.01

53,960.27

16

64

18,000

3,148.77

62,975.44

32

128

30,000

4,385.29

87,705.81

60

256

60,000

4,810.94

95,117.75
Table 3 vCPU:Memory = 1:8

vCPUs

Memory (GB)

Maximum Connections (Stress Testing)

TPS

QPS

IOPS

1

8

2,500

487.4

9,748.07

See About IOPS.

2

16

5,000

617.59

12,351.83

4

32

10,000

1,374.01

27,480.14

8

64

18,000

2,824.63

56,492.64

16

128

30,000

4,215.09

84,301.79

60

512

100,000

4,838.57

96,771.34

Test Results

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