TPS by Thread Count - OLTP_RW

MDEV-39364 - updated config

Comparison: TPS

ThreadsMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
4483.480475.897483.937
8774.957821.790812.303
161603.8731668.7271733.823
327652.4037660.6877592.297
649817.5279722.4809512.353
1289134.9738947.9408796.917

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

Test Info (per dataset)

PropertyMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
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-22 21:28:292026-4-23 15:51:362026-4-24 01:44:32

Thread Count: 4

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean483.48475.90483.94
Max508.18505.91507.18
Min448.88425.76448.14
StdDev25.2035.6825.69
CoV0.050.070.05
Median (p50)493.38496.02496.49
p95506.70504.92506.11
p99507.88505.71506.97
Skewness-0.53-0.67-0.62
Iteration 1448.88425.76448.14
Iteration 2493.38496.02496.49
Iteration 3508.18505.91507.18

Thread Count: 8

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean774.96821.79812.30
Max776.85841.88833.10
Min773.70808.79798.81
StdDev1.3614.4114.92
CoV0.000.020.02
Median (p50)774.32814.70805.00
p95776.60839.16830.29
p99776.80841.34832.54
Skewness0.600.620.62
Iteration 1774.32808.79798.81
Iteration 2773.70814.70805.00
Iteration 3776.85841.88833.10

Thread Count: 16

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean1603.871668.731733.82
Max1664.041845.412038.71
Min1536.721531.431539.04
StdDev52.21131.17218.34
CoV0.030.080.13
Median (p50)1610.861629.341623.72
p951658.721823.801997.21
p991662.981841.092030.41
Skewness-0.200.420.63
Iteration 11610.861629.341623.72
Iteration 21536.721531.431539.04
Iteration 31664.041845.412038.71

Thread Count: 32

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean7652.407660.697592.30
Max7727.557743.547623.42
Min7521.057517.607550.46
StdDev93.20101.6030.73
CoV0.010.010.00
Median (p50)7708.617720.927603.01
p957725.667741.287621.38
p997727.177743.097623.01
Skewness-0.69-0.68-0.48
Iteration 17708.617720.927623.42
Iteration 27521.057517.607603.01
Iteration 37727.557743.547550.46

Thread Count: 64

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean9817.539722.489512.35
Max9835.539794.759589.37
Min9792.479663.739413.64
StdDev18.2754.3473.36
CoV0.000.010.01
Median (p50)9824.589708.969534.05
p959834.449786.179583.84
p999835.319793.039588.26
Skewness-0.520.36-0.42
Iteration 19824.589663.739534.05
Iteration 29835.539794.759413.64
Iteration 39792.479708.969589.37

Thread Count: 128

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean9134.978947.948796.92
Max9192.638975.588818.40
Min9075.518906.008770.97
StdDev47.8330.1519.62
CoV0.010.000.00
Median (p50)9136.788962.248801.38
p959187.058974.258816.70
p999191.518975.318818.06
Skewness-0.06-0.60-0.33
Iteration 19192.638975.588801.38
Iteration 29136.788906.008770.97
Iteration 39075.518962.248818.40