Performance differences between RDS Mysql Single-AZ and Multi-AZ
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.
