适用范围

操作系统版本：Red Hat Enterprise Linux Server release 7.9 (Maipo)
主机环境：虚拟机（8cpu,8g内存，100G磁盘，千兆网络）
数据库版本：MogDB 5.0.0 build 503a9ef7
数据库架构：一主两从

测试过程

1.测试1

[root@mogdb117 ~]# sysbench /usr/local/sysbencd_1.0/share/sysbench/tests/include/oltp_legacy/oltp.lua --oltp-read-only=on --db-driver=pgsql --pgsql-host=172.20.22.159 --pgsql-port=28000 --pgsql-user=tpcc_mogdb  --pgsql-password='Tpcc_mogdb@123'  --pgsql-db=tpccdb --threads=32 --time=60  --report-interval=10 run
sysbench 1.0.18 (using bundled LuaJIT 2.1.0-beta2)

Running the test with following options:
Number of threads: 32
Report intermediate results every 10 second(s)
Initializing random number generator from current time


Initializing worker threads...

Threads started!

[ 10s ] thds: 32 tps: 1612.80 qps: 25834.02 (r/w/o: 22605.22/0.00/3228.80) lat (ms,95%): 40.37 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 32 tps: 1612.42 qps: 25797.07 (r/w/o: 22572.24/0.00/3224.83) lat (ms,95%): 41.85 err/s: 0.00 reconn/s: 0.00
[ 30s ] thds: 32 tps: 1668.40 qps: 26694.76 (r/w/o: 23358.06/0.00/3336.71) lat (ms,95%): 40.37 err/s: 0.00 reconn/s: 0.00
[ 40s ] thds: 32 tps: 1659.20 qps: 26545.39 (r/w/o: 23227.19/0.00/3318.20) lat (ms,95%): 38.94 err/s: 0.00 reconn/s: 0.00
[ 50s ] thds: 32 tps: 1608.90 qps: 25744.30 (r/w/o: 22526.40/0.00/3217.90) lat (ms,95%): 40.37 err/s: 0.00 reconn/s: 0.00
[ 60s ] thds: 32 tps: 1601.10 qps: 25619.35 (r/w/o: 22417.06/0.00/3202.29) lat (ms,95%): 41.10 err/s: 0.00 reconn/s: 0.00
SQL statistics:
    queries performed:
        read:                            1367296
        write:                           0
        other:                           195328
        total:                           1562624
    transactions:                        97664  (1626.68 per sec.)
    queries:                             1562624 (26026.92 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          60.0367s
    total number of events:              97664

Latency (ms):
         min:                                    6.23
         avg:                                   19.66
         max:                                  399.30
         95th percentile:                       40.37
         sum:                              1920148.61

Threads fairness:
    events (avg/stddev):           3052.0000/407.44
    execution time (avg/stddev):   60.0046/0.01



复制

测试2

[root@mogdb117 ~]# sysbench  --db-driver=pgsql  --pgsql-host=172.20.22.159 --pgsql-port=28000  --pgsql-user=tpcc_mogdb --pgsql-password='Tpcc_mogdb@123'  --pgsql-db=tpccdb --oltp_tables_count=10 --oltp_table_size=100000 --num-threads=32 --report-interval=3 --max-time=60 --max-requests=0 --test=/usr/local/sysbencd_1.0/share/sysbench/tests/include/oltp_legacy/oltp.lua --percentile=95 --oltp-read-only=on  --oltp_range_size=100 --oltp_point_selects=8 --oltp_simple_ranges=2 --oltp_sum_ranges=0 --oltp_order_ranges=0 --oltp_distinct_ranges=0 --oltp_index_updates=0 --oltp_non_index_updates=0 --oltp_delete_inserts=0 run
WARNING: the --test option is deprecated. You can pass a script name or path on the command line without any options.
WARNING: --num-threads is deprecated, use --threads instead
WARNING: --max-time is deprecated, use --time instead
sysbench 1.0.18 (using bundled LuaJIT 2.1.0-beta2)

Running the test with following options:
Number of threads: 32
Report intermediate results every 3 second(s)
Initializing random number generator from current time


Initializing worker threads...

Threads started!

[ 3s ] thds: 32 tps: 2421.20 qps: 29123.66 (r/w/o: 24270.61/0.00/4853.06) lat (ms,95%): 28.16 err/s: 0.00 reconn/s: 0.00
[ 6s ] thds: 32 tps: 2560.03 qps: 30709.40 (r/w/o: 25590.66/0.00/5118.73) lat (ms,95%): 26.20 err/s: 0.00 reconn/s: 0.00
[ 9s ] thds: 32 tps: 2577.71 qps: 30943.57 (r/w/o: 25786.81/0.00/5156.76) lat (ms,95%): 25.74 err/s: 0.00 reconn/s: 0.00
[ 12s ] thds: 32 tps: 2638.94 qps: 31661.58 (r/w/o: 26383.71/0.00/5277.87) lat (ms,95%): 27.17 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 32 tps: 2649.01 qps: 31800.40 (r/w/o: 26502.39/0.00/5298.01) lat (ms,95%): 26.20 err/s: 0.00 reconn/s: 0.00
[ 18s ] thds: 32 tps: 2582.69 qps: 30975.24 (r/w/o: 25810.54/0.00/5164.71) lat (ms,95%): 27.66 err/s: 0.00 reconn/s: 0.00
[ 21s ] thds: 32 tps: 2603.97 qps: 31246.96 (r/w/o: 26040.02/0.00/5206.94) lat (ms,95%): 25.74 err/s: 0.00 reconn/s: 0.00
[ 24s ] thds: 32 tps: 2632.36 qps: 31588.64 (r/w/o: 26323.59/0.00/5265.05) lat (ms,95%): 24.38 err/s: 0.00 reconn/s: 0.00
[ 27s ] thds: 32 tps: 2654.89 qps: 31858.67 (r/w/o: 26547.90/0.00/5310.78) lat (ms,95%): 24.38 err/s: 0.00 reconn/s: 0.00
[ 30s ] thds: 32 tps: 2421.45 qps: 29066.03 (r/w/o: 24223.47/0.00/4842.56) lat (ms,95%): 26.68 err/s: 0.00 reconn/s: 0.00
[ 33s ] thds: 32 tps: 2619.31 qps: 31421.41 (r/w/o: 26182.79/0.00/5238.62) lat (ms,95%): 25.74 err/s: 0.00 reconn/s: 0.00
[ 36s ] thds: 32 tps: 2548.70 qps: 30595.72 (r/w/o: 25498.66/0.00/5097.06) lat (ms,95%): 27.17 err/s: 0.00 reconn/s: 0.00
[ 39s ] thds: 32 tps: 2596.96 qps: 31153.16 (r/w/o: 25959.58/0.00/5193.58) lat (ms,95%): 25.74 err/s: 0.00 reconn/s: 0.00
[ 42s ] thds: 32 tps: 2644.34 qps: 31735.10 (r/w/o: 26445.41/0.00/5289.68) lat (ms,95%): 24.83 err/s: 0.00 reconn/s: 0.00
[ 45s ] thds: 32 tps: 2606.31 qps: 31273.76 (r/w/o: 26061.46/0.00/5212.29) lat (ms,95%): 26.20 err/s: 0.00 reconn/s: 0.00
[ 48s ] thds: 32 tps: 2697.75 qps: 32377.01 (r/w/o: 26981.51/0.00/5395.50) lat (ms,95%): 23.95 err/s: 0.00 reconn/s: 0.00
[ 51s ] thds: 32 tps: 2659.28 qps: 31921.34 (r/w/o: 26602.78/0.00/5318.56) lat (ms,95%): 24.38 err/s: 0.00 reconn/s: 0.00
[ 54s ] thds: 32 tps: 2650.99 qps: 31808.58 (r/w/o: 26506.59/0.00/5301.99) lat (ms,95%): 24.83 err/s: 0.00 reconn/s: 0.00
[ 57s ] thds: 32 tps: 2636.34 qps: 31632.36 (r/w/o: 26359.36/0.00/5273.00) lat (ms,95%): 24.83 err/s: 0.00 reconn/s: 0.00
[ 60s ] thds: 32 tps: 2645.35 qps: 31752.53 (r/w/o: 26461.83/0.00/5290.70) lat (ms,95%): 25.28 err/s: 0.00 reconn/s: 0.00
SQL statistics:
    queries performed:
        read:                            1561800
        write:                           0
        other:                           312360
        total:                           1874160
    transactions:                        156180 (2601.69 per sec.)
    queries:                             1874160 (31220.24 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          60.0282s
    total number of events:              156180

Latency (ms):
         min:                                    3.92
         avg:                                   12.29
         max:                                  264.19
         95th percentile:                       25.74
         sum:                              1919800.92

Threads fairness:
    events (avg/stddev):           4880.6250/764.14
    execution time (avg/stddev):   59.9938/0.01

[root@mogdb117 ~]# 

复制

小结

测试1：tps是1.6k, avg是19.66ms
测试2：tps是2.6k, avg是12.29ms
同样的环境，sysbench参数的设置对应tps，avg影响还是比较大。