TPS by Thread Count - SELECT_SUM_RANGES

MDEV-39364 - updated config ro breakout

Comparison: TPS

ThreadsMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
4109275.867111856.160111487.223
8142541.633143947.500143236.757
16149841.393151813.640148750.267
32201347.870191576.227189259.797
64174289.493171956.347170921.173
128164541.960162177.993160783.627

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 Contentssync_binlog=0
innodb_compression_level=0
innodb_io_capacity=2000
character_set_server=utf8mb4
innodb_compression_algorithm=none
general_log=OFF
default_storage_engine=InnoDB
innodb_buffer_pool_size=30G
innodb_io_capacity_max=4000
slow_query_log=OFF
innodb_undo_tablespaces=2
innodb_flush_neighbors=0
collation_server=utf8mb4_general_ci
innodb_write_io_threads=8
sync_master_info=0
aria_sort_buffer_size=128M
thread_cache_size=128
performance_schema=OFF
innodb_log_file_size=8G
innodb_file_per_table=1
table_open_cache=4000
innodb_flush_method=O_DIRECT
max_connections=200
aria_pagecache_buffer_size=128M
innodb_read_io_threads=8
innodb_default_row_format=dynamic
default_authentication_plugin=mysql_native_password
innodb_doublewrite=1
open_files_limit=65535
sync_relay_log_info=0
sync_relay_log=0
innodb_flush_log_at_trx_commit=1
innodb_undo_log_truncate=ON
tls_version=TLSv1.2,TLSv1.3		sync_binlog=0
innodb_compression_level=0
innodb_io_capacity=2000
character_set_server=utf8mb4
innodb_compression_algorithm=none
general_log=OFF
default_storage_engine=InnoDB
innodb_buffer_pool_size=30G
innodb_io_capacity_max=4000
slow_query_log=OFF
innodb_undo_tablespaces=2
innodb_flush_neighbors=0
collation_server=utf8mb4_general_ci
innodb_write_io_threads=8
sync_master_info=0
aria_sort_buffer_size=128M
thread_cache_size=128
performance_schema=OFF
innodb_log_file_size=8G
innodb_file_per_table=1
table_open_cache=4000
innodb_flush_method=O_DIRECT
max_connections=200
aria_pagecache_buffer_size=128M
innodb_read_io_threads=8
innodb_default_row_format=dynamic
default_authentication_plugin=mysql_native_password
innodb_doublewrite=1
open_files_limit=65535
sync_relay_log_info=0
sync_relay_log=0
innodb_flush_log_at_trx_commit=1
innodb_undo_log_truncate=ON
tls_version=TLSv1.2,TLSv1.3		sync_binlog=0
innodb_compression_level=0
innodb_io_capacity=2000
character_set_server=utf8mb4
innodb_compression_algorithm=none
general_log=OFF
default_storage_engine=InnoDB
innodb_buffer_pool_size=30G
innodb_io_capacity_max=4000
slow_query_log=OFF
innodb_undo_tablespaces=2
innodb_flush_neighbors=0
collation_server=utf8mb4_general_ci
innodb_write_io_threads=8
sync_master_info=0
aria_sort_buffer_size=128M
thread_cache_size=128
performance_schema=OFF
innodb_log_file_size=8G
innodb_file_per_table=1
table_open_cache=4000
innodb_flush_method=O_DIRECT
max_connections=200
aria_pagecache_buffer_size=128M
innodb_read_io_threads=8
innodb_default_row_format=dynamic
default_authentication_plugin=mysql_native_password
innodb_doublewrite=1
open_files_limit=65535
sync_relay_log_info=0
sync_relay_log=0
innodb_flush_log_at_trx_commit=1
innodb_undo_log_truncate=ON
tls_version=TLSv1.2,TLSv1.3

Test Info (per dataset)

PropertyMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Test Suitesysbench-luasysbench-luasysbench-lua
Test NameSELECT_SUM_RANGESSELECT_SUM_RANGESSELECT_SUM_RANGES
Duration300300300
Iterations333
Db drivermariadbmariadbmariadb
Debug sysbenchfalsefalsefalse
Intermediate result222
Number of rows100000010000001000000
Number of tables888
Timestamp2026-4-26 04:31:492026-4-26 11:06:332026-4-26 17:41:11

Thread Count: 4

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean109275.87111856.16111487.22
Max109350.21112009.48111533.49
Min109194.63111770.12111399.38
StdDev63.70108.6862.14
CoV0.000.000.00
Median (p50)109282.76111788.88111528.80
p95109343.47111987.42111533.02
p99109348.86112005.07111533.40
Skewness-0.160.69-0.70
Iteration 1109282.76111788.88111528.80
Iteration 2109194.63111770.12111533.49
Iteration 3109350.21112009.48111399.38

Thread Count: 8

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean142541.63143947.50143236.76
Max142621.43144482.04143419.26
Min142426.08143609.19143070.99
StdDev83.66382.40142.67
CoV0.000.000.00
Median (p50)142577.39143751.27143220.02
p95142617.03144408.96143399.34
p99142620.55144467.42143415.28
Skewness-0.560.630.17
Iteration 1142621.43144482.04143419.26
Iteration 2142577.39143609.19143220.02
Iteration 3142426.08143751.27143070.99

Thread Count: 16

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean149841.39151813.64148750.27
Max150058.51152562.70148877.12
Min149580.39150559.30148532.44
StdDev197.64892.52154.72
CoV0.000.010.00
Median (p50)149885.28152318.92148841.24
p95150041.19152538.32148873.53
p99150055.05152557.82148876.40
Skewness-0.32-0.67-0.68
Iteration 1149580.39150559.30148532.44
Iteration 2149885.28152562.70148841.24
Iteration 3150058.51152318.92148877.12

Thread Count: 32

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean201347.87191576.23189259.80
Max201572.94192059.11189673.74
Min201215.86191121.36188812.95
StdDev159.94383.35352.19
CoV0.000.000.00
Median (p50)201254.81191548.21189292.70
p95201541.13192008.02189635.64
p99201566.58192048.89189666.12
Skewness0.680.11-0.14
Iteration 1201572.94191121.36188812.95
Iteration 2201215.86192059.11189673.74
Iteration 3201254.81191548.21189292.70

Thread Count: 64

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean174289.49171956.35170921.17
Max174383.81172150.07171007.79
Min174170.26171651.01170872.57
StdDev88.94218.4961.40
CoV0.000.000.00
Median (p50)174314.41172067.96170883.16
p95174376.87172141.86170995.33
p99174382.42172148.43171005.30
Skewness-0.40-0.630.69
Iteration 1174314.41172067.96170883.16
Iteration 2174170.26172150.07170872.57
Iteration 3174383.81171651.01171007.79

Thread Count: 128

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean164541.96162177.99160783.63
Max164678.92162244.79161163.81
Min164454.53162047.08160563.72
StdDev98.0792.58269.93
CoV0.000.000.00
Median (p50)164492.43162242.11160623.35
p95164660.27162244.52161109.76
p99164675.19162244.74161153.00
Skewness0.63-0.710.68
Iteration 1164678.92162244.79161163.81
Iteration 2164492.43162242.11160623.35
Iteration 3164454.53162047.08160563.72