用sysbench压测mysql、postgresql（蟑螂db）对比

mysql：

准备创建表和数据：
sysbench --db-driver=mysql --time=10 --threads=10 --report-interval=1 --mysql-host=172.18.44.84 --mysql-port=7999 --mysql-user=zl --mysql-password=zl123 --mysql-db=test_db --tables=10 --table_size=100000 oltp_read_write --db-ps-mode=disable prepare

测试数据库的综合读写TPS，使用的是oltp_read_write模式（大家看命令中最后不是prepare，是run了，就是运行压测）：
sysbench --db-driver=mysql --time=10 --threads=10 --report-interval=1 --mysql-host=172.18.44.84 --mysql-port=7999 --mysql-user=zl --mysql-password=zl123 --mysql-db=test_db --tables=10 --table_size=100000 oltp_read_write --db-ps-mode=disable run

[ 1s ] thds: 10 tps: 299.82 qps: 6067.15 (r/w/o: 4258.26/1199.29/609.60) lat (ms,95%): 36.89 err/s: 0.00 reconn/s: 0.00
[ 2s ] thds: 10 tps: 77.04 qps: 1644.77 (r/w/o: 1146.54/344.16/154.07) lat (ms,95%): 363.18 err/s: 0.00 reconn/s: 0.00
[ 3s ] thds: 10 tps: 133.00 qps: 2617.95 (r/w/o: 1851.97/499.99/266.00) lat (ms,95%): 219.36 err/s: 0.00 reconn/s: 0.00
[ 4s ] thds: 10 tps: 94.03 qps: 1842.57 (r/w/o: 1274.39/380.12/188.06) lat (ms,95%): 363.18 err/s: 0.00 reconn/s: 0.00
[ 5s ] thds: 10 tps: 170.95 qps: 3514.04 (r/w/o: 2456.33/715.81/341.91) lat (ms,95%): 369.77 err/s: 0.00 reconn/s: 0.00
[ 6s ] thds: 10 tps: 80.02 qps: 1576.31 (r/w/o: 1120.22/296.06/160.03) lat (ms,95%): 376.49 err/s: 0.00 reconn/s: 0.00
[ 7s ] thds: 10 tps: 136.95 qps: 2738.95 (r/w/o: 1909.27/555.79/273.89) lat (ms,95%): 308.84 err/s: 0.00 reconn/s: 0.00
[ 8s ] thds: 10 tps: 114.96 qps: 2310.16 (r/w/o: 1608.42/471.83/229.92) lat (ms,95%): 530.08 err/s: 0.00 reconn/s: 0.00
[ 9s ] thds: 10 tps: 91.03 qps: 1817.58 (r/w/o: 1271.41/364.12/182.06) lat (ms,95%): 200.47 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 10 tps: 142.97 qps: 2873.46 (r/w/o: 2013.62/573.89/285.95) lat (ms,95%): 211.60 err/s: 0.00 reconn/s: 0.00
SQL statistics:
    queries performed:
        read:                            18928
        write:                           5408
        other:                           2704
        total:                           27040
    transactions:                        1352   (134.86 per sec.)
    queries:                             27040  (2697.25 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          10.0217s
    total number of events:              1352

Latency (ms):
         min:                                   23.04
         avg:                                   74.04
         max:                                  803.40
         95th percentile:                      303.33
         sum:                               100106.79

Threads fairness:
    events (avg/stddev):           135.2000/4.33
    execution time (avg/stddev):   10.0107/0.01

测试数据库的只读性能，使用的是oltp_read_only模式（大家看命令中的oltp_read_write已经变为oltp_read_only了）：
sysbench --db-driver=mysql --time=10 --threads=10 --report-interval=1 --mysql-host=172.18.44.84 --mysql-port=7999 --mysql-user=zl --mysql-password=zl123 --mysql-db=test_db --tables=10 --table_size=100000 oltp_read_only --db-ps-mode=disable run

[ 1s ] thds: 10 tps: 895.83 qps: 14420.90 (r/w/o: 12619.29/0.00/1801.62) lat (ms,95%): 14.46 err/s: 0.00 reconn/s: 0.00
[ 2s ] thds: 10 tps: 841.11 qps: 13436.76 (r/w/o: 11754.54/0.00/1682.22) lat (ms,95%): 17.63 err/s: 0.00 reconn/s: 0.00
[ 3s ] thds: 10 tps: 875.01 qps: 14035.08 (r/w/o: 12285.07/0.00/1750.01) lat (ms,95%): 14.73 err/s: 0.00 reconn/s: 0.00
[ 4s ] thds: 10 tps: 874.00 qps: 13997.99 (r/w/o: 12249.99/0.00/1748.00) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00
[ 5s ] thds: 10 tps: 890.93 qps: 14247.83 (r/w/o: 12465.97/0.00/1781.85) lat (ms,95%): 12.08 err/s: 0.00 reconn/s: 0.00
[ 6s ] thds: 10 tps: 859.01 qps: 13736.23 (r/w/o: 12018.20/0.00/1718.03) lat (ms,95%): 15.83 err/s: 0.00 reconn/s: 0.00
[ 7s ] thds: 10 tps: 673.98 qps: 10796.65 (r/w/o: 9448.69/0.00/1347.96) lat (ms,95%): 23.95 err/s: 0.00 reconn/s: 0.00
[ 8s ] thds: 10 tps: 799.13 qps: 12775.15 (r/w/o: 11176.88/0.00/1598.27) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00
[ 9s ] thds: 10 tps: 932.92 qps: 14911.71 (r/w/o: 13045.87/0.00/1865.84) lat (ms,95%): 11.65 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 10 tps: 844.42 qps: 13532.65 (r/w/o: 11843.82/0.00/1688.83) lat (ms,95%): 11.65 err/s: 0.00 reconn/s: 0.00
SQL statistics:
    queries performed:
        read:                            119000
        write:                           0
        other:                           17000
        total:                           136000
    transactions:                        8500   (848.90 per sec.)
    queries:                             136000 (13582.34 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          10.0098s
    total number of events:              8500

Latency (ms):
         min:                                    6.46
         avg:                                   11.76
         max:                                  225.84
         95th percentile:                       15.00
         sum:                                99998.45

Threads fairness:
    events (avg/stddev):           850.0000/30.34
    execution time (avg/stddev):   9.9998/0.00

测试数据库的删除性能，使用的是oltp_delete模式：
sysbench --db-driver=mysql --time=10 --threads=10 --report-interval=1 --mysql-host=172.18.44.84 --mysql-port=7999 --mysql-user=zl --mysql-password=zl123 --mysql-db=test_db --tables=10 --table_size=100000 oltp_delete --db-ps-mode=disable run


[ 1s ] thds: 10 tps: 372.54 qps: 372.54 (r/w/o: 0.00/370.55/1.99) lat (ms,95%): 47.47 err/s: 0.00 reconn/s: 0.00
[ 2s ] thds: 10 tps: 331.17 qps: 331.17 (r/w/o: 0.00/323.17/8.00) lat (ms,95%): 38.25 err/s: 0.00 reconn/s: 0.00
[ 3s ] thds: 10 tps: 405.98 qps: 405.98 (r/w/o: 0.00/379.98/26.00) lat (ms,95%): 31.94 err/s: 0.00 reconn/s: 0.00
[ 4s ] thds: 10 tps: 388.00 qps: 388.00 (r/w/o: 0.00/354.00/34.00) lat (ms,95%): 36.24 err/s: 0.00 reconn/s: 0.00
[ 5s ] thds: 10 tps: 420.98 qps: 420.98 (r/w/o: 0.00/365.98/55.00) lat (ms,95%): 51.94 err/s: 0.00 reconn/s: 0.00
[ 6s ] thds: 10 tps: 403.03 qps: 403.03 (r/w/o: 0.00/348.02/55.00) lat (ms,95%): 41.10 err/s: 0.00 reconn/s: 0.00
[ 7s ] thds: 10 tps: 390.96 qps: 390.96 (r/w/o: 0.00/321.97/68.99) lat (ms,95%): 44.98 err/s: 0.00 reconn/s: 0.00
[ 8s ] thds: 10 tps: 394.05 qps: 394.05 (r/w/o: 0.00/318.04/76.01) lat (ms,95%): 55.82 err/s: 0.00 reconn/s: 0.00
[ 9s ] thds: 10 tps: 514.96 qps: 514.96 (r/w/o: 0.00/397.97/116.99) lat (ms,95%): 27.66 err/s: 0.00 reconn/s: 0