TPS by Thread Count - OLTP_RW

MDEV-39364 - updated config binlog

Comparison: TPS

ThreadsMariadb 11.8.6-MariaDB-logMariadb 12.3.1-MariaDB-logMariadb 13.0.0-MariaDB-log
4193.050162.807164.200
8341.000259.040257.987
16595.607391.850388.433
321051.137599.243600.590
644261.5231188.4871185.373
1287345.6206431.5535355.970

System Info (per dataset)

PropertyMariadb 11.8.6-MariaDB-logMariadb 12.3.1-MariaDB-logMariadb 13.0.0-MariaDB-log
Hosthz-bench-jebhz-bench-jebhz-bench-jeb
CPU13th Gen Intel(R) Core(TM) i5-1350013th Gen Intel(R) Core(TM) i5-1350013th Gen Intel(R) Core(TM) i5-13500
CPU Count202020
Core Count141414
Socket Count111
OSLinuxLinuxLinux
RAM62.33 GB62.33 GB62.33 GB
Diskunknownunknownunknown

Database Info (per dataset)

PropertyMariadb 11.8.6-MariaDB-logMariadb 12.3.1-MariaDB-logMariadb 13.0.0-MariaDB-log
Database Makermariadbmariadbmariadb
Database Version11.8.6-MariaDB-log12.3.1-MariaDB-log13.0.0-MariaDB-log
Engineinnodbinnodbinnodb
Install Dir/home/jeb/taf-perl/database_software_installs/mariadb-11.8.6-linux-systemd-x86_64/home/jeb/taf-perl/database_software_installs/mariadb-12.3.1-linux-systemd-x86_64/home/jeb/taf-perl/database_software_installs/mariadb-13.0.0-linux-systemd-x86_64
Config File/home/jeb/taf-perl/database_config_files/mariadb_cache_bin_log.cnf/home/jeb/taf-perl/database_config_files/mariadb_cache_bin_log.cnf/home/jeb/taf-perl/database_config_files/mariadb_cache_bin_log.cnf
Config Contentsinnodb_file_per_table=1
open_files_limit=65535
default_storage_engine=InnoDB
sync_master_info=0
performance_schema=OFF
sync_relay_log=0
innodb_flush_neighbors=0
innodb_buffer_pool_size=30G
innodb_flush_log_at_trx_commit=1
aria_sort_buffer_size=128M
innodb_write_io_threads=8
default_authentication_plugin=mysql_native_password
log_bin
innodb_read_io_threads=8
innodb_log_file_size=8G
innodb_compression_algorithm=none
innodb_default_row_format=dynamic
max_connections=200
sync_relay_log_info=0
collation_server=utf8mb4_general_ci
tls_version=TLSv1.2,TLSv1.3
table_open_cache=4000
innodb_io_capacity_max=4000
general_log=OFF
innodb_doublewrite=1
slow_query_log=OFF
character_set_server=utf8mb4
aria_pagecache_buffer_size=128M
sync_binlog=1
innodb_compression_level=0
thread_cache_size=128
innodb_undo_log_truncate=ON
innodb_io_capacity=2000
innodb_undo_tablespaces=2
innodb_flush_method=O_DIRECT		innodb_file_per_table=1
open_files_limit=65535
default_storage_engine=InnoDB
sync_master_info=0
performance_schema=OFF
sync_relay_log=0
innodb_flush_neighbors=0
innodb_buffer_pool_size=30G
innodb_flush_log_at_trx_commit=1
aria_sort_buffer_size=128M
innodb_write_io_threads=8
default_authentication_plugin=mysql_native_password
log_bin
innodb_read_io_threads=8
innodb_log_file_size=8G
innodb_compression_algorithm=none
innodb_default_row_format=dynamic
max_connections=200
sync_relay_log_info=0
collation_server=utf8mb4_general_ci
tls_version=TLSv1.2,TLSv1.3
table_open_cache=4000
innodb_io_capacity_max=4000
general_log=OFF
innodb_doublewrite=1
slow_query_log=OFF
character_set_server=utf8mb4
aria_pagecache_buffer_size=128M
sync_binlog=1
innodb_compression_level=0
thread_cache_size=128
innodb_undo_log_truncate=ON
innodb_io_capacity=2000
innodb_undo_tablespaces=2
innodb_flush_method=O_DIRECT		innodb_file_per_table=1
open_files_limit=65535
default_storage_engine=InnoDB
sync_master_info=0
performance_schema=OFF
sync_relay_log=0
innodb_flush_neighbors=0
innodb_buffer_pool_size=30G
innodb_flush_log_at_trx_commit=1
aria_sort_buffer_size=128M
innodb_write_io_threads=8
default_authentication_plugin=mysql_native_password
log_bin
innodb_read_io_threads=8
innodb_log_file_size=8G
innodb_compression_algorithm=none
innodb_default_row_format=dynamic
max_connections=200
sync_relay_log_info=0
collation_server=utf8mb4_general_ci
tls_version=TLSv1.2,TLSv1.3
table_open_cache=4000
innodb_io_capacity_max=4000
general_log=OFF
innodb_doublewrite=1
slow_query_log=OFF
character_set_server=utf8mb4
aria_pagecache_buffer_size=128M
sync_binlog=1
innodb_compression_level=0
thread_cache_size=128
innodb_undo_log_truncate=ON
innodb_io_capacity=2000
innodb_undo_tablespaces=2
innodb_flush_method=O_DIRECT

