Help Center > > Performance White Paper> RDS for MySQL> MySQL 5.6 Test Data

MySQL 5.6 Test Data

Updated at: Jan 10, 2020 GMT+08:00

About IOPS

Input/output operations per second (IOPS) is closely related to storage space (unit: GB) of the DB instance.

IOPS = min{3500 + (Instance storage space – 40) x 50, 33000}

For example, if the storage space of DB instance rds-test01 is 400 GB, IOPS is 21500 (or min{3500 + (400 - 40) x 50, 33000}=min{21500, and 33000}).

Test List of General-Enhanced Instances

The values in the Connections (Workload Test Value) column in the following tables are the result of the RDS performance stress test. For services running on the live network, set the parameter max_connections parameter.

Table 1 vCPU:Memory=1:2

vCPUs

Memory (GB)

Connections (Workload Test Value)

TPS

QPS

IOPS

1

2

800

197.19

3943.85

See About IOPS.

2

4

1500

470.4

9400.32

4

8

2500

768.23

15364.64

8

16

5000

1728.84

34576.84

16

32

10000

2947.42

58948.35

32

64

18000

3239.9

64798.05

60

128

30000

4735.63

94712.67

Table 2 vCPU:Memory=1:4

vCPUs

Memory (GB)

Connections (Workload Test Value)

TPS

QPS

IOPS

1

4

1500

466.73

9334.62

See About IOPS.

2

8

2500

519.24

10384.74

4

16

5000

1191.98

23839.68

8

32

10000

2698.01

53960.27

16

64

18000

3148.77

62975.44

32

128

30000

4385.29

87705.81

60

256

60000

4810.94

95117.75

Table 3 vCPU:Memory=1:8

vCPUs

Memory (GB)

Connections (Workload Test Value)

TPS

QPS

IOPS

1

8

2500

487.4

9748.07

See About IOPS.

2

16

5000

617.59

12351.83

4

32

10000

1374.01

27480.14

8

64

18000

2824.63

56492.64

16

128

30000

4215.09

84301.79

60

512

100000

4838.57

96771.34

Test Result of the General-Enhanced Instances

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

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel