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 11.8.6-MariaDB-logMariadb 13.0.0-MariaDB-log
4640.220673.867604.497330.690
81125.2631214.6601140.180660.637
162328.1002149.3332009.2531243.280
323337.0632441.3372344.5502201.530
643766.3602186.9102123.8173335.863
1283930.7431974.4701938.8774453.497

System Info (per dataset)

PropertyMariadb 11.4.2-MariaDB-logMariadb 12.1.2-MariaDB-logMariadb 11.8.6-MariaDB-logMariadb 13.0.0-MariaDB-log
Hosthz-bench-jebhz-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-1350013th Gen Intel(R) Core(TM) i5-13500
CPU Count20202020
Core Count14141414
Socket Count1111
OSLinuxLinuxLinuxLinux
RAM62.33 GB62.33 GB62.33 GB62.33 GB
Diskunknownunknownunknownunknown

Database Info (per dataset)

PropertyMariadb 11.4.2-MariaDB-logMariadb 12.1.2-MariaDB-logMariadb 11.8.6-MariaDB-logMariadb 13.0.0-MariaDB-log
Database Makermariadbmariadbmariadbmariadb
Database Version11.4.2-MariaDB-log12.1.2-MariaDB-log11.8.6-MariaDB-log13.0.0-MariaDB-log
Engineinnodbinnodbinnodbinnodb
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-11.8.6-linux-systemd-x86_64/home/jeb/taf-perl/database_software_installs/mariadb-13.0.0-linux-systemd-x86_64
Config File./database_config_files/mariadb_cache.cnf./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

character_set_server=utf8mb4
collation_server=utf8mb4_general_ci
#character_set_server = utf8mb3
#collation_server = utf8mb3_general_ci

[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

character_set_server=utf8mb4
collation_server=utf8mb4_general_ci
#character_set_server = utf8mb3
#collation_server = utf8mb3_general_ci

[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

character_set_server=utf8mb4
collation_server=utf8mb4_general_ci
#character_set_server = utf8mb3
#collation_server = utf8mb3_general_ci

[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

character_set_server=utf8mb4
collation_server=utf8mb4_general_ci
#character_set_server = utf8mb3
#collation_server = utf8mb3_general_ci

Test Info (per dataset)

PropertyMariadb 11.4.2-MariaDB-logMariadb 12.1.2-MariaDB-logMariadb 11.8.6-MariaDB-logMariadb 13.0.0-MariaDB-log
Test Suitesysbench-luasysbench-luasysbench-luasysbench-lua
Test NameOLTP_RWOLTP_RWOLTP_RWOLTP_RW
Duration300300300300
Iterations3333
Db drivermariadbmariadbmariadbmariadb
Debug sysbenchfalsefalsefalsefalse
Intermediate result2222
Number of rows10000000100000001000000010000000
Number of tables8888
Timestamp2026-3-11 13:22:252026-3-10 16:38:282026-3-24 00:00:312026-3-24 01:46:09

Thread Count: 4

MetricMariadb 11.4.2-MariaDB-logMariadb 12.1.2-MariaDB-logMariadb 11.8.6-MariaDB-logMariadb 13.0.0-MariaDB-log
Mean640.22673.87604.50330.69
Max663.22681.99619.48361.59
Min617.23658.42596.50312.29
StdDev18.7810.9310.6021.98
CoV0.030.020.020.07
Median (p50)640.21681.19597.51318.19
p95660.92681.91617.28357.25
p99662.76681.97619.04360.72
Skewness0.00-0.700.700.67
Iteration 1663.22658.42597.51361.59
Iteration 2617.23681.19596.50312.29
Iteration 3640.21681.99619.48318.19

Thread Count: 8

MetricMariadb 11.4.2-MariaDB-logMariadb 12.1.2-MariaDB-logMariadb 11.8.6-MariaDB-logMariadb 13.0.0-MariaDB-log
Mean1125.261214.661140.18660.64
Max1190.061229.821146.44713.04
Min1042.131198.701131.67634.06
StdDev61.7712.726.2437.06
CoV0.050.010.010.06
Median (p50)1143.601215.461142.43634.81
p951185.411228.381146.04705.22
p991189.131229.531146.36711.48
Skewness-0.42-0.09-0.490.71
Iteration 11143.601198.701142.43713.04
Iteration 21190.061215.461131.67634.81
Iteration 31042.131229.821146.44634.06

Thread Count: 16

MetricMariadb 11.4.2-MariaDB-logMariadb 12.1.2-MariaDB-logMariadb 11.8.6-MariaDB-logMariadb 13.0.0-MariaDB-log
Mean2328.102149.332009.251243.28
Max2635.472199.782058.741261.83
Min2088.422077.931925.091227.72
StdDev228.4051.9159.8214.08
CoV0.100.020.030.01
Median (p50)2260.412170.292043.931240.29
p952597.962196.832057.261259.68
p992627.972199.192058.441261.40
Skewness0.42-0.54-0.670.31
Iteration 12088.422077.931925.091261.83
Iteration 22260.412170.292043.931227.72
Iteration 32635.472199.782058.741240.29

Thread Count: 32

MetricMariadb 11.4.2-MariaDB-logMariadb 12.1.2-MariaDB-logMariadb 11.8.6-MariaDB-logMariadb 13.0.0-MariaDB-log
Mean3337.062441.342344.552201.53
Max3410.882525.332444.662220.90
Min3242.372353.092263.632166.29
StdDev70.3670.3875.1424.96
CoV0.020.030.030.01
Median (p50)3357.942445.592325.362217.40
p953405.592517.362432.732220.55
p993409.822523.742442.272220.83
Skewness-0.42-0.090.37-0.70
Iteration 13242.372353.092263.632166.29
Iteration 23410.882445.592325.362217.40
Iteration 33357.942525.332444.662220.90

Thread Count: 64

MetricMariadb 11.4.2-MariaDB-logMariadb 12.1.2-MariaDB-logMariadb 11.8.6-MariaDB-logMariadb 13.0.0-MariaDB-log
Mean3766.362186.912123.823335.86
Max3857.992239.122193.593398.45
Min3719.032106.832040.463247.23
StdDev64.8057.4963.2564.42
CoV0.020.030.030.02
Median (p50)3722.062214.782137.403361.91
p953844.402236.692187.973394.80
p993855.272238.632192.473397.72
Skewness0.71-0.61-0.31-0.54
Iteration 13719.032106.832040.463247.23
Iteration 23722.062214.782137.403361.91
Iteration 33857.992239.122193.593398.45

Thread Count: 128

MetricMariadb 11.4.2-MariaDB-logMariadb 12.1.2-MariaDB-logMariadb 11.8.6-MariaDB-logMariadb 13.0.0-MariaDB-log
Mean3930.741974.471938.884453.50
Max3951.431980.391959.714506.56
Min3904.141971.021909.954385.73
StdDev19.754.2121.1150.41
CoV0.010.000.010.01
Median (p50)3936.661972.001946.974468.20
p953949.951979.551958.444502.72
p993951.131980.221959.464505.79
Skewness-0.420.68-0.52-0.41
Iteration 13904.141971.021959.714385.73
Iteration 23936.661972.001909.954468.20
Iteration 33951.431980.391946.974506.56