Test Info (per dataset)

PropertyMariadb 11.8.6-MariaDB-logMariadb 12.3.1-MariaDB-logMariadb 13.0.0-MariaDB-log
Test Suitesysbench-luasysbench-luasysbench-lua
Test NameOLTP_RWOLTP_RWOLTP_RW
Duration300300300
Iterations333
Db drivermariadbmariadbmariadb
Debug sysbenchfalsefalsefalse
Intermediate result222
Number of rows100000010000001000000
Number of tables888
Timestamp2026-4-24 13:51:232026-4-24 15:31:212026-4-24 17:11:05

Thread Count: 4

MetricMariadb 11.8.6-MariaDB-logMariadb 12.3.1-MariaDB-logMariadb 13.0.0-MariaDB-log
Mean193.05162.81164.20
Max203.66178.54179.58
Min176.89138.62142.76
StdDev11.6117.3615.63
CoV0.060.110.10
Median (p50)198.60171.26170.26
p95203.15177.81178.65
p99203.56178.39179.39
Skewness-0.61-0.61-0.52
Iteration 1176.89138.62142.76
Iteration 2198.60171.26170.26
Iteration 3203.66178.54179.58

Thread Count: 8

MetricMariadb 11.8.6-MariaDB-logMariadb 12.3.1-MariaDB-logMariadb 13.0.0-MariaDB-log
Mean341.00259.04257.99
Max342.73262.47261.35
Min339.78254.78254.53
StdDev1.263.192.79
CoV0.000.010.01
Median (p50)340.49259.87258.08
p95342.51262.21261.02
p99342.69262.42261.28
Skewness0.54-0.37-0.05
Iteration 1339.78254.78254.53
Iteration 2340.49259.87258.08
Iteration 3342.73262.47261.35

Thread Count: 16

MetricMariadb 11.8.6-MariaDB-logMariadb 12.3.1-MariaDB-logMariadb 13.0.0-MariaDB-log
Mean595.61391.85388.43
Max618.83395.02391.39
Min555.76388.18386.58
StdDev28.302.812.11
CoV0.050.010.01
Median (p50)612.23392.35387.33
p95618.17394.75390.98
p99618.70394.97391.31
Skewness-0.68-0.260.64
Iteration 1555.76388.18386.58
Iteration 2618.83392.35387.33
Iteration 3612.23395.02391.39

Thread Count: 32

MetricMariadb 11.8.6-MariaDB-logMariadb 12.3.1-MariaDB-logMariadb 13.0.0-MariaDB-log
Mean1051.14599.24600.59
Max1113.72607.71611.35
Min1009.87594.72594.19
StdDev45.005.997.65
CoV0.040.010.01
Median (p50)1029.82595.30596.23
p951105.33606.47609.84
p991112.04607.46611.05
Skewness0.600.700.67
Iteration 11029.82595.30596.23
Iteration 21113.72594.72594.19
Iteration 31009.87607.71611.35

Thread Count: 64

MetricMariadb 11.8.6-MariaDB-logMariadb 12.3.1-MariaDB-logMariadb 13.0.0-MariaDB-log
Mean4261.521188.491185.37
Max4821.941192.761189.96
Min3216.421184.651180.03
StdDev739.653.334.09
CoV0.170.000.00
Median (p50)4746.211188.051186.13
p954814.371192.291189.58
p994820.431192.671189.88
Skewness-0.700.19-0.27
Iteration 13216.421188.051186.13
Iteration 24821.941192.761189.96
Iteration 34746.211184.651180.03

Thread Count: 128

MetricMariadb 11.8.6-MariaDB-logMariadb 12.3.1-MariaDB-logMariadb 13.0.0-MariaDB-log
Mean7345.626431.555355.97
Max7440.846667.496618.94
Min7160.726211.634350.63
StdDev130.76186.45943.78
CoV0.020.030.18
Median (p50)7435.306415.545098.34
p957440.296642.306466.88
p997440.736662.456588.53
Skewness-0.710.130.39
Iteration 17435.306211.635098.34
Iteration 27440.846415.544350.63
Iteration 37160.726667.496618.94