In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.