######################################## Tests below are executed against MariaDB 10.5.6 on Tue Nov 24 14:13:48 PKT 2020 with bench.sh version 1.7 Note: mariadb_require_test ######################################## wsrep-statistics are flushed before each round. ### MariaDB 10.5.6, 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: 564942882 write: 161412252 other: 80706126 total: 807061260 transactions: 40353063 (11209.16 per sec.) queries: 807061260 (224183.24 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 3600.0053s total number of events: 40353063 Latency (ms): min: 1.39 avg: 2.23 max: 441.00 95th percentile: 2.76 sum: 89945586.37 Threads fairness: events (avg/stddev): 1614122.5200/4487.53 execution time (avg/stddev): 3597.8235/0.02 ######################################################### ## Queues after 25 parallel threads, 5 tables and 1000000 records on each: ######################################################### ######################################################### ### MariaDB 10.5.6, Round 1/2 completed with 25 parallel threads, 5 tables and 1000000 records on each tables! ### ### MariaDB 10.5.6, 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: 692526632 write: 197864752 other: 98932376 total: 989323760 transactions: 49466188 (13740.57 per sec.) queries: 989323760 (274811.47 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 3600.0072s total number of events: 49466188 Latency (ms): min: 1.40 avg: 3.27 max: 165.37 95th percentile: 5.57 sum: 161921431.29 Threads fairness: events (avg/stddev): 1099248.6222/1791.36 execution time (avg/stddev): 3598.2540/0.02 ######################################################### ## Queues after 45 parallel threads, 5 tables and 1000000 records on each: ######################################################### ######################################################### ### MariaDB 10.5.6, Round 2/2 completed with 45 parallel threads, 5 tables and 1000000 records on each tables! ### Test duration 7325 seconds. ######################################## TEST FINISHED for MariaDB 10.5.6 ########################################