[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



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

Initializing worker threads...

Creating table 'sbtest3'...
Creating table 'sbtest2'...
Creating table 'sbtest5'...
Creating table 'sbtest1'...
Creating table 'sbtest10'...
Creating table 'sbtest7'...
Creating table 'sbtest8'...
Creating table 'sbtest4'...
Creating table 'sbtest6'...
Creating table 'sbtest9'...
Inserting 100000 records into 'sbtest3'
Inserting 100000 records into 'sbtest2'
Inserting 100000 records into 'sbtest1'
Inserting 100000 records into 'sbtest5'
Inserting 100000 records into 'sbtest10'
Inserting 100000 records into 'sbtest7'
Inserting 100000 records into 'sbtest8'
Inserting 100000 records into 'sbtest4'
Inserting 100000 records into 'sbtest6'
Inserting 100000 records into 'sbtest9'
Creating a secondary index on 'sbtest3'...
Creating a secondary index on 'sbtest7'...
Creating a secondary index on 'sbtest2'...
Creating a secondary index on 'sbtest5'...
Creating a secondary index on 'sbtest10'...
Creating a secondary index on 'sbtest8'...
Creating a secondary index on 'sbtest6'...
Creating a secondary index on 'sbtest4'...
Creating a secondary index on 'sbtest1'...
Creating a secondary index on 'sbtest9'...
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:                            13412
        write:                           3832
        other:                           1916
        total:                           19160
    transactions:                        958    (94.34 per sec.)
    queries:                             19160  (1886.79 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          10.1507s
    total number of events:              958

Latency (ms):
         min:                                 17.01
         avg:                                168.20
         max:                               1194.95
         95th percentile:                    211.60
         sum:                             161137.10

Threads fairness:
    events (avg/stddev):           59.8750/0.70
    execution time (avg/stddev):   10.0711/0.05

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:                            14756
        write:                           4216
        other:                           2108
        total:                           21080
    transactions:                        1054   (103.97 per sec.)
    queries:                             21080  (2079.32 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          10.1352s
    total number of events:              1054

Latency (ms):
         min:                                 15.78
         avg:                                152.80
         max:                                333.53
         95th percentile:                    211.60
         sum:                             161056.25

Threads fairness:
    events (avg/stddev):           65.8750/0.70
    execution time (avg/stddev):   10.0660/0.04

