[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