[mysqld]
datadir=/usr/local/mysql/var
server-id=1
wsrep_on=ON
wsrep_provider=/usr/local/mariadb-10.3.11-linux-systemd-x86_64/lib/galera/libgalera_smm.so
wsrep_cluster_name=test_cluster
wsrep_cluster_address=gcomm://192.168.23.15
wsrep_sst_method=rsync
wsrep_sst_auth=root
wsrep_node_address=192.168.23.15
wsrep_node_name=node-1
binlog-format=ROW

#log-bin
sync-binlog=0
innodb-flush-log-at-trx-commit=0


$ ./sysbench.sh 
sysbench 1.0.11 (using system LuaJIT 2.1.0-beta3)

Initializing worker threads...

Creating table 'sbtest2'...
Creating table 'sbtest9'...
Creating table 'sbtest3'...
Creating table 'sbtest6'...
Creating table 'sbtest8'...
Creating table 'sbtest10'...
Creating table 'sbtest4'...
Creating table 'sbtest7'...
Creating table 'sbtest1'...
Creating table 'sbtest5'...
Inserting 100000 records into 'sbtest2'
Inserting 100000 records into 'sbtest9'
Inserting 100000 records into 'sbtest3'
Inserting 100000 records into 'sbtest8'
Inserting 100000 records into 'sbtest6'
Inserting 100000 records into 'sbtest4'
Inserting 100000 records into 'sbtest10'
Inserting 100000 records into 'sbtest7'
Inserting 100000 records into 'sbtest1'
Inserting 100000 records into 'sbtest5'
Creating a secondary index on 'sbtest4'...
Creating a secondary index on 'sbtest10'...
Creating a secondary index on 'sbtest2'...
Creating a secondary index on 'sbtest6'...
Creating a secondary index on 'sbtest7'...
Creating a secondary index on 'sbtest9'...
Creating a secondary index on 'sbtest3'...
Creating a secondary index on 'sbtest1'...
Creating a secondary index on 'sbtest5'...
Creating a secondary index on 'sbtest8'...
sysbench 1.0.11 (using system LuaJIT 2.1.0-beta3)

Running the test with following options:
Number of threads: 16
Initializing random number generator from current time


Initializing worker threads...

Threads started!

SQL statistics:
    queries performed:
        read:                            42826
        write:                           12236
        other:                           6118
        total:                           61180
    transactions:                        3059   (304.80 per sec.)
    queries:                             61180  (6095.94 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          10.0348s
    total number of events:              3059

Latency (ms):
         min:                                  7.69
         avg:                                 52.38
         max:                                356.76
         95th percentile:                    153.02
         sum:                             160240.59

Threads fairness:
    events (avg/stddev):           191.1875/0.95
    execution time (avg/stddev):   10.0150/0.01

sysbench 1.0.11 (using system LuaJIT 2.1.0-beta3)

Running the test with following options:
Number of threads: 16
Initializing random number generator from current time


Initializing worker threads...

Threads started!

SQL statistics:
    queries performed:
        read:                            43988
        write:                           12568
        other:                           6284
        total:                           62840
    transactions:                        3142   (313.14 per sec.)
    queries:                             62840  (6262.70 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          10.0320s
    total number of events:              3142

Latency (ms):
         min:                                 17.40
         avg:                                 50.99
         max:                                274.44
         95th percentile:                    134.90
         sum:                             160211.43

Threads fairness:
    events (avg/stddev):           196.3750/0.93
    execution time (avg/stddev):   10.0132/0.01


