TPS by Thread Count - OLTP_RW

MariaDB Cached Read-Write and Write Cases

Comparison: TPS

ThreadsMariadb 11.4.2-MariaDB-logMariadb 12.1.2-MariaDB-logMariadb 12.3.1-MariaDB-log
4640.220673.867387.517
81125.2631214.660707.823
162328.1002149.3331358.113
323337.0632441.3372433.507
643766.3602186.9102376.637
1283930.7431974.4702122.637

System Info (per dataset)

PropertyMariadb 11.4.2-MariaDB-logMariadb 12.1.2-MariaDB-logMariadb 12.3.1-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.4.2-MariaDB-logMariadb 12.1.2-MariaDB-logMariadb 12.3.1-MariaDB-log
Database Makermariadbmariadbmariadb
Database Version11.4.2-MariaDB-log12.1.2-MariaDB-log12.3.1-MariaDB-log
Engineinnodbinnodbinnodb
Install Dir/home/jeb/taf-perl/database_software_installs/mariadb-11.4.2-linux-systemd-x86_64/home/jeb/taf-perl/database_software_installs/mariadb-12.1.2-linux-systemd-x86_64/home/jeb/taf-perl/database_software_installs/mariadb-12.3.1-linux-systemd-x86_64
Config File./database_config_files/mariadb_cache.cnf./database_config_files/mariadb_cache.cnf./database_config_files/mariadb_cache.cnf
Config Contents
[mysqld]
performance_schema=OFF
log_bin=OFF
sync_binlog=0
general_log=OFF
slow_query_log=OFF
default_storage_engine=InnoDB
default_authentication_plugin=mysql_native_password
tls_version = TLSv1.2,TLSv1.3
character_set_server=utf8mb4
collation_server=utf8mb4_general_ci
max_connections=200
open_files_limit=65535
table_open_cache=4000
thread_cache_size=128

# Innodb
innodb_buffer_pool_size=30G
innodb_flush_log_at_trx_commit=1
innodb_doublewrite=1
innodb_flush_method=O_DIRECT
innodb_flush_neighbors=0
innodb_log_file_size=2G
innodb_log_files_in_group=4
innodb_undo_tablespaces=2
innodb_undo_log_truncate=ON
innodb_io_capacity=2000
innodb_io_capacity_max=4000
innodb_read_io_threads=8
innodb_write_io_threads=8
innodb_file_per_table=1
innodb_default_row_format=dynamic
innodb_compression_algorithm=none
innodb_compression_level=0

# sync
sync_master_info=0
sync_relay_log=0
sync_relay_log_info=0

aria_pagecache_buffer_size = 128M
aria_sort_buffer_size = 128M

[mysqld]
performance_schema=OFF
log_bin=OFF
sync_binlog=0
general_log=OFF
slow_query_log=OFF
default_storage_engine=InnoDB
default_authentication_plugin=mysql_native_password
tls_version = TLSv1.2,TLSv1.3
character_set_server=utf8mb4
collation_server=utf8mb4_general_ci
max_connections=200
open_files_limit=65535
table_open_cache=4000
thread_cache_size=128

# Innodb
innodb_buffer_pool_size=30G
innodb_flush_log_at_trx_commit=1
innodb_doublewrite=1
innodb_flush_method=O_DIRECT
innodb_flush_neighbors=0
innodb_log_file_size=2G
innodb_log_files_in_group=4
innodb_undo_tablespaces=2
innodb_undo_log_truncate=ON
innodb_io_capacity=2000
innodb_io_capacity_max=4000
innodb_read_io_threads=8
innodb_write_io_threads=8
innodb_file_per_table=1
innodb_default_row_format=dynamic
innodb_compression_algorithm=none
innodb_compression_level=0

# sync
sync_master_info=0
sync_relay_log=0
sync_relay_log_info=0

aria_pagecache_buffer_size = 128M
aria_sort_buffer_size = 128M

[mysqld]
performance_schema=OFF
log_bin=OFF
sync_binlog=0
general_log=OFF
slow_query_log=OFF
default_storage_engine=InnoDB
default_authentication_plugin=mysql_native_password
tls_version = TLSv1.2,TLSv1.3
character_set_server=utf8mb4
collation_server=utf8mb4_general_ci
max_connections=200
open_files_limit=65535
table_open_cache=4000
thread_cache_size=128

