NOPM by Thread Count - TPROCC

bin log org

Comparison: NOPM

ThreadsMariadb 12.3.1-MariaDB-binlogMariadb 12.3.1--WALs-1Mariadb 12.3.1-MariaDB-WALs-0Mariadb 12.3.1-MariaDB-WALs-2
108410.33347730.667212471.333201030.333
5032499.333129396.667203120.333194225.333
10047798.333154561.667192684.667200600.000
20046991.333158394.667191829.667194761.000
40049282.667152317.333189783.667185384.333

System Info (per dataset)

PropertyMariadb 12.3.1-MariaDB-binlogMariadb 12.3.1--WALs-1Mariadb 12.3.1-MariaDB-WALs-0Mariadb 12.3.1-MariaDB-WALs-2
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 12.3.1-MariaDB-binlogMariadb 12.3.1--WALs-1Mariadb 12.3.1-MariaDB-WALs-0Mariadb 12.3.1-MariaDB-WALs-2
Database Makermariadbmariadbmariadbmariadb
Database Version12.3.1-MariaDB-log12.3.1-MariaDB-WALs-012.3.1-MariaDB12.3.1-MariaDB
EngineInnoDBInnoDBInnoDBInnoDB
Install Dir/home/jeb/taf-perl/database_software_installs/mariadb-12.3.1-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-12.3.1-linux-systemd-x86_64/home/jeb/taf-perl/database_software_installs/mariadb-12.3.1-linux-systemd-x86_64
Config File/home/jeb/taf-perl/database_config_files/mariadb_cache_bin_log.cnf/home/jeb/taf-perl/database_config_files/mariadb_cache_wals.cnf/home/jeb/taf-perl/database_config_files/mariadb_cache_wals_commit_0.cnf/home/jeb/taf-perl/database_config_files/mariadb_cache_wals_commit_2.cnf
Config Contents[mysqld]
performance_schema=OFF
log_bin
sync_binlog=1
general_log=OFF
slow_query_log=OFF
default_storage_engine=InnoDB
default_authentication_plugin=mysql_native_password
tls_version = TLSv1.2,TLSv1.3
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=8G
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

[mysqld]
performance_schema=OFF
general_log=OFF
slow_query_log=OFF
default_storage_engine=InnoDB
default_authentication_plugin=mysql_native_password
tls_version = TLSv1.2,TLSv1.3
max_connections=200
open_files_limit=65535
table_open_cache=4000
thread_cache_size=128

# Enable binlog + WAL-based storage
binlog_storage_engine=innodb

# Correct durability for apples-to-apples comparison
innodb_flush_log_at_trx_commit=1

# InnoDB
innodb_buffer_pool_size=30G
innodb_doublewrite=1
innodb_flush_method=O_DIRECT
innodb_flush_neighbors=0
innodb_log_file_size=8G
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
[mysqld]
performance_schema=OFF
general_log=OFF
slow_query_log=OFF
default_storage_engine=InnoDB
default_authentication_plugin=mysql_native_password
tls_version = TLSv1.2,TLSv1.3
max_connections=200
open_files_limit=65535
table_open_cache=4000
thread_cache_size=128

# Enable binlog + WAL-based storage
binlog_storage_engine=innodb

# Correct durability for apples-to-apples comparison
innodb_flush_log_at_trx_commit=0


# InnoDB
innodb_buffer_pool_size=30G
innodb_doublewrite=1
innodb_flush_method=O_DIRECT
innodb_flush_neighbors=0
innodb_log_file_size=8G
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
[mysqld]
performance_schema=OFF
general_log=OFF
slow_query_log=OFF
default_storage_engine=InnoDB
default_authentication_plugin=mysql_native_password
tls_version = TLSv1.2,TLSv1.3
max_connections=200
open_files_limit=65535
table_open_cache=4000
thread_cache_size=128

# Enable binlog + WAL-based storage
binlog_storage_engine=innodb

# Correct durability for apples-to-apples comparison
innodb_flush_log_at_trx_commit=2

# InnoDB
innodb_buffer_pool_size=30G
innodb_doublewrite=1
innodb_flush_method=O_DIRECT
innodb_flush_neighbors=0
innodb_log_file_size=8G
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

Test Info (per dataset)

