TPS by Thread Count - SELECT_ORDER_RANGES

MDEV-39364 - updated config ro breakout

Comparison: TPS

ThreadsMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
445140.78046655.50744610.687
862241.13763578.37362471.877
1669320.23070410.60769307.893
3279860.13780080.62079494.360
6474587.81075125.00377287.573
12871145.90770600.14769821.340

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

Test Info (per dataset)

PropertyMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Test Suitesysbench-luasysbench-luasysbench-lua
Test NameSELECT_ORDER_RANGESSELECT_ORDER_RANGESSELECT_ORDER_RANGES
Duration300300300
Iterations333
Db drivermariadbmariadbmariadb
Debug sysbenchfalsefalsefalse
Intermediate result222
Number of rows100000010000001000000
Number of tables888
Timestamp2026-4-26 06:10:152026-4-26 12:44:582026-4-26 19:19:37

Thread Count: 4

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean45140.7846655.5144610.69
Max45207.3046700.9344658.88
Min45104.4146598.9944549.25
StdDev47.1142.3545.73
CoV0.000.000.00
Median (p50)45110.6346666.6044623.93
p9545197.6346697.5044655.38
p9945205.3746700.2444658.18
Skewness0.70-0.37-0.41
Iteration 145110.6346598.9944549.25
Iteration 245104.4146700.9344623.93
Iteration 345207.3046666.6044658.88

Thread Count: 8

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean62241.1463578.3762471.88
Max62366.8263610.3762516.80
Min62046.8963529.6762408.39
StdDev139.3235.0046.16
CoV0.000.000.00
Median (p50)62309.7063595.0862490.44
p9562361.1163608.8462514.16
p9962365.6863610.0662516.27
Skewness-0.62-0.61-0.54
Iteration 162366.8263529.6762516.80
Iteration 262309.7063610.3762490.44
Iteration 362046.8963595.0862408.39

Thread Count: 16

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean69320.2370410.6169307.89
Max69566.8770450.6569412.33
Min69157.3370375.8669225.43
StdDev177.3730.7677.87
CoV0.000.000.00
Median (p50)69236.4970405.3169285.92
p9569533.8370446.1269399.69
p9969560.2670449.7469409.80
Skewness0.600.250.40
Iteration 169566.8770375.8669225.43
Iteration 269157.3370450.6569285.92
Iteration 369236.4970405.3169412.33

Thread Count: 32

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean79860.1480080.6279494.36
Max79973.4080134.0480466.73
Min79730.1080042.1678931.67
StdDev100.0338.97690.40
CoV0.000.000.01
Median (p50)79876.9180065.6679084.68
p9579963.7580127.2080328.52
p9979971.4780132.6780439.09
Skewness-0.250.520.68
Iteration 179730.1080065.6679084.68
Iteration 279876.9180042.1680466.73
Iteration 379973.4080134.0478931.67

Thread Count: 64

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean74587.8175125.0077287.57
Max74813.8376116.6478529.32
Min74294.3874430.7776445.29
StdDev217.36719.66896.46
CoV0.000.010.01
Median (p50)74655.2274827.6076888.11
p9574797.9775987.7478365.20
p9974810.6676090.8678496.50
Skewness-0.440.550.58
Iteration 174813.8376116.6478529.32
Iteration 274294.3874827.6076888.11
Iteration 374655.2274430.7776445.29

Thread Count: 128

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean71145.9170600.1569821.34
Max71575.9070805.1769974.58
Min70457.9470219.7769726.15
StdDev491.51269.24109.41
CoV0.010.000.00
Median (p50)71403.8870775.5069763.29
p9571558.7070802.2069953.45
p9971572.4670804.5869970.35
Skewness-0.64-0.700.65
Iteration 170457.9470775.5069726.15
Iteration 271403.8870219.7769974.58
Iteration 371575.9070805.1769763.29