######################################## Tests below are executed against MariaDB 10.5.8 on Tue Nov 24 13:23:18 PKT 2020 with bench.sh version 1.7 Note: 3600 seconds. 25 and 45 parallel threads ######################################## wsrep-statistics are flushed before each round. ### MariaDB 10.5.8, Round 1/2 with 25 parallel threads, 5 tables and 1000000 records on each. ### sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2) Running the test with following options: Number of threads: 25 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 540967630 write: 154562180 other: 77281090 total: 772810900 transactions: 38640545 (10733.47 per sec.) queries: 772810900 (214669.43 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 3600.0028s total number of events: 38640545 Latency (ms): min: 1.40 avg: 2.33 max: 871.49 95th percentile: 3.02 sum: 89943180.44 Threads fairness: events (avg/stddev): 1545621.8000/2439.38 execution time (avg/stddev): 3597.7272/0.02 ######################################################### ## Queues after 25 parallel threads, 5 tables and 1000000 records on each: ######################################################### ######################################################### ### MariaDB 10.5.8, Round 1/2 completed with 25 parallel threads, 5 tables and 1000000 records on each tables! ### ### MariaDB 10.5.8, Round 2/2 with 45 parallel threads, 5 tables and 1000000 records on each. ### sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2) Running the test with following options: Number of threads: 45 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 669753196 write: 191358054 other: 95679027 total: 956790277 transactions: 47839513 (13288.72 per sec.) queries: 956790277 (265774.34 per sec.) ignored errors: 1 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 3600.0082s total number of events: 47839513 Latency (ms): min: 1.41 avg: 3.38 max: 1346.52 95th percentile: 5.37 sum: 161925932.60 Threads fairness: events (avg/stddev): 1063100.2889/1588.58 execution time (avg/stddev): 3598.3541/0.01 ######################################################### ## Queues after 45 parallel threads, 5 tables and 1000000 records on each: ######################################################### ######################################################### ### MariaDB 10.5.8, Round 2/2 completed with 45 parallel threads, 5 tables and 1000000 records on each tables! ### Test duration 7326 seconds. ######################################## TEST FINISHED for MariaDB 10.5.8 ########################################