TPS by Thread Count - OLTP_RO

MDEV-39364 - updated config

Comparison: TPS

ThreadsMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
47978.5508208.0378111.137
810028.52010398.67710345.780
1610864.74011085.19710888.300
3215595.47715286.73715061.587
6413088.63712789.10012638.373
12812063.62011867.15311655.140

System Info (per dataset)

PropertyMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
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-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Database Makermariadbmariadbmariadb
Database Version11.8.6-MariaDB12.3.1-MariaDB13.0.0-MariaDB
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.cnf/home/jeb/taf-perl/database_config_files/mariadb_cache.cnf/home/jeb/taf-perl/database_config_files/mariadb_cache.cnf
Config Contentsinnodb_write_io_threads=8
general_log=OFF
innodb_io_capacity=2000
slow_query_log=OFF
innodb_doublewrite=1
aria_sort_buffer_size=128M
innodb_read_io_threads=8
character_set_server=utf8mb4
collation_server=utf8mb4_general_ci
innodb_buffer_pool_size=30G
performance_schema=OFF
innodb_io_capacity_max=4000
thread_cache_size=128
innodb_flush_log_at_trx_commit=1
aria_pagecache_buffer_size=128M
max_connections=200
sync_relay_log=0
default_authentication_plugin=mysql_native_password
innodb_log_file_size=8G
innodb_file_per_table=1
innodb_default_row_format=dynamic
innodb_compression_algorithm=none
open_files_limit=65535
innodb_compression_level=0
table_open_cache=4000
innodb_flush_neighbors=0
sync_binlog=0
sync_master_info=0
innodb_undo_log_truncate=ON
default_storage_engine=InnoDB
sync_relay_log_info=0
innodb_undo_tablespaces=2
tls_version=TLSv1.2,TLSv1.3
innodb_flush_method=O_DIRECT		innodb_write_io_threads=8
general_log=OFF
innodb_io_capacity=2000
slow_query_log=OFF
innodb_doublewrite=1
aria_sort_buffer_size=128M
innodb_read_io_threads=8
character_set_server=utf8mb4
collation_server=utf8mb4_general_ci
innodb_buffer_pool_size=30G
performance_schema=OFF
innodb_io_capacity_max=4000
thread_cache_size=128
innodb_flush_log_at_trx_commit=1
aria_pagecache_buffer_size=128M
max_connections=200
sync_relay_log=0
default_authentication_plugin=mysql_native_password
innodb_log_file_size=8G
innodb_file_per_table=1
innodb_default_row_format=dynamic
innodb_compression_algorithm=none
open_files_limit=65535
innodb_compression_level=0
table_open_cache=4000
innodb_flush_neighbors=0
sync_binlog=0
sync_master_info=0
innodb_undo_log_truncate=ON
default_storage_engine=InnoDB
sync_relay_log_info=0
innodb_undo_tablespaces=2
tls_version=TLSv1.2,TLSv1.3
innodb_flush_method=O_DIRECT		innodb_write_io_threads=8
general_log=OFF
innodb_io_capacity=2000
slow_query_log=OFF
innodb_doublewrite=1
aria_sort_buffer_size=128M
innodb_read_io_threads=8
character_set_server=utf8mb4
collation_server=utf8mb4_general_ci
innodb_buffer_pool_size=30G
performance_schema=OFF
innodb_io_capacity_max=4000
thread_cache_size=128
innodb_flush_log_at_trx_commit=1
aria_pagecache_buffer_size=128M
max_connections=200
sync_relay_log=0
default_authentication_plugin=mysql_native_password
innodb_log_file_size=8G
innodb_file_per_table=1
innodb_default_row_format=dynamic
innodb_compression_algorithm=none
open_files_limit=65535
innodb_compression_level=0
table_open_cache=4000
innodb_flush_neighbors=0
sync_binlog=0
sync_master_info=0
innodb_undo_log_truncate=ON
default_storage_engine=InnoDB
sync_relay_log_info=0
innodb_undo_tablespaces=2
tls_version=TLSv1.2,TLSv1.3
innodb_flush_method=O_DIRECT

Test Info (per dataset)

PropertyMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Test Suitesysbench-luasysbench-luasysbench-lua
Test NameOLTP_ROOLTP_ROOLTP_RO
Duration300300300
Iterations333
Db drivermariadbmariadbmariadb
Debug sysbenchfalsefalsefalse
Intermediate result222
Number of rows100000010000001000000
Number of tables888
Timestamp2026-4-22 19:50:032026-4-23 14:13:102026-4-24 00:06:05

Thread Count: 4

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean7978.558208.048111.14
Max7989.338219.208119.64
Min7968.208199.088106.67
StdDev8.638.366.02
CoV0.000.000.00
Median (p50)7978.128205.838107.10
p957988.218217.868118.39
p997989.118218.938119.39
Skewness0.070.380.70
Iteration 17978.128199.088107.10
Iteration 27968.208205.838106.67
Iteration 37989.338219.208119.64

Thread Count: 8

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean10028.5210398.6810345.78
Max10031.5210435.9610352.32
Min10026.1510366.1810338.13
StdDev2.2428.695.85
CoV0.000.000.00
Median (p50)10027.8910393.8910346.89
p9510031.1610431.7510351.78
p9910031.4510435.1210352.21
Skewness0.400.25-0.28
Iteration 110027.8910435.9610346.89
Iteration 210026.1510366.1810352.32
Iteration 310031.5210393.8910338.13

Thread Count: 16

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean10864.7411085.2010888.30
Max10895.1311159.9910913.65
Min10843.7211021.3810854.86
StdDev22.0157.1224.67
CoV0.000.010.00
Median (p50)10855.3711074.2210896.39
p9510891.1511151.4110911.92
p9910894.3311158.2710913.30
Skewness0.560.28-0.46
Iteration 110843.7211021.3810854.86
Iteration 210895.1311074.2210913.65
Iteration 310855.3711159.9910896.39

Thread Count: 32

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean15595.4815286.7415061.59
Max15640.3815339.7115067.66
Min15563.9415248.4815055.79
StdDev32.6138.674.85
CoV0.000.000.00
Median (p50)15582.1115272.0215061.31
p9515634.5515332.9415067.02
p9915639.2115338.3615067.53
Skewness0.550.520.09
Iteration 115582.1115339.7115067.66
Iteration 215640.3815272.0215061.31
Iteration 315563.9415248.4815055.79

Thread Count: 64

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean13088.6412789.1012638.37
Max13107.6512811.1112737.26
Min13051.9212759.0012586.72
StdDev25.9722.0369.95
CoV0.000.000.01
Median (p50)13106.3412797.1912591.14
p9513107.5212809.7212722.65
p9913107.6212810.8312734.34
Skewness-0.71-0.500.70
Iteration 113106.3412759.0012586.72
Iteration 213107.6512811.1112737.26
Iteration 313051.9212797.1912591.14

Thread Count: 128

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean12063.6211867.1511655.14
Max12110.1611924.7811762.91
Min11982.4211769.9211521.50
StdDev57.6269.15100.24
CoV0.000.010.01
Median (p50)12098.2811906.7611681.01
p9512108.9711922.9811754.72
p9912109.9211924.4211761.27
Skewness-0.68-0.67-0.37
Iteration 111982.4211906.7611762.91
Iteration 212110.1611769.9211681.01
Iteration 312098.2811924.7811521.50