# Innodb
innodb_buffer_pool_size=30G
innodb_flush_log_at_trx_commit=1
innodb_doublewrite=1
innodb_flush_method=O_DIRECT
innodb_flush_neighbors=0
innodb_log_file_size=2G
innodb_log_files_in_group=4
innodb_undo_tablespaces=2
innodb_undo_log_truncate=ON
innodb_io_capacity=2000
innodb_io_capacity_max=4000
innodb_read_io_threads=8
innodb_write_io_threads=8
innodb_file_per_table=1
innodb_default_row_format=dynamic
innodb_compression_algorithm=none
innodb_compression_level=0

# sync
sync_master_info=0
sync_relay_log=0
sync_relay_log_info=0

aria_pagecache_buffer_size = 128M
aria_sort_buffer_size = 128M

Test Info (per dataset)

PropertyMariadb 11.4.2-MariaDB-logMariadb 12.1.2-MariaDB-logMariadb 12.3.1-MariaDB-log
Test Suitesysbench-luasysbench-luasysbench-lua
Test NameOLTP_RWOLTP_RWOLTP_RW
Duration300300300
Iterations333
Db drivermariadbmariadbmariadb
Debug sysbenchfalsefalsefalse
Intermediate result222
Number of rows100000001000000010000000
Number of tables888
Timestamp2026-3-11 13:22:252026-3-10 16:38:282026-3-16 16:15:44

Thread Count: 4

MetricMariadb 11.4.2-MariaDB-logMariadb 12.1.2-MariaDB-logMariadb 12.3.1-MariaDB-log
Mean640.22673.87387.52
Max663.22681.99439.42
Min617.23658.42361.53
StdDev18.7810.9336.70
CoV0.030.020.09
Median (p50)640.21681.19361.60
p95660.92681.91431.64
p99662.76681.97437.86
Skewness0.00-0.700.71
Iteration 1663.22658.42361.53
Iteration 2617.23681.19439.42
Iteration 3640.21681.99361.60

Thread Count: 8

MetricMariadb 11.4.2-MariaDB-logMariadb 12.1.2-MariaDB-logMariadb 12.3.1-MariaDB-log
Mean1125.261214.66707.82
Max1190.061229.82716.13
Min1042.131198.70696.60
StdDev61.7712.728.24
CoV0.050.010.01
Median (p50)1143.601215.46710.74
p951185.411228.38715.59
p991189.131229.53716.02
Skewness-0.42-0.09-0.49
Iteration 11143.601198.70710.74
Iteration 21190.061215.46696.60
Iteration 31042.131229.82716.13

Thread Count: 16

MetricMariadb 11.4.2-MariaDB-logMariadb 12.1.2-MariaDB-logMariadb 12.3.1-MariaDB-log
Mean2328.102149.331358.11
Max2635.472199.781383.95
Min2088.422077.931336.45
StdDev228.4051.9119.62
CoV0.100.020.01
Median (p50)2260.412170.291353.94
p952597.962196.831380.95
p992627.972199.191383.35
Skewness0.42-0.540.31
Iteration 12088.422077.931383.95
Iteration 22260.412170.291336.45
Iteration 32635.472199.781353.94

Thread Count: 32

MetricMariadb 11.4.2-MariaDB-logMariadb 12.1.2-MariaDB-logMariadb 12.3.1-MariaDB-log
Mean3337.062441.342433.51
Max3410.882525.332467.60
Min3242.372353.092376.18
StdDev70.3670.3840.78
CoV0.020.030.02
Median (p50)3357.942445.592456.74
p953405.592517.362466.51
p993409.822523.742467.38
Skewness-0.42-0.09-0.67
Iteration 13242.372353.092376.18
Iteration 23410.882445.592456.74
Iteration 33357.942525.332467.60

Thread Count: 64

MetricMariadb 11.4.2-MariaDB-logMariadb 12.1.2-MariaDB-logMariadb 12.3.1-MariaDB-log
Mean3766.362186.912376.64
Max3857.992239.122503.59
Min3719.032106.832182.17
StdDev64.8057.49139.63
CoV0.020.030.06
Median (p50)3722.062214.782444.15
p953844.402236.692497.65
p993855.272238.632502.40
Skewness0.71-0.61-0.61
Iteration 13719.032106.832182.17
Iteration 23722.062214.782444.15
Iteration 33857.992239.122503.59

Thread Count: 128

MetricMariadb 11.4.2-MariaDB-logMariadb 12.1.2-MariaDB-logMariadb 12.3.1-MariaDB-log
Mean3930.741974.472122.64
Max3951.431980.392173.23
Min3904.141971.022090.69
StdDev19.754.2136.18
CoV0.010.000.02
Median (p50)3936.661972.002103.99
p953949.951979.552166.31
p993951.131980.222171.85
Skewness-0.420.680.64
Iteration 13904.141971.022090.69
Iteration 23936.661972.002103.99
Iteration 33951.431980.392173.23