PropertyMariadb 12.3.1-MariaDB-binlogMariadb 12.3.1--WALs-1Mariadb 12.3.1-MariaDB-WALs-0Mariadb 12.3.1-MariaDB-WALs-2
Test Suitehammerdb-tprocchammerdb-tprocchammerdb-tprocchammerdb-tprocc
Test NameTPROCCTPROCCTPROCCTPROCC
Duration5555
Iterations3333
Checksum after runtruetruetruetrue
Checksum after setuptruetruetruetrue
Db typemariamariamariamaria
Include html metricsfalsefalsefalsefalse
Include html resultfalsefalsefalsefalse
Include html tcountfalsefalsefalsefalse
Include html timingfalsefalsefalsefalse
Include json metricsfalsefalsefalsefalse
Include json resultfalsefalsefalsefalse
Include json tcountfalsefalsefalsefalse
Include json timingfalsefalsefalsefalse
Number of warehouses100100100100
Timeprofilefalsefalsefalsefalse
Timestamp2026-4-5 00:22:472026-4-5 02:38:212026-4-5 04:54:532026-4-5 12:12:50

Thread Count: 10

MetricMariadb 12.3.1-MariaDB-binlogMariadb 12.3.1--WALs-1Mariadb 12.3.1-MariaDB-WALs-0Mariadb 12.3.1-MariaDB-WALs-2
Mean8410.3347730.67212471.33201030.33
Max8472.0049466.00216769.00204905.00
Min8288.0045756.00204750.00198684.00
StdDev86.501524.035471.452760.08
CoV0.010.030.030.01
Median (p50)8471.0047970.00215895.00199502.00
p958471.9049316.40216681.60204364.70
p998471.9849436.08216751.52204796.94
Skewness-0.71-0.23-0.690.66
Iteration 18288.0045756.00216769.00198684.00
Iteration 28471.0047970.00204750.00199502.00
Iteration 38472.0049466.00215895.00204905.00

Thread Count: 50

MetricMariadb 12.3.1-MariaDB-binlogMariadb 12.3.1--WALs-1Mariadb 12.3.1-MariaDB-WALs-0Mariadb 12.3.1-MariaDB-WALs-2
Mean32499.33129396.67203120.33194225.33
Max34780.00136277.00205775.00195109.00
Min30543.00119400.00201739.00193577.00
StdDev1744.897233.811877.65647.20
CoV0.050.060.010.00
Median (p50)32175.00132513.00201847.00193990.00
p9534519.50135900.60205382.20194997.10
p9934727.90136201.72205696.44195086.62
Skewness0.27-0.570.710.50
Iteration 132175.00136277.00205775.00195109.00
Iteration 230543.00132513.00201739.00193577.00
Iteration 334780.00119400.00201847.00193990.00

Thread Count: 100

MetricMariadb 12.3.1-MariaDB-binlogMariadb 12.3.1--WALs-1Mariadb 12.3.1-MariaDB-WALs-0Mariadb 12.3.1-MariaDB-WALs-2
Mean47798.33154561.67192684.67200600.00
Max51146.00155747.00195073.00217803.00
Min44040.00152568.00188096.00190208.00
StdDev2915.511418.113245.5812251.89
CoV0.060.010.020.06
Median (p50)48209.00155370.00194885.00193789.00
p9550852.30155709.30195054.20215401.60
p9951087.26155739.46195069.24217322.72
Skewness-0.21-0.67-0.710.66
Iteration 148209.00155747.00188096.00193789.00
Iteration 244040.00155370.00194885.00190208.00
Iteration 351146.00152568.00195073.00217803.00

Thread Count: 200

MetricMariadb 12.3.1-MariaDB-binlogMariadb 12.3.1--WALs-1Mariadb 12.3.1-MariaDB-WALs-0Mariadb 12.3.1-MariaDB-WALs-2
Mean46991.33158394.67191829.67194761.00
Max49385.00161665.00194447.00196359.00
Min43115.00156551.00186626.00192195.00
StdDev2766.102318.733679.571832.57
CoV0.060.010.020.01
Median (p50)48474.00156968.00194416.00195729.00
p9549293.90161195.30194443.90196296.00
p9949366.78161571.06194446.38196346.40
Skewness-0.650.69-0.71-0.64
Iteration 148474.00156551.00194447.00196359.00
Iteration 249385.00161665.00194416.00195729.00
Iteration 343115.00156968.00186626.00192195.00

Thread Count: 400

MetricMariadb 12.3.1-MariaDB-binlogMariadb 12.3.1--WALs-1Mariadb 12.3.1-MariaDB-WALs-0Mariadb 12.3.1-MariaDB-WALs-2
Mean49282.67152317.33189783.67185384.33
Max52077.00160979.00195315.00188490.00
Min44155.00144053.00184019.00180629.00
StdDev3630.696915.724614.523414.66
CoV0.070.050.020.02
Median (p50)51616.00151920.00190017.00187034.00
p9552030.90160073.10194785.20188344.40
p9952067.78160797.82195209.04188460.88
Skewness-0.700.09-0.08-0.61
Iteration 152077.00144053.00190017.00180629.00
Iteration 251616.00151920.00184019.00188490.00
Iteration 344155.00160979.00195315.00187034.00