Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Performance differences between RDS Mysql Single-AZ and Multi-AZ

2025-04-02 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

High availability is the most important aspect of system architecture for many database engineers / architects. On AWS, Multi-AZ is a very important HA scheme for RDS.

However, whether enabling Multi-AZ has an impact on system performance and how much performance is sacrificed is the point of many user relations.

Today, I'm going to test the performance of Multi-AZ.

1. Environmental preparation

Create the EC2 of m4.xlarge (4CPU 16G) in the same AZ as RDS Mysql, which can reduce the influence of network factors.

Create a RDS Mysql for db.m4.xlarge (4CPU 16G)

two。 The method of installing sysbench based on RDS AMI2

Https://github.com/akopytov/sysbench this is the address of sysbench on git, which contains installation tutorials, including centoscurl-s https://packagecloud.io/install/repositories/akopytov/sysbench/script.rpm.sh | sudo bashsudo yum-y install sysbench

3. Sysbench data generation, generate sbtest table under sbtest library, a total of 100W records.

# sysbench-test=oltp-- oltp-table-size=1000000-- oltp-read-only=off-- init-rng=on-- num-threads=16-- max-requests=0-- oltp-dist-type=uniform-- max-time=1800-- mysql-user=root-- mysql-socket=/tmp/mysql.sock-- mysql-password=123456-- db-driver=mysql-- mysql-table-engine=innodb-- oltp-test-mode=complex prepare

For more uses of sysbench, please refer to another blog article

Https://blog.51cto.com/hsbxxl/2068181

4. The EC2 machine needs to install mysql client to prepare to connect to the database

Download address for RHEL7 series mysql5.7:

Rpm-ivh http://repo.mysql.com/mysql57-community-release-el7-11.noarch.rpmyum install mysql-community-client-y

5. Connect to the database

Mysql-hbjs.cbchwkqr6lfg.rds.cn-north-1.amazonaws.com.cn-uadmin-padmin123

6. Create a test database:

Mysql > create database dbtest

7. Insert data

Create 20 test tables

1 million rows of data per table.

# time sysbench/ usr/share/sysbench/tests/include/oltp_legacy/oltp.lua\-mysql-host=bjs.cbchwkqr6lfg.rds.cn-north-1.amazonaws.com.cn-- mysql-port=3306-- mysql-user=admin-- mysql-password=admin123\-- mysql-db=dbtest-- oltp-tables-count=20-- oltp-table-size=1000000\-- report-interval=10-- rand-init=on-- max-requests=0\-- oltp-read-only=off-- time=120-- threads=30\ prepare

Query the entire mysql database size, prepare 50 gigabytes of data, and prepare for testing

Mysql > select concat (round (sum (data_length/1024/1024), 2), 'MB') as data from information_schema.tables;+-+ | data | +-+ | 50100.26MB | +-+ 1 row in set (0.03 sec)

In fact, after I created multiple libraries by executing sysbench many times, I accumulated the data to 50 gigabytes, but during the test, there was only 4.2 gigabytes.

Mysql > select concat (round (sum (data_length/1024/1024), 2), 'MB') as data from information_schema.tables where TABLE_SCHEMA='test';+-+ | data | +-+ | 4267.05MB | +-+ 1 row in set (0.00 sec)

8. Prepare for the test and test the concurrency of 30, 50, 100, 200, 800, 1000, respectively

Time sysbench/ usr/share/sysbench/tests/include/oltp_legacy/oltp.lua\-mysql-host=bjs.cbchwkqr6lfg.rds.cn-north-1.amazonaws.com.cn-- mysql-port=3306-- mysql-user=admin-- mysql-password=admin123\-- mysql-db=test-- oltp-tables-count=20-- oltp-table-size=1000000\-- report-interval=10-- rand-init=on-- max-requests=0\-- oltp-read-only=off-- time=120-- threads=100\ run

9. The test results are as follows

Single-AZ

Multi-AZ

thirty

[10s] thds: 30 tps: 1032.91 qps: 20697.83 (r/w/o: 14495.96 tps) lat (ms,95%): 48.34 err/s: 0.00 reconn/s: 0.00

[20s] thds: 30 tps: 1033.51 qps: 20673.35 (r/w/o: 14470.47 tps) lat (ms,95%): 46.63 err/s: 0.00 reconn/s: 0.00

[30s] thds: 30 tps: 1085.89 qps: 21723.72 (r/w/o: 15204.28) lat (ms,95%): 44.17 err/s: 0.20 reconn/s: 0.00

[40s] thds: 30 tps: 1049.03 qps: 20974.76 (r/w/o: 14686.36 tps) lat (ms,95%): 44.98 err/s: 0.00 reconn/s: 0.00

[50s] thds: 30 tps: 1107.37 qps: 22141.33 (r/w/o: 15494.93 tps) lat (ms,95%): 42.61 err/s: 0.00 reconn/s: 0.00

[60s] thds: 30 tps: 1105.84 qps: 22121.03 (r/w/o: 15488.51) lat (ms,95%): 41.85 err/s: 0.00 reconn/s: 0.00

[70s] thds: 30 tps: 1097.57 qps: 21952.09 (r/w/o: 15364.17 tps) lat (ms,95%): 42.61 err/s: 0.00 reconn/s: 0.00

[80s] thds: 30 tps: 1103.28 qps: 22064.42 (r/w/o: 15444.26) lat (ms,95%): 42.61 err/s: 0.10 reconn/s: 0.00

[90s] thds: 30 tps: 1092.20 qps: 21845.18 (r/w/o: 15293.98) lat (ms,95%): 43.39 err/s: 0.00 reconn/s: 0.00

[100s] thds: 30 tps: 1108.80 qps: 22184.35 (r/w/o: 15529.84 tps) lat (ms,95%): 42.61 err/s: 0.10 reconn/s: 0.00

[110s] thds: 30 tps: 997.20 qps: 19949.65 (r/w/o: 13962.97 + 3992.29) lat (ms,95%): 52.89 err/s: 0.00 reconn/s: 0.00

[120s] thds: 30 tps: 1110.47 qps: 22210.67 (r/w/o: 15544.46) lat (ms,95%): 41.85 err/s: 0.00 reconn/s: 0.00

SQL statistics:

Queries performed:

Read: 1809850

Write: 517089

Other: 258546

Total: 2585485

Transactions: 129271 (1077.14 per sec.)

Queries: 2585485 (21543.33 per sec.)

Ignored errors: 4 (0.03 per sec.)

Reconnects: 0 (0.00 per sec.)

General statistics:

Total time: 120.0116s

Total number of events: 129271

Latency (ms):

Min: 7.31

Avg: 27.85

Max: 284.50

95th percentile: 44.17

Sum: 3599601.23

Threads fairness:

Events (avg/stddev): 4309.0333 Universe 116.51

Execution time (avg/stddev): 119.9867 Universe 0.00

[10s] thds: 30 tps: 741.47 qps: 14871.18 (r/w/o: 10414.53 lat 2970.70) lat (ms,95%): 78.60 err/s: 0.00 reconn/s: 0.00

[20s] thds: 30 tps: 920.00 qps: 18399.66 (r/w/o: 12878.57 reconn/s: 18399.66) lat (ms,95%): 58.92 err/s: 0.00 reconn/s: 0.00

[30s] thds: 30 tps: 993.70 qps: 19875.43 (r/w/o: 13912.82 tps) lat (ms,95%): 53.85 err/s: 0.00 reconn/s: 0.00

[40s] thds: 30 tps: 962.70 qps: 19256.83 (r/w/o: 13478.65) lat (ms,95%): 56.84 err/s: 0.00 reconn/s: 0.00

[50s] thds: 30 tps: 816.21 qps: 16326.51 (r/w/o: 11434.48 tps) lat (ms,95%): 70.55 err/s: 0.00 reconn/s: 0.00

[60s] thds: 30 tps: 609.00 qps: 12173.01 (r/w/o: 8516.04 reconn/s) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00

[70s] thds: 30 tps: 734.40 qps: 14702.05 (r/w/o: 10291.83) lat (ms,95%): 81.48 err/s: 0.10 reconn/s: 0.00

[80s] thds: 30 tps: 625.90 qps: 12513.25 (r/w/o: 8763.74 tps) lat (ms,95%): 130.13 err/s: 0.00 reconn/s: 0.00

[90s] thds: 30 tps: 826.94 qps: 16525.74 (r/w/o: 11563.22) lat (ms,95%): 73.13 err/s: 0.00 reconn/s: 0.00

[100s] thds: 30 tps: 874.85 qps: 17508.17 (r/w/o: 12257.48 tps) lat (ms,95%): 71.83 err/s: 0.00 reconn/s: 0.00

[110s] thds: 30 tps: 966.67 qps: 19337.83 (r/w/o: 13535.93 tps 3868.57) lat (ms,95%): 54.83 err/s: 0.00 reconn/s: 0.00

[120s] thds: 30 tps: 977.11 qps: 19538.22 (r/w/o: 13676.65) lat (ms,95%): 55.82 err/s: 0.00 reconn/s: 0.00

SQL statistics:

Queries performed:

Read: 1407308

Write: 402084

Other: 201043

Total: 2010435

Transactions: 100521 (837.49 per sec.)

Queries: 2010435 (16750.02 per sec.)

Ignored errors: 1 (0.01 per sec.)

Reconnects: 0 (0.00 per sec.)

General statistics:

Total time: 120.0242s

Total number of events: 100521

Latency (ms):

Min: 13.57

Avg: 35.81

Max: 763.31

95th percentile: 66.84

Sum: 3599948.66

Threads fairness:

Events (avg/stddev): 3350.7000 big 34.93

Execution time (avg/stddev): 119.9983

fifty

[10s] thds: 50 tps: 1137.08 qps: 22805.30 (r/w/o: 15977.15 lat 4549.00) lat (ms,95%): 99.33 err/s: 0.00 reconn/s: 0.00

[20s] thds: 50 tps: 1146.71 qps: 22938.37 (r/w/o: 16053.52 reconn/s 4591.23) lat (ms,95%): 99.33 err/s: 0.20 reconn/s: 0.00

[30s] thds: 50 tps: 1154.99 qps: 23107.28 (r/w/o: 16174.22 tps) lat (ms,95%): 99.33 err/s: 0.00 reconn/s: 0.00

[40s] thds: 50 tps: 657.80 qps: 13150.37 (r/w/o: 9203.88) lat (ms,95%): 164.45 err/s: 0.00 reconn/s: 0.00

[50s] thds: 50 tps: 1113.10 qps: 22261.67 (r/w/o: 15588.68) lat (ms,95%): 104.84 err/s: 0.10 reconn/s: 0.00

[60s] thds: 50 tps: 1147.00 qps: 22921.44 (r/w/o: 16039.52 tps) lat (ms,95%): 102.97 err/s: 0.00 reconn/s: 0.00

[70s] thds: 50 tps: 1157.30 qps: 23146.43 (r/w/o: 16198.85 reconn/s) lat (ms,95%): 102.97 err/s: 0.1 reconn/s: 0.00

[80s] thds: 50 tps: 1155.70 qps: 23134.14 (r/w/o: 16199.53 reconn/s) lat (ms,95%): 102.97 err/s: 0.00 reconn/s: 0.00

[90s] thds: 50 tps: 985.10 qps: 19722.64 (r/w/o: 13804.03) lat (ms,95%): 121.08 err/s: 0.00 reconn/s: 0.00

[100s] thds: 50 tps: 1111.42 qps: 22206.79 (r/w/o: 15549.14 lat 4434.80) lat (ms,95%): 104.84 err/s: 0.10 reconn/s: 0.00

[110s] thds: 50 tps: 1130.91 qps: 22630.72 (r/w/o: 15839.35 tps 4529.44) lat (ms,95%): 104.84 err/s: 0.00 reconn/s: 0.00

[120s] thds: 50 tps: 1137.51 qps: 22759.94 (r/w/o: 15932.27) lat (ms,95%): 104.84 err/s: 0.00 reconn/s: 0.00

SQL statistics:

Queries performed:

Read: 1825656

Write: 521602

Other: 260803

Total: 2608061

Transactions: 130399 (1086.47 per sec.)

Queries: 2608061 (21730.15 per sec.)

Ignored errors: 5 (0.04 per sec.)

Reconnects: 0 (0.00 per sec.)

General statistics:

Total time: 120.0187s

Total number of events: 130399

Latency (ms):

Min: 7.79

Avg: 46.01

Max: 3068.14

95th percentile: 104.84

Sum: 5999824.14

Threads fairness:

Events (avg/stddev): 2607.9800Universe 44.76

Execution time (avg/stddev): 119.9965plus 0.00

[10s] thds: 50 tps: 1104.51 qps: 22152.75 (r/w/o: 15515.60 tps 4423.13 lat 2214.02) lat (ms,95%): 90.78 err/s: 0.00 reconn/s: 0.00

[20s] thds: 50 tps: 1085.65 qps: 21687.20 (r/w/o: 15175.97 qps: 4339.92) lat (ms,95%): 97.55 err/s: 0.00 reconn/s: 0.00

[30s] thds: 50 tps: 1077.41 qps: 21578.35 (r/w/o: 15109.98 reconn/s: 21578.35) lat (ms,95%): 99.33 err/s: 0.00 reconn/s: 0.00

[40s] thds: 50 tps: 1086.50 qps: 21730.67 (r/w/o: 15210.98 lat: 4346.69) lat (ms,95%): 97.55 err/s: 0.00 reconn/s: 0.00

[50s] thds: 50 tps: 1070.37 qps: 21421.94 (r/w/o: 14995.34 tps) lat (ms,95%): 99.33 err/s: 0.10 reconn/s: 0.00

[60s] thds: 50 tps: 239.71 qps: 4795.87 (r/w/o: 3361.62) lat (ms,95%): 977.74 err/s: 0.00 reconn/s: 0.00

[70s] thds: 50 tps: 448.78 qps: 8984.91 (r/w/o: 6282.93 tps) lat (ms,95%): 475.79 err/s: 0.00 reconn/s: 0.00

[80s] thds: 50 tps: 812.47 qps: 16234.29 (r/w/o: 11367.37) lat (ms,95%): 161.51 err/s: 0.10 reconn/s: 0.00

[90s] thds: 50 tps: 1085.08 qps: 21682.19 (r/w/o: 15176.41 tps 4335.62) lat (ms,95%): 97.55 err/s: 0.00 reconn/s: 0.00

[100s] thds: 50 tps: 860.51 qps: 17236.42 (r/w/o: 12070.38 tps) lat (ms,95%): 116.80 err/s: 0.00 reconn/s: 0.00

[110s] thds: 50 tps: 773.40 qps: 15459.21 (r/w/o: 10815.14 reconn/s: 15459.21) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00

[120s] thds: 50 tps: 747.60 qps: 14970.13 (r/w/o: 10477.52 qps) lat (ms,95%): 161.51 err/s: 0.00 reconn/s: 0.00

SQL statistics:

Queries performed:

Read: 1455650

Write: 415892

Other: 207948

Total: 2079490

Transactions: 103973 (866.29 per sec.)

Queries: 2079490 (17326.02 per sec.)

Ignored errors: 2 (0.02 per sec.)

Reconnects: 0 (0.00 per sec.)

General statistics:

Total time: 120.0196s

Total number of events: 103973

Latency (ms):

Min: 14.19

Avg: 57.71

Max: 1418.10

95th percentile: 127.81

Sum: 59 × × 5.02

Threads fairness:

Events (avg/stddev): 2079.4600 Universe 31.43

Execution time (avg/stddev): 119.99850.00

two hundred

[10s] thds: 800 tps: 1063.47 qps: 22467.06 (r/w/o: 15884.30 lat: 4376.52) lat (ms,95%): 2279.14 err/s: 0.00 reconn/s: 0.00

[20s] thds: 800 tps: 1209.51 qps: 23794.47 (r/w/o: 16553.90 lat: 4840.15) lat (ms,95%): 1191.92 err/s: 0.50 reconn/s: 0.00

[30s] thds: 800 tps: 1174.39 qps: 23782.60 (r/w/o: 16683.96 tps) lat (ms,95%): 1352.03 err/s: 0.40 reconn/s: 0.00

[40s] thds: 800tps: 1186.26 qps: 23531.91 (r/w/o: 16549.15) lat (ms,95%): 1280.93 err/s: 0.70 reconn/s: 0.00

[50s] thds: 800 tps: 1162.29 qps: 23559.83 (r/w/o: 16477.78) lat (ms,95%): 1304.21 err/s: 0.30 reconn/s: 0.00

[60s] thds: 800 tps: 1194.38 qps: 23766.52 (r/w/o: 16700.46) lat (ms,95%): 1352.03 err/s: 0.90 reconn/s: 0.00

[70s] thds: 800 tps: 1108.95 qps: 22610.92 (r/w/o: 15698.87 tps) lat (ms,95%): 1191.92 err/s: 0.40 reconn/s: 0.00

[80s] thds: 800tps: 1119.46 qps: 21946.37 (r/w/o: 15428.88 tps) lat (ms,95%): 1191.92 err/s: 0.20 reconn/s: 0.00

[90s] thds: 800 tps: 1126.60 qps: 22334.43 (r/w/o: 15597.15 tps) lat (ms,95%): 1109.09 err/s: 0.30 reconn/s: 0.00

[100s] thds: 800 tps: 1067.54 qps: 21973.41 (r/w/o: 15374.77) lat (ms,95%): 1129.24 err/s: 0.40 reconn/s: 0.00

[110s] thds: 800 tps: 1129.46 qps: 22201.94 (r/w/o: 15586.77 reconn/s: 22201.94) lat (ms,95%): 1170.65 err/s: 0.40 reconn/s: 0.00

[120s] thds: 800 tps: 1140.79 qps: 22534.39 (r/w/o: 15771.72 tps) lat (ms,95%): 1089.30 err/s: 0.70 reconn/s: 0.00

SQL statistics:

Queries performed:

Read: 1927800

Write: 550653

Other: 275347

Total: 2753800

Transactions: 137647 (1141.45 per sec.)

Queries: 2753800 (22836.15 per sec.)

Ignored errors: 53 (0.44 per sec.)

Reconnects: 0 (0.00 per sec.)

General statistics:

Total time: 120.5878s

Total number of events: 137647

Latency (ms):

Min: 11.84

Avg: 700.06

Max: 13337.59

95th percentile: 1191.92

Sum: 96361497.32

Threads fairness:

Events (avg/stddev): 172.0588 Universe 13.66

Execution time (avg/stddev): 120.4519 take 0.07

[10s] thds: 800 tps: 1100.32 qps: 22507.97 (r/w/o: 15826.77 reconn/s) lat (ms,95%): 719.92 err/s: 0.00 reconn/s: 0.00

[20s] thds: 800 tps: 1086.05 qps: 22402.20 (r/w/o: 15672.30 tps) lat (ms,95%): 960.30 err/s: 0.00 reconn/s: 0.00

[30s] thds: 800 tps: 1130.59 qps: 22803.59 (r/w/o: 16002.32 lat 4527.58) lat (ms,95%): 1327.91 err/s: 0.40 reconn/s: 0.00

[40s] thds: 800 tps: 1180.40 qps: 23317.74 (r/w/o: 16336.33 tps) lat (ms,95%): 1280.93 err/s: 0.80 reconn/s: 0.00

[50s] thds: 800 tps: 1155.40 qps: 23013.64 (r/w/o: 16136.43 lat 4566.11) lat (ms,95%): 1280.93 err/s: 0.40 reconn/s: 0.00

[60s] thds: 800 tps: 1134.00 qps: 22988.59 (r/w/o: 16075.89) lat (ms,95%): 1213.57 err/s: 0.30 reconn/s: 0.00

[70s] thds: 800 tps: 1118.30 qps: 22453.46 (r/w/o: 15747.27) lat (ms,95%): 1213.57 err/s: 0.50 reconn/s: 0.00

[80s] thds: 800 tps: 1171.49 qps: 23023.86 (r/w/o: 16111.60) lat (ms,95%): 1258.08 err/s: 0.60 reconn/s: 0.00

[90s] thds: 800 tps: 776.81 qps: 15932.48 (r/w/o: 11202.93) lat (ms,95%): 1479.41 err/s: 0.20 reconn/s: 0.00

[100s] thds: 800 tps: 240.90 qps: 4828.00 (r/w/o: 3375.40 reconn/s) lat (ms,95%): 8955.74 err/s: 0.20 reconn/s: 0.00

[110s] thds: 800 tps: 73.70 qps: 1378.19 (r/w/o: 941.99 reconn/s: 147.10) lat (ms,95%): 12609.11 err/s: 0.10 reconn/s: 0.00

[120s] thds: 800 tps: 224.80 qps: 4457.62 (r/w/o: 3120.31 tps 886.80 lat 450.50) lat (ms,95%): 13797.01 err/s: 0.70 reconn/s: 0.00

SQL statistics:

Queries performed:

Read: 1466836

Write: 418969

Other: 209504

Total: 2095309

Transactions: 104730 (857.66 per sec.)

Queries: 2095309 (17158.99 per sec.)

Ignored errors: 44 (0.36 per sec.)

Reconnects: 0 (0.00 per sec.)

General statistics:

Total time: 122.1097s

Total number of events: 104730

Latency (ms):

Min: 15.85

Avg: 927.55

Max: 22921.04

95th percentile: 2009.23

Sum: 97142625.81

Threads fairness:

Events (avg/stddev): 130.9125 _ 25.08

Execution time (avg/stddev): 121.4283 Universe 0.35

one thousand

[10s] thds: 1000 tps: 891.39 qps: 19388.55 (r/w/o: 13779.33 tps 3725.62) lat (ms,95%): 3511.19 err/s: 1.30 reconn/s: 0.00

[20s] thds: 1000 tps: 1119.00 qps: 21904.82 (r/w/o: 15346.84 tps) lat (ms,95%): 2009.23 err/s: 1.30 reconn/s: 0.00

[30s] thds: 1000 tps: 1100.69 qps: 22226.53 (r/w/o: 15506.38 tps) lat (ms,95%): 1533.66 err/s: 0.40 reconn/s: 0.00

[40s] thds: 1000 tps: 1125.50 qps: 22024.51 (r/w/o: 15316.51 tps) lat (ms,95%): 1479.41 err/s: 0.70 reconn/s: 0.00

[50s] thds: 1000 tps: 1099.00 qps: 22629.65 (r/w/o: 15922.37) lat (ms,95%): 1618.78 err/s: 0.70 reconn/s: 0.00

[60s] thds: 1000 tps: 1136.32 qps: 22505.01 (r/w/o: 15790.08 lat 4441.68) lat (ms,95%): 1648.20 err/s: 0.60 reconn/s: 0.00

[70s] thds: 1000 tps: 1091.80 qps: 22445.50 (r/w/o: 15652.63) lat (ms,95%): 1678.14 err/s: 0.50 reconn/s: 0.00

[80s] thds: 1000 tps: 1180.77 qps: 23013.43 (r/w/o: 16082.90 tps) lat (ms,95%): 1561.52 err/s: 0.70 reconn/s: 0.00

[90s] thds: 1000 tps: 1130.25 qps: 23059.71 (r/w/o: 16238.81 tps 4559.30) lat (ms,95%): 1352.03 err/s: 0.50 reconn/s: 0.00

[100s] thds: 1000 tps: 1189.76 qps: 23244.00 (r/w/o: 16301.31 tps 4562.66) lat (ms,95%): 1708.63 err/s: 0.60 reconn/s: 0.00

[110s] thds: 1000 tps: 611.42 qps: 12876.74 (r/w/o: 9019.31 tps 2634.19 lat 1223.24) lat (ms,95%): 4855.31 err/s: 0.40 reconn/s: 0.00

[120s] thds: 1000 tps: 741.35 qps: 14545.68 (r/w/o: 10140.56 tps) lat (ms,95%): 4683.57 err/s: 1.80 reconn/s: 0.00

SQL statistics:

Queries performed:

Read: 1753542

Write: 500724

Other: 250410

Total: 2504676

Transactions: 125157 (1030.73 per sec.)

Queries: 2504676 (20627.31 per sec.)

Ignored errors: 96 (0.79 per sec.)

Reconnects: 0 (0.00 per sec.)

General statistics:

Total time: 121.4235s

Total number of events: 125157

Latency (ms):

Min: 8.94

Avg: 965.21

Max: 11345.14

95th percentile: 1938.16

Sum: 120803219.78

Threads fairness:

Events (avg/stddev): 125.1570Universe 7.27

Execution time (avg/stddev): 120.8032Universe 0.53

[10s] thds: 1000 tps: 1129.94 qps: 23135.53 (r/w/o: 16280.62 tps) lat (ms,95%): 601.29 err/s: 0.20 reconn/s: 0.00

[20s] thds: 1000 tps: 1140.93 qps: 23010.78 (r/w/o: 16134.27) lat (ms,95%): 11732.86 err/s: 0.60 reconn/s: 0.00

[30s] thds: 1000 tps: 1134.00 qps: 22820.04 (r/w/o: 15933.53 tps 4617.71) lat (ms,95%): 1401.61 err/s: 0.90 reconn/s: 0.00

[40s] thds: 1000 tps: 1140.60 qps: 23106.22 (r/w/o: 16288.23 tps) lat (ms,95%): 1648.20 err/s: 0.60 reconn/s: 0.00

[50s] thds: 1000 tps: 1134.12 qps: 22744.62 (r/w/o: 15905.52 tps 4570.56) lat (ms,95%): 1678.14 err/s: 0.40 reconn/s: 0.00

[60s] thds: 1000 tps: 1143.28 qps: 23087.18 (r/w/o: 16262.27) lat (ms,95%): 1561.52 err/s: 0.50 reconn/s: 0.00

[70s] thds: 1000 tps: 1168.05 qps: 23113.24 (r/w/o: 16045.85 lat 4730.39) lat (ms,95%): 1453.01 err/s: 0.60 reconn/s: 0.00

[80s] thds: 1000 tps: 1122.76 qps: 22873.54 (r/w/o: 16028.40 tps) lat (ms,95%): 1648.20 err/s: 0.50 reconn/s: 0.00

[90s] thds: 1000 tps: 1159.40 qps: 23234.23 (r/w/o: 16259.85) lat (ms,95%): 1479.41 err/s: 0.60 reconn/s: 0.00

[100s] thds: 1000 tps: 396.94 qps: 7989.86 (r/w/o: 5714.24 tps 1481.34 reconn/s 794.28) lat (ms,95%): 1561.52 reconn/s: 0.00

[110s] thds: 1000 tps: 73.40 qps: 1532.60 (r/w/o: 1031.80 lat 353.70 qps) lat (ms,95%): 17124.84 err/s: 0.30 reconn/s: 0.00

[120s] thds: 1000 tps: 120.10 qps: 2403.50 (r/w/o: 1689.80) lat (ms,95%): 20876.04 err/s: 0.60 reconn/s: 0.00

SQL statistics:

Queries performed:

Read: 1535814

Write: 438626

Other: 219339

Total: 2193779

Transactions: 109638 (885.96 per sec.)

Queries: 2193779 (17727.46 per sec.)

Ignored errors: 63 (0.51 per sec.)

Reconnects: 0 (0.00 per sec.)

General statistics:

Total time: 123.7486s

Total number of events: 109638

Latency (ms):

Min: 21.90

Avg: 1109.17

Max: 30488.80

95th percentile: 1836.24

Sum: 121607109.37

Threads fairness:

Events (avg/stddev): 109.6380 _ 22.01

Execution time (avg/stddev): 121.6071 Universe 1.16

10. Through the AWS console, you can see the number of session connections to RDS during the test.

11. Modify it to multi-zone available RDS, and then test it

twelve。 Through the console, you can see the modification status of Multi-AZ

13. Increase the database test load, create more tables, and single table data.

Create 79 tables, each with 1000W rows of data.

Sysbench/ usr/share/sysbench/tests/include/oltp_legacy/oltp.lua-mysql-host=bjs.cbchwkqr6lfg.rds.cn-north-1.amazonaws.com.cn-mysql-port=3306-mysql-user=admin-mysql-password=admin123-mysql-db=testdb2-oltp-tables-count=79-oltp-table-size=100000000-report-interval=10-rand-init=on-max-requests=0 oltp-read-only=off time=120 time=120 threads=200 run

14. Test result

Single AZ

Multi-AZ

fifty

[10s] thds: 50 tps: 1540.85 qps: 30875.71 (r/w/o: 21621.50 tps) lat (ms,95%): 81.48 err/s: 0.00 reconn/s: 0.00

[20s] thds: 50 tps: 1554.53 qps: 31079.39 (r/w/o: 21756.11) lat (ms,95%): 81.48 err/s: 0.00 reconn/s: 0.00

[30s] thds: 50 tps: 1526.90 qps: 30542.91 (r/w/o: 21378.61 reconn/s: 30542.91) lat (ms,95%): 82.96 err/s: 0.00 reconn/s: 0.00

[40s] thds: 50 tps: 1527.80 qps: 30557.08 (r/w/o: 21389.45 reconn/s: 30557.08) lat (ms,95%): 86.00 err/s: 0.00 reconn/s: 0.00

[50s] thds: 50 tps: 1532.99 qps: 30653.60 (r/w/o: 21458.63) lat (ms,95%): 84.47 err/s: 0.00 reconn/s: 0.00

[60s] thds: 50 tps: 1523.50 qps: 30496.87 (r/w/o: 21347.75 tps 1641.30 lat (ms,95%): 87.56 err/s: 0.00 reconn/s: 0.00

[70s] thds: 50 tps: 1519.50 qps: 30376.99 (r/w/o: 21259.99) lat (ms,95%): 86.00 err/s: 0.00 reconn/s: 0.00

[80s] thds: 50 tps: 1525.46 qps: 30519.01 (r/w/o: 21369.97 reconn/s: 30519.01) lat (ms,95%): 86.00 err/s: 0.10 reconn/s: 0.00

[90s] thds: 50 tps: 1523.79 qps: 30470.11 (r/w/o: 21325.17 reconn/s) lat (ms,95%): 86.00 err/s: 0.00 reconn/s: 0.00

[100s] thds: 50 tps: 1513.82 qps: 30271.23 (r/w/o: 21191.90) lat (ms,95%): 86.00 err/s: 0.00 reconn/s: 0.00

[110s] thds: 50 tps: 1506.51 qps: 30139.70 (r/w/o: 21101.74 tps 1619.51 reconn/s) lat (ms,95%): 86.00 err/s: 0.00 reconn/s: 0.00

[120s] thds: 50 tps: 1495.22 qps: 29890.14 (r/w/o: 20920.04 tps) lat (ms,95%): 87.56 err/s: 0.00 reconn/s: 0.00

SQL statistics:

Queries performed:

Read: 2561496

Write: 196607

Other: 901175

Total: 3659278

Transactions: 182963 (1524.33 per sec.)

Queries: 3659278 (30486.75 per sec.)

Ignored errors: 1 (0.01 per sec.)

Reconnects: 0 (0.00 per sec.)

General statistics:

Total time: 120.0268s

Total number of events: 182963

Latency (ms):

Min: 6.70

Avg: 32.79

Max: 204.90

95th percentile: 84.47

Sum: 5999973.93

Threads fairness:

Events (avg/stddev): 3659.2600Universe 80.74

Execution time (avg/stddev): 119.9995plus 0.00

[10s] thds: 50 tps: 1263.61 qps: 25348.42 (r/w/o: 17750.59) lat (ms,95%): 66.84 err/s: 0.00 reconn/s: 0.00

[20s] thds: 50 tps: 1407.15 qps: 28115.78 (r/w/o: 19682.69) lat (ms,95%): 57.87 err/s: 0.00 reconn/s: 0.00

[30s] thds: 50 tps: 1295.70 qps: 25942.03 (r/w/o: 18155.25 tps) lat (ms,95%): 68.05 err/s: 0.00 reconn/s: 0.00

[40s] thds: 50 tps: 1376.10 qps: 27512.77 (r/w/o: 19261.48) lat (ms,95%): 57.87 err/s: 0.00 reconn/s: 0.00

[50s] thds: 50 tps: 1332.81 qps: 26679.74 (r/w/o: 18673.60) lat (ms,95%): 59.99 err/s: 0.00 reconn/s: 0.00

[60s] thds: 50 tps: 1349.03 qps: 26967.78 (r/w/o: 18880.87) lat (ms,95%): 59.99 err/s: 0.00 reconn/s: 0.00

[70s] thds: 50 tps: 1372.52 qps: 27440.49 (r/w/o: 19205.08 reconn/s: 27440.49) lat (ms,95%): 58.92 err/s: 0.00 reconn/s: 0.00

[80s] thds: 50 tps: 1368.34 qps: 27367.41 (r/w/o: 19157.50 qps 1400.04 lat (ms,95%): 57.87 err/s: 0.00 reconn/s: 0.00

[90s] thds: 50 tps: 1355.17 qps: 27101.59 (r/w/o: 18971.94 tps) lat (ms,95%): 59.99 err/s: 0.00 reconn/s: 0.00

[100s] thds: 50 tps: 1348.41 qps: 26959.30 (r/w/o: 18870.07) lat (ms,95%): 59.99 err/s: 0.00 reconn/s: 0.00

[110s] thds: 50 tps: 1327.86 qps: 26584.54 (r/w/o: 18610.87 tps) lat (ms,95%): 61.08 err/s: 0.00 reconn/s: 0.00

[120s] thds: 50 tps: 1325.13 qps: 26510.70 (r/w/o: 18555.82 tps) lat (ms,95%): 62.19 err/s: 0.10 reconn/s: 0.00

SQL statistics:

Queries performed:

Read: 2257808

Write: 164934

Other: 802696

Total: 3225438

Transactions: 161271 (1343.39 per sec.)

Queries: 3225438 (26867.91 per sec.)

Ignored errors: 1 (0.01 per sec.)

Reconnects: 0 (0.00 per sec.)

General statistics:

Total time: 120.0463s

Total number of events: 161271

Latency (ms):

Min: 18.16

Avg: 37.21

Max: 297.41

95th percentile: 59.99

Sum: 6001143.16

Threads fairness:

Events (avg/stddev): 3225.4200 Universe 16.17

Execution time (avg/stddev): 120.0229Universe 0.00

two hundred

[10s] thds: 200 tps: 1601.51 qps: 32216.89 (r/w/o: 1681.46 reconn/s) lat (ms,95%): 282.25 err/s: 0.10 reconn/s: 0.00

[20s] thds: 200tps: 1465.94 qps: 29317.03 (r/w/o: 20507.28) lat (ms,95%): 320.17 err/s: 0.00 reconn/s: 0.00

[30s] thds: 200tps: 1612.80 qps: 32289.36 (r/w/o: 22629.74 tps) lat (ms,95%): 272.27 err/s: 0.00 reconn/s: 0.00

[40s] thds: 200tps: 1587.50 qps: 31723.89 (r/w/o: 22198.89 reconn/s: 31723.89) lat (ms,95%): 277.21 err/s: 0.00 reconn/s: 0.00

[50s] thds: 200tps: 1562.41 qps: 31355.32 (r/w/o: 21949.19 tps) lat (ms,95%): 287.38 err/s: 0.00 reconn/s: 0.00

[60s] thds: 200 tps: 1615.56 qps: 32234.14 (r/w/o: 1694.95 tps 791.39) lat (ms,95%): 282.25 err/s: 0.00 reconn/s: 0.00

[70s] thds: 200tps: 1576.34 qps: 31614.02 (r/w/o: 22132.77) lat (ms,95%): 297.92 err/s: 0.10 reconn/s: 0.00

[80s] thds: 200tps: 1583.20 qps: 31560.02 (r/w/o: 22068.04 tps) lat (ms,95%): 282.25 err/s: 0.00 reconn/s: 0.00

[90s] thds: 200tps: 1615.40 qps: 32433.12 (r/w/o: 22710.24 tps) lat (ms,95%): 277.21 err/s: 0.00 reconn/s: 0.00

[100s] thds: 200tps: 1578.01 qps: 31514.80 (r/w/o: 22072.97 reconn/s 1654.51) lat (ms,95%): 287.38 err/s: 0.00 reconn/s: 0.00

[110s] thds: 200tps: 1561.40 qps: 31223.82 (r/w/o: 21863.72 reconn/s 1647.80) lat (ms,95%): 308.84 err/s: 0.00 reconn/s: 0.00

[120s] thds: 200tps: 1608.37 qps: 32104.09 (r/w/o: 22464.97 tps 1694.57) lat (ms,95%): 267.41 err/s: 0.00 reconn/s: 0.00

SQL statistics:

Queries performed:

Read: 2658502

Write: 199880

Other: 939474

Total: 3797856

Transactions: 189891 (1581.09 per sec.)

Queries: 3797856 (31622.16 per sec.)

Ignored errors: 2 (0.02 per sec.)

Reconnects: 0 (0.00 per sec.)

General statistics:

Total time: 120.0994s

Total number of events: 189891

Latency (ms):

Min: 7.13

Avg: 126.45

Max: 892.23

95th percentile: 287.38

Sum: 24011105.70

Threads fairness:

Events (avg/stddev): 949.45500.42.99

Execution time (avg/stddev): 120.0555

[10s] thds: 200tps: 1431.89 qps: 29346.64 (r/w/o: 20610.27) lat (ms,95%): 308.84 err/s: 24.38 reconn/s: 0.00

[20s] thds: 200tps: 1524.35 qps: 30482.11 (r/w/o: 21333.24 tps) lat (ms,95%): 267.41 err/s: 1.70 reconn/s: 0.00

[30s] thds: 200 tps: 1395.15 qps: 27909.95 (r/w/o: 19532.63 tps 1418.05 lat 6959.26) lat (ms,95%): 314.45 err/s: 0.40 reconn/s: 0.00

[40s] thds: 200tps: 1512.74 qps: 30181.06 (r/w/o: 21117.80 tps 1530.85) lat (ms,95%): 267.41 err/s: 0.80 reconn/s: 0.00

[50s] thds: 200tps: 1501.80 qps: 30159.96 (r/w/o: 21135.84 tps 1526.70 reconn/s 7497.42) lat (ms,95%): 267.41 err/s: 0.20 reconn/s: 0.00

[60s] thds: 200 tps: 1491.58 qps: 29782.21 (r/w/o: 20842.36) lat (ms,95%): 282.25 err/s: 0.60 reconn/s: 0.00

[70s] thds: 200 tps: 1499.33 qps: 30072.38 (r/w/o: 21053.51 tps 1532.13) lat (ms,95%): 267.41 err/s: 0.10 reconn/s: 0.00

[80s] thds: 200 tps: 1439.60 qps: 28764.08 (r/w/o: 20137.29 lat 1464.60) lat (ms,95%): 277.21 err/s: 0.30 reconn/s: 0.00

[90s] thds: 200tps: 1500.80 qps: 30070.31 (r/w/o: 21044.01 tps 1531.00) lat (ms,95%): 262.64 err/s: 0.30 reconn/s: 0.00

[100s] thds: 200 tps: 1503.88 qps: 30132.16 (r/w/o: 21079.40 tps 1542.88 reconn/s 7509.89) lat (ms,95%): 257.95 reconn/s: 0.00

[110s] thds: 200 tps: 1517.92 qps: 30257.87 (r/w/o: 21192.66 lat 1535.02) lat (ms,95%): 272.27 err/s: 0.20 reconn/s: 0.00

[120s] thds: 200tps: 1484.81 qps: 29818.13 (r/w/o: 20864.49 lat 1525.11) lat (ms,95%): 267.41 err/s: 0.30 reconn/s: 0.00

SQL statistics:

Queries performed:

Read: 2499574

Write: 181385

Other: 889273

Total: 3570232

Transactions: 178247 (1483.35 per sec.)

Queries: 3570232 (29710.98 per sec.)

Ignored errors 294 (2.45 per sec.)

Reconnects: 0 (0.00 per sec.)

General statistics:

Total time: 120.1637s

Total number of events: 178247

Latency (ms):

Min: 21.32

Avg: 134.78

Max: 1049.36

95th percentile: 277.21

Sum: 24024895.81

Threads fairness:

Events (avg/stddev): 891.2350lap25.13

Execution time (avg/stddev): 120.1245 + 0.02

four hundred

[10s] thds: 400 tps: 1577.46 qps: 32006.99 (r/w/o: 1665.93 tps) lat (ms,95%): 530.08 err/s: 0.10 reconn/s: 0.00

[20s] thds: 400 tps: 1573.42 qps: 31745.80 (r/w/o: 22172.37) lat (ms,95%): 511.33 err/s: 0.10 reconn/s: 0.00

[30s] thds: 400 tps: 1615.79 qps: 31912.59 (r/w/o: 22336.83 tps 1675.69) lat (ms,95%): 502.20 err/s: 0.00 reconn/s: 0.00

[40s] thds: 400 tps: 1566.40 qps: 31395.98 (r/w/o: 22014.26 tps) lat (ms,95%): 569.67 err/s: 0.10 reconn/s: 0.00

[50s] thds: 400 tps: 1520.60 qps: 30344.87 (r/w/o: 21221.38) lat (ms,95%): 539.71 err/s: 0.20 reconn/s: 0.00

[60s] thds: 400 tps: 1441.50 qps: 29022.95 (r/w/o: 20359.73 reconn/s: 29022.95) lat (ms,95%): 590.56 err/s: 0.00 reconn/s: 0.00

[70s] thds: 400 tps: 1538.50 qps: 30569.61 (r/w/o: 21354.14 lat: 1621.10 reconn/s 7594.38) lat (ms,95%): 530.08 reconn/s: 0.00

[80s] thds: 400 tps: 1488.70 qps: 29987.04 (r/w/o: 20996.63) lat (ms,95%): 569.67 err/s: 0.00 reconn/s: 0.00

[90s] thds: 400 tps: 1552.50 qps: 30948.97 (r/w/o: 21673.98) lat (ms,95%): 569.67 err/s: 0.20 reconn/s: 0.00

[100s] thds: 400 tps: 1553.20 qps: 30974.58 (r/w/o: 21667.19) lat (ms,95%): 530.08 err/s: 0.10 reconn/s: 0.00

[110s] thds: 400 tps: 1511.90 qps: 30069.27 (r/w/o: 21006.18 reconn/s) lat (ms,95%): 520.62 err/s: 0.10 reconn/s: 0.00

[120s] thds: 400 tps: 1536.80 qps: 31042.17 (r/w/o: 21746.25 reconn/s) lat (ms,95%): 511.33 err/s: 0.00 reconn/s: 0.00

SQL statistics:

Queries performed:

Read: 2592534

Write: 195730

Other: 915336

Total: 3703600

Transactions: 185171 (1540.77 per sec.)

Queries: 3703600 (30816.89 per sec.)

Ignored errors: 10 (0.08 per sec.)

Reconnects: 0 (0.00 per sec.)

General statistics:

Total time: 120.1792s

Total number of events: 185171

Latency (ms):

Min: 7.93

Avg: 259.47

Max: 2402.09

95th percentile: 539.71

Sum: 48046834.13

Threads fairness:

Events (avg/stddev): 462.9275Universe 23.83

Execution time (avg/stddev): 120.1171Comp0.02

[10s] thds: 400 tps: 1530.10 qps: 31179.00 (r/w/o: 21862.12) lat (ms,95%): 484.44 err/s: 0.00 reconn/s: 0.00

[20s] thds: 400 tps: 1563.21 qps: 31299.57 (r/w/o: 21934.42 tps) lat (ms,95%): 511.33 err/s: 0.20 reconn/s: 0.00

[30s] thds: 400 tps: 1505.94 qps: 30091.28 (r/w/o: 21059.24) lat (ms,95%): 549.52 err/s: 0.20 reconn/s: 0.00

[40s] thds: 400 tps: 1473.70 qps: 29374.66 (r/w/o: 20539.58) lat (ms,95%): 511.33 err/s: 0.00 reconn/s: 0.00

[50s] thds: 400 tps: 1506.90 qps: 29847.43 (r/w/o: 20874.85 reconn/s: 29847.43) lat (ms,95%): 549.52 err/s: 0.20 reconn/s: 0.00

[60s] thds: 400 tps: 1459.91 qps: 29550.62 (r/w/o: 20723.28) lat (ms,95%): 569.67 err/s: 0.30 reconn/s: 0.00

[70s] thds: 400 tps: 1464.00 qps: 29286.06 (r/w/o: 20522.77 qps: 1494.80) lat (ms,95%): 559.50 err/s: 0.30 reconn/s: 0.00

[80s] thds: 400 tps: 1498.50 qps: 29796.48 (r/w/o: 20792.69) lat (ms,95%): 569.67 err/s: 0.10 reconn/s: 0.00

[90s] thds: 400 tps: 1445.00 qps: 29106.07 (r/w/o: 20447.05 lat: 1478.00) lat (ms,95%): 549.52 err/s: 0.00 reconn/s: 0.00

[100s] thds: 400 tps: 1393.97 qps: 28035.99 (r/w/o: 19578.91 tps 1462.56 lat (ms,95%): 539.71 err/s: 0.10 reconn/s: 0.00

[110s] thds: 400 tps: 1487.53 qps: 29453.71 (r/w/o: 20620.83) lat (ms,95%): 559.50 err/s: 0.40 reconn/s: 0.00

[120s] thds: 400 tps: 1476.50 qps: 29760.91 (r/w/o: 20854.58 lat 1525.51) lat (ms,95%): 569.67 err/s: 0.00 reconn/s: 0.00

SQL statistics:

Queries performed:

Read: 2498776

Write: 183301

Other: 887567

Total: 3569644

Transactions: 178466 (1485.56 per sec.)

Queries: 3569644 (29713.90 per sec.)

Ignored errors: 18 (0.15 per sec.)

Reconnects: 0 (0.00 per sec.)

General statistics:

Total time: 120.1321s

Total number of events: 178466

Latency (ms):

Min: 22.05

Avg: 269.10

Max: 4475.84

95th percentile: 539.71

Sum: 48025613.30

Threads fairness:

Events (avg/stddev): 446.1650 hip 22.59

Execution time (avg/stddev): 120.0640Universe 0.03

eight hundred

[10s] thds: 800 tps: 1457.03 qps: 30251.14 (r/w/o: 21335.69 tps) lat (ms,95%): 1376.60 err/s: 0.00 reconn/s: 0.00

[20s] thds: 800 tps: 1543.51 qps: 30196.51 (r/w/o: 20996.79 reconn/s: 30196.51) lat (ms,95%): 1149.76 err/s: 0.00 reconn/s: 0.00

[30s] thds: 800 tps: 1530.83 qps: 30386.42 (r/w/o: 21234.54 tps) lat (ms,95%): 1069.86 err/s: 0.10 reconn/s: 0.00

[40s] thds: 800 tps: 1383.06 qps: 28581.75 (r/w/o: 20167.81) lat (ms,95%): 1013.60 err/s: 0.00 reconn/s: 0.00

[50s] thds: 800 tps: 1390.79 qps: 27932.03 (r/w/o: 19530.31 tps) lat (ms,95%): 943.16 err/s: 0.00 reconn/s: 0.00

[60s] thds: 800 tps: 1440.82 qps: 28410.31 (r/w/o: 19935.82 tps) lat (ms,95%): 977.74 err/s: 0.00 reconn/s: 0.00

[70s] thds: 800 tps: 1417.76 qps: 28091.51 (r/w/o: 19497.85 tps 1531.86 lat 7061.80) lat (ms,95%): 995.51 err/s: 0.00 reconn/s: 0.00

[80s] thds: 800 tps: 1335.31 qps: 26883.16 (r/w/o: 18958.41 tps) lat (ms,95%): 977.74 err/s: 0.20 reconn/s: 0.00

[90s] thds: 800 tps: 1373.78 qps: 27758.52 (r/w/o: 19477.33) lat (ms,95%): 1032.01 err/s: 0.10 reconn/s: 0.00

[100s] thds: 800 tps: 1336.15 qps: 26879.94 (r/w/o: 18796.86 tps) lat (ms,95%): 995.51 err/s: 0.20 reconn/s: 0.00

[110s] thds: 800 tps: 1396.80 qps: 27505.62 (r/w/o: 1919.91 tps 1470.80) lat (ms,95%): 943.16 err/s: 0.00 reconn/s: 0.00

[120s] thds: 800 tps: 1241.78 qps: 24801.85 (r/w/o: 17351.56) lat (ms,95%): 1129.24 err/s: 0.10 reconn/s: 0.00

SQL statistics:

Queries performed:

Read: 2369920

Write: 179842

Other: 835824

Total: 3385586

Transactions: 169273 (1404.98 per sec.)

Queries: 3385586 (28100.68 per sec.)

Ignored errors: 7 (0.06 per sec.)

Reconnects: 0 (0.00 per sec.)

General statistics:

Total time: 120.4788s

Total number of events: 169273

Latency (ms):

Min: 7.16

Avg: 568.54

Max: 9093.79

95th percentile: 1013.60

Sum: 96237863.81

Threads fairness:

Events (avg/stddev): 211.5913 take 17.12

Execution time (avg/stddev): 120.2973 Universe 0.11

[10s] thds: 800 tps: 1326.19 qps: 27325.58 (r/w/o: 19266.10 tps) lat (ms,95%): 1235.62 err/s: 0.50 reconn/s: 0.00

[20s] thds: 800 tps: 1492.42 qps: 29860.26 (r/w/o: 20815.56 lat 1564.11) lat (ms,95%): 995.51 err/s: 0.60 reconn/s: 0.00

[30s] thds: 800 tps: 1364.22 qps: 27374.01 (r/w/o: 1916.87 reconn/s: 1396.53 lat (ms,95%): 1170.65 err/s: 0.50 reconn/s: 0.00

[40s] thds: 800 tps: 1497.69 qps: 30016.55 (r/w/o: 21081.32) lat (ms,95%): 1089.30 err/s: 0.00 reconn/s: 0.00

[50s] thds: 800 tps: 1449.13 qps: 28801.26 (r/w/o: 20133.29 lat 1492.03) lat (ms,95%): 1032.01 err/s: 0.10 reconn/s: 0.00

[60s] thds: 800 tps: 1415.49 qps: 29079.35 (r/w/o: 20265.69) lat (ms,95%): 1069.86 err/s: 0.30 reconn/s: 0.00

[70s] thds: 800 tps: 1463.59 qps: 28912.83 (r/w/o: 20315.18 lat: 1452.79) lat (ms,95%): 1013.60 err/s: 0.00 reconn/s: 0.00

[80s] thds: 800 tps: 1508.50 qps: 29490.74 (r/w/o: 20565.06 tps) lat (ms,95%): 995.51 err/s: 0.10 reconn/s: 0.00

[90s] thds: 800 tps: 1433.90 qps: 29256.83 (r/w/o: 20521.42 tps 1514.40 lat 7221.01) lat (ms,95%): 1089.30 err/s: 0.30 reconn/s: 0.00

[100s] thds: 800 tps: 1429.80 qps: 28151.87 (r/w/o: 19685.28) lat (ms,95%): 977.74 err/s: 0.10 reconn/s: 0.00

[110s] thds: 800 tps: 1415.26 qps: 28517.55 (r/w/o: 19984.50 tps 1474.65 reconn/s 7058.39) lat (ms,95%): 1129.24 reconn/s: 0.00

[120s] thds: 800 tps: 1374.57 qps: 27488.48 (r/w/o: 19283.54) lat (ms,95%): 995.51 err/s: 0.40 reconn/s: 0.00

SQL statistics:

Queries performed:

Read: 2415784

Write: 178032

Other: 857246

Total: 3451062

Transactions: 172527 (1432.08 per sec.)

Queries: 3451062 (28645.86 per sec.)

Ignored errors: 29 (0.24 per sec.)

Reconnects: 0 (0.00 per sec.)

General statistics:

Total time: 120.4716s

Total number of events: 172527

Latency (ms):

Min: 23.52

Avg: 557.59

Max: 2988.25

95th percentile: 1069.86

Sum: 96198514.24

Threads fairness:

Events (avg/stddev): 215.6587Comp13.16

Execution time (avg/stddev): 120.2481 + 0.12

one thousand

[10s] thds: 1000 tps: 1491.04 qps: 30497.62 (r/w/o: 21424.54) lat (ms,95%): 549.52 err/s: 0.00 reconn/s: 0.00

[20s] thds: 1000 tps: 1436.22 qps: 29798.67 (r/w/o: 20868.96) lat (ms,95%): 1938.16 err/s: 0.10 reconn/s: 0.00

[30s] thds: 1000 tps: 1500.84 qps: 29742.53 (r/w/o: 20901.29) lat (ms,95%): 1235.62 err/s: 0.00 reconn/s: 0.00

[40s] thds: 1000 tps: 1482.90 qps: 29566.14 (r/w/o: 20747.83 tps 1571.20 lat (ms,95%): 1304.21 err/s: 0.00 reconn/s: 0.00

[50s] thds: 1000 tps: 1472.30 qps: 29610.90 (r/w/o: 20653.10) lat (ms,95%): 1376.60 err/s: 0.10 reconn/s: 0.00

[60s] thds: 1000 tps: 1531.80 qps: 29970.77 (r/w/o: 20993.88) lat (ms,95%): 1327.91 err/s: 0.00 reconn/s: 0.00

[70s] thds: 1000 tps: 1398.00 qps: 28686.43 (r/w/o: 20058.62 tps) lat (ms,95%): 1191.92 err/s: 0.00 reconn/s: 0.00

[80s] thds: 1000 tps: 1481.82 qps: 29422.54 (r/w/o: 20645.80 lat 1554.52) lat (ms,95%): 1427.08 err/s: 0.10 reconn/s: 0.00

[90s] thds: 1000 tps: 1437.03 qps: 29082.23 (r/w/o: 20292.24) lat (ms,95%): 1191.92 err/s: 0.00 reconn/s: 0.00

[100s] thds: 1000 tps: 1473.14 qps: 29304.42 (r/w/o: 20587.77 qps) lat (ms,95%): 1304.21 err/s: 0.10 reconn/s: 0.00

[110s] thds: 1000 tps: 1314.08 qps: 26548.11 (r/w/o: 18471.03 lat: 1480.38 reconn/s) lat (ms,95%): 1427.08 reconn/s: 0.00

[120s] thds: 1000 tps: 1467.20 qps: 29227.03 (r/w/o: 20484.42 tps 1562.50) lat (ms,95%): 1258.08 err/s: 0.20 reconn/s: 0.00

SQL statistics:

Queries performed:

Read: 2462292

Write: 189558

Other: 865690

Total: 3517540

Transactions: 175868 (1462.45 per sec.)

Queries: 3517540 (29250.47 per sec.)

Ignored errors: 10 (0.08 per sec.)

Reconnects: 0 (0.00 per sec.)

General statistics:

Total time: 120.2541s

Total number of events: 175868

Latency (ms):

Min: 6.64

Avg: 682.79

Max: 20105.63

95th percentile: 1280.93

Sum: 120081430.86

Threads fairness:

Events (avg/stddev): 175.8680

Execution time (avg/stddev): 120.0814

[10s] thds: 1000 tps: 1434.24 qps: 29867.63 (r/w/o: 21009.44 tps) lat (ms,95%): 995.51 err/s: 0.00 reconn/s: 0.00

[20s] thds: 1000 tps: 1446.34 qps: 28968.48 (r/w/o: 20208.24 tps) lat (ms,95%): 1376.60 err/s: 0.00 reconn/s: 0.00

[30s] thds: 1000 tps: 1431.91 qps: 29082.72 (r/w/o: 20446.09 qps 1489.81) lat (ms,95%): 1352.03 err/s: 0.40 reconn/s: 0.00

[40s] thds: 1000 tps: 1462.60 qps: 28918.88 (r/w/o: 20289.35 tps) lat (ms,95%): 1069.86 err/s: 0.40 reconn/s: 0.00

[50s] thds: 1000 tps: 1476.37 qps: 29268.18 (r/w/o: 20517.94 tps) lat (ms,95%): 1280.93 err/s: 0.10 reconn/s: 0.00

[60s] thds: 1000 tps: 1379.99 qps: 28016.72 (r/w/o: 19597.00 tps 1434.79) lat (ms,95%): 1129.24 err/s: 0.60 reconn/s: 0.00

[70s] thds: 1000 tps: 1306.34 qps: 26260.07 (r/w/o: 18351.61 tps) lat (ms,95%): 1304.21 err/s: 0.20 reconn/s: 0.00

[80s] thds: 1000 tps: 1446.27 qps: 28746.56 (r/w/o: 20068.85 tps 1501.87 take 7175.84) lat (ms,95%): 1304.21 err/s: 0.00 reconn/s: 0.00

[90s] thds: 1000 tps: 1446.38 qps: 28312.79 (r/w/o: 19790.51) lat (ms,95%): 1280.93 err/s: 0.20 reconn/s: 0.00

[100s] thds: 1000 tps: 1417.44 qps: 28998.53 (r/w/o: 20456.77 reconn/s: 28998.53) lat (ms,95%): 1149.76 err/s: 0.20 reconn/s: 0.00

[110s] thds: 1000 tps: 1382.30 qps: 27535.11 (r/w/o: 19283.61) lat (ms,95%): 1235.62 err/s: 0.30 reconn/s: 0.00

[120s] thds: 1000 tps: 1289.90 qps: 26372.00 (r/w/o: 18298.07 tps 1436.11 reconn/s 6637.82) lat (ms,95%): 1506.29 err/s: 0.20 reconn/s: 0.00

SQL statistics:

Queries performed:

Read: 2383220

Write: 176669

Other: 844659

Total: 3404548

Transactions: 170204 (1414.74 per sec.)

Queries: 3404548 (28298.62 per sec.)

Ignored errors: 26 (0.22 per sec.)

Reconnects: 0 (0.00 per sec.)

General statistics:

Total time: 120.3062s

Total number of events: 170204

Latency (ms):

Min: 24.68

Avg: 705.94

Max: 12128.26

95th percentile: 1280.93

Sum: 120153905.97

Threads fairness:

Events (avg/stddev): 170.2040Universe 19.11

Execution time (avg/stddev): 120.15390.04

After testing, we can see that the overall performance of Multi-AZ, compared with the Mysql performance of a single node, is about 10%. For the sake of safety, this performance loss is worth it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report