sysbench 1.0.20 (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: 4650.73 qps: 27914.86 (r/w/o: 0.00/14240.33/13674.53) lat (ms,95%): 9.39 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 32 tps: 4619.79 qps: 27718.93 (r/w/o: 0.00/14166.57/13552.37) lat (ms,95%): 9.39 err/s: 0.00 reconn/s: 0.00
[ 30s ] thds: 32 tps: 4620.43 qps: 27722.37 (r/w/o: 0.00/14149.39/13572.98) lat (ms,95%): 9.39 err/s: 0.00 reconn/s: 0.00
[ 40s ] thds: 32 tps: 4626.89 qps: 27760.75 (r/w/o: 0.00/14180.07/13580.67) lat (ms,95%): 9.39 err/s: 0.00 reconn/s: 0.00
[ 50s ] thds: 32 tps: 4577.29 qps: 27463.86 (r/w/o: 0.00/14045.58/13418.28) lat (ms,95%): 9.56 err/s: 0.00 reconn/s: 0.00
[ 60s ] thds: 32 tps: 4612.60 qps: 27675.70 (r/w/o: 0.00/14141.00/13534.70) lat (ms,95%): 9.39 err/s: 0.00 reconn/s: 0.00
SQL statistics:
    queries performed:
        read:                            0
        write:                           849299
        other:                           813403
        total:                           1662702
    transactions:                        277117 (4617.52 per sec.)
    queries:                             1662702 (27705.11 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          60.0128s
    total number of events:              277117

Latency (ms):
         min:                                    2.71
         avg:                                    6.93
         max:                                   39.01
         95th percentile:                        9.39
         sum:                              1919723.51

Threads fairness:
    events (avg/stddev):           8659.9062/28.59
    execution time (avg/stddev):   59.9914/0.00

sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)

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


Initializing worker threads...

Threads started!

[ 10s ] thds: 64 tps: 7520.44 qps: 45144.65 (r/w/o: 0.00/23113.05/22031.59) lat (ms,95%): 12.08 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 64 tps: 7010.32 qps: 42063.64 (r/w/o: 0.00/21583.07/20480.57) lat (ms,95%): 14.73 err/s: 0.00 reconn/s: 0.00
[ 30s ] thds: 64 tps: 6294.20 qps: 37763.60 (r/w/o: 0.00/19362.00/18401.60) lat (ms,95%): 21.89 err/s: 0.00 reconn/s: 0.00
[ 40s ] thds: 64 tps: 6188.44 qps: 37127.62 (r/w/o: 0.00/19078.81/18048.80) lat (ms,95%): 24.38 err/s: 0.00 reconn/s: 0.00
[ 50s ] thds: 64 tps: 7069.86 qps: 42421.26 (r/w/o: 0.00/21804.17/20617.08) lat (ms,95%): 14.73 err/s: 0.00 reconn/s: 0.00
[ 60s ] thds: 64 tps: 7769.94 qps: 46615.01 (r/w/o: 0.00/23941.13/22673.88) lat (ms,95%): 11.24 err/s: 0.00 reconn/s: 0.00
SQL statistics:
    queries performed:
        read:                            0
        write:                           1289001
        other:                           1222719
        total:                           2511720
    transactions:                        418620 (6974.44 per sec.)
    queries:                             2511720 (41846.64 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          60.0206s
    total number of events:              418620

Latency (ms):
         min:                                    2.96
         avg:                                    9.17
         max:                                  294.62
         95th percentile:                       15.55
         sum:                              3839773.62

Threads fairness:
    events (avg/stddev):           6540.9375/27.99
    execution time (avg/stddev):   59.9965/0.01

[admin@ob1 ob6]$ sysbench /usr/local/share/sysbench/oltp_write_only.lua \
> --mysql-host=10.55.196.35 \
> --mysql-port=2883 \
> --mysql-user=root@t_mysql \
> --mysql-password=WelCome__pass4 \
> --mysql-db=tpcc \
> --report-interval=10 \
> --threads=128 \
> --tables=30 \
> --table-size=1000000 \
> --time=60 \
> --rand-type=uniform \
> --db-ps-mode=disable \
> run
sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)

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


Initializing worker threads...

Threads started!

[ 10s ] thds: 128 tps: 11565.35 qps: 69436.25 (r/w/o: 0.00/35963.17/33473.08) lat (ms,95%): 15.55 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 128 tps: 11173.10 qps: 67045.80 (r/w/o: 0.00/34728.81/32316.99) lat (ms,95%): 16.71 err/s: 0.00 reconn/s: 0.00
[ 30s ] thds: 128 tps: 10661.76 qps: 63964.09 (r/w/o: 0.00/33176.18/30787.91) lat (ms,95%): 18.95 err/s: 0.00 reconn/s: 0.00
[ 40s ] thds: 128 tps: 11044.78 qps: 66268.37 (r/w/o: 0.00/34329.94/31938.42) lat (ms,95%): 16.12 err/s: 0.00 reconn/s: 0.00
[ 50s ] thds: 128 tps: 11226.08 qps: 67364.40 (r/w/o: 0.00/34994.35/32370.05) lat (ms,95%): 16.12 err/s: 0.00 reconn/s: 0.00
[ 60s ] thds: 128 tps: 11190.11 qps: 67112.58 (r/w/o: 0.00/34923.22/32189.37) lat (ms,95%): 16.41 err/s: 0.00 reconn/s: 0.00
SQL statistics:
    queries performed:
        read:                            0
        write:                           2081715
        other:                           1931283
        total:                           4012998
    transactions:                        668833 (11140.48 per sec.)
    queries:                             4012998 (66842.85 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          60.0348s
    total number of events:              668833

Latency (ms):
         min:                                    2.89
         avg:                                   11.48
         max:                                  354.69
         95th percentile:                       16.41
         sum:                              7680251.38

Threads fairness:
    events (avg/stddev):           5225.2578/20.80
    execution time (avg/stddev):   60.0020/0.01


[admin@ob1 ob6]$ sysbench /usr/local/share/sysbench/oltp_write_only.lua \
> --mysql-host=10.55.196.35 \
> --mysql-port=2883 \
> --mysql-user=root@t_mysql \
> --mysql-password=WelCome__pass4 \
> --mysql-db=tpcc \
> --report-interval=10 \
> --threads=256 \
> --tables=30 \
> --table-size=1000000 \
> --time=60 \
> --rand-type=uniform \
> --db-ps-mode=disable \
> run
sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)

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


Initializing worker threads...

Threads started!

[ 10s ] thds: 256 tps: 14451.24 qps: 86798.14 (r/w/o: 0.00/45173.87/41624.27) lat (ms,95%): 27.66 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 256 tps: 14601.44 qps: 87607.77 (r/w/o: 0.00/45635.34/41972.43) lat (ms,95%): 27.17 err/s: 0.00 reconn/s: 0.00
[ 30s ] thds: 256 tps: 14687.23 qps: 88121.87 (r/w/o: 0.00/45997.40/42124.47) lat (ms,95%): 26.68 err/s: 0.00 reconn/s: 0.00
[ 40s ] thds: 256 tps: 10937.79 qps: 65631.14 (r/w/o: 0.00/34326.87/31304.27) lat (ms,95%): 45.79 err/s: 0.00 reconn/s: 0.00
[ 50s ] thds: 256 tps: 5339.63 qps: 32027.96 (r/w/o: 0.00/16745.10/15282.86) lat (ms,95%): 227.40 err/s: 0.00 reconn/s: 0.00
[ 60s ] thds: 256 tps: 10946.11 qps: 65647.08 (r/w/o: 0.00/34357.74/31289.34) lat (ms,95%): 51.94 err/s: 0.00 reconn/s: 0.00
SQL statistics:
    queries performed:
        read:                            0
        write:                           2223549
        other:                           2037075
        total:                           4260624
    transactions:                        710104 (11809.05 per sec.)
    queries:                             4260624 (70854.28 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          60.1307s
    total number of events:              710104

Latency (ms):
         min:                                    2.80
         avg:                                   21.63
         max:                                  613.39
         95th percentile:                       36.24
         sum:                             15362774.86

Threads fairness:
    events (avg/stddev):           2773.8438/31.32
    execution time (avg/stddev):   60.0108/0.02