NOPM by Thread Count

NOPM by Thread Count - TPROCC

bin log org

Comparison: NOPM

Threads	Mariadb 12.3.1-MariaDB-binlog	Mariadb 12.3.1--WALs-1	Mariadb 12.3.1-MariaDB-WALs-0	Mariadb 12.3.1-MariaDB-WALs-2
10	8410.333	47730.667	212471.333	201030.333
50	32499.333	129396.667	203120.333	194225.333
100	47798.333	154561.667	192684.667	200600.000
200	46991.333	158394.667	191829.667	194761.000
400	49282.667	152317.333	189783.667	185384.333

System Info (per dataset)

Property	Mariadb 12.3.1-MariaDB-binlog	Mariadb 12.3.1--WALs-1	Mariadb 12.3.1-MariaDB-WALs-0	Mariadb 12.3.1-MariaDB-WALs-2
Host	hz-bench-jeb	hz-bench-jeb	hz-bench-jeb	hz-bench-jeb
CPU	13th Gen Intel(R) Core(TM) i5-13500	13th Gen Intel(R) Core(TM) i5-13500	13th Gen Intel(R) Core(TM) i5-13500	13th Gen Intel(R) Core(TM) i5-13500
CPU Count	20	20	20	20
Core Count	14	14	14	14
Socket Count	1	1	1	1
OS	Linux	Linux	Linux	Linux
RAM	62.33 GB	62.33 GB	62.33 GB	62.33 GB
Disk	unknown	unknown	unknown	unknown

Database Info (per dataset)

Property	Mariadb 12.3.1-MariaDB-binlog	Mariadb 12.3.1--WALs-1	Mariadb 12.3.1-MariaDB-WALs-0	Mariadb 12.3.1-MariaDB-WALs-2
Database Maker	mariadb	mariadb	mariadb	mariadb
Database Version	12.3.1-MariaDB-log	12.3.1-MariaDB-WALs-0	12.3.1-MariaDB	12.3.1-MariaDB
Engine	InnoDB	InnoDB	InnoDB	InnoDB
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

Property

Mariadb 12.3.1-MariaDB-binlog

Mariadb 12.3.1--WALs-1

Mariadb 12.3.1-MariaDB-WALs-0

Mariadb 12.3.1-MariaDB-WALs-2

Database Maker

mariadb

Database Version

12.3.1-MariaDB-log

12.3.1-MariaDB-WALs-0

12.3.1-MariaDB

Engine

InnoDB

Install Dir

/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)

Property	Mariadb 12.3.1-MariaDB-binlog	Mariadb 12.3.1--WALs-1	Mariadb 12.3.1-MariaDB-WALs-0	Mariadb 12.3.1-MariaDB-WALs-2
Test Suite	hammerdb-tprocc	hammerdb-tprocc	hammerdb-tprocc	hammerdb-tprocc
Test Name	TPROCC	TPROCC	TPROCC	TPROCC
Duration	5	5	5	5
Iterations	3	3	3	3
Checksum after run	true	true	true	true
Checksum after setup	true	true	true	true
Db type	maria	maria	maria	maria
Include html metrics	false	false	false	false
Include html result	false	false	false	false
Include html tcount	false	false	false	false
Include html timing	false	false	false	false
Include json metrics	false	false	false	false
Include json result	false	false	false	false
Include json tcount	false	false	false	false
Include json timing	false	false	false	false
Number of warehouses	100	100	100	100
Timeprofile	false	false	false	false
Timestamp	2026-4-5 00:22:47	2026-4-5 02:38:21	2026-4-5 04:54:53	2026-4-5 12:12:50

Property

Mariadb 12.3.1-MariaDB-binlog

Mariadb 12.3.1--WALs-1

Mariadb 12.3.1-MariaDB-WALs-0

Mariadb 12.3.1-MariaDB-WALs-2

Test Suite

hammerdb-tprocc

Test Name

TPROCC

Duration

Iterations

Checksum after run

true

Checksum after setup

true

Db type

maria

Include html metrics

false

Include html result

false

Include html tcount

false

Include html timing

false

Include json metrics

false

Include json result

false

Include json tcount

false

Include json timing

false

Number of warehouses

100

Timeprofile

false

Timestamp

2026-4-5 00:22:47

2026-4-5 02:38:21

2026-4-5 04:54:53

2026-4-5 12:12:50

Thread Count: 10

Metric	Mariadb 12.3.1-MariaDB-binlog	Mariadb 12.3.1--WALs-1	Mariadb 12.3.1-MariaDB-WALs-0	Mariadb 12.3.1-MariaDB-WALs-2
Mean	8410.33	47730.67	212471.33	201030.33
Max	8472.00	49466.00	216769.00	204905.00
Min	8288.00	45756.00	204750.00	198684.00
StdDev	86.50	1524.03	5471.45	2760.08
CoV	0.01	0.03	0.03	0.01
Median (p50)	8471.00	47970.00	215895.00	199502.00
p95	8471.90	49316.40	216681.60	204364.70
p99	8471.98	49436.08	216751.52	204796.94
Skewness	-0.71	-0.23	-0.69	0.66
Iteration 1	8288.00	45756.00	216769.00	198684.00
Iteration 2	8471.00	47970.00	204750.00	199502.00
Iteration 3	8472.00	49466.00	215895.00	204905.00

Thread Count: 50

Metric	Mariadb 12.3.1-MariaDB-binlog	Mariadb 12.3.1--WALs-1	Mariadb 12.3.1-MariaDB-WALs-0	Mariadb 12.3.1-MariaDB-WALs-2
Mean	32499.33	129396.67	203120.33	194225.33
Max	34780.00	136277.00	205775.00	195109.00
Min	30543.00	119400.00	201739.00	193577.00
StdDev	1744.89	7233.81	1877.65	647.20
CoV	0.05	0.06	0.01	0.00
Median (p50)	32175.00	132513.00	201847.00	193990.00
p95	34519.50	135900.60	205382.20	194997.10
p99	34727.90	136201.72	205696.44	195086.62
Skewness	0.27	-0.57	0.71	0.50
Iteration 1	32175.00	136277.00	205775.00	195109.00
Iteration 2	30543.00	132513.00	201739.00	193577.00
Iteration 3	34780.00	119400.00	201847.00	193990.00

Thread Count: 100

Metric	Mariadb 12.3.1-MariaDB-binlog	Mariadb 12.3.1--WALs-1	Mariadb 12.3.1-MariaDB-WALs-0	Mariadb 12.3.1-MariaDB-WALs-2
Mean	47798.33	154561.67	192684.67	200600.00
Max	51146.00	155747.00	195073.00	217803.00
Min	44040.00	152568.00	188096.00	190208.00
StdDev	2915.51	1418.11	3245.58	12251.89
CoV	0.06	0.01	0.02	0.06
Median (p50)	48209.00	155370.00	194885.00	193789.00
p95	50852.30	155709.30	195054.20	215401.60
p99	51087.26	155739.46	195069.24	217322.72
Skewness	-0.21	-0.67	-0.71	0.66
Iteration 1	48209.00	155747.00	188096.00	193789.00
Iteration 2	44040.00	155370.00	194885.00	190208.00
Iteration 3	51146.00	152568.00	195073.00	217803.00

Thread Count: 200

Metric	Mariadb 12.3.1-MariaDB-binlog	Mariadb 12.3.1--WALs-1	Mariadb 12.3.1-MariaDB-WALs-0	Mariadb 12.3.1-MariaDB-WALs-2
Mean	46991.33	158394.67	191829.67	194761.00
Max	49385.00	161665.00	194447.00	196359.00
Min	43115.00	156551.00	186626.00	192195.00
StdDev	2766.10	2318.73	3679.57	1832.57
CoV	0.06	0.01	0.02	0.01
Median (p50)	48474.00	156968.00	194416.00	195729.00
p95	49293.90	161195.30	194443.90	196296.00
p99	49366.78	161571.06	194446.38	196346.40
Skewness	-0.65	0.69	-0.71	-0.64
Iteration 1	48474.00	156551.00	194447.00	196359.00
Iteration 2	49385.00	161665.00	194416.00	195729.00
Iteration 3	43115.00	156968.00	186626.00	192195.00

Thread Count: 400

Metric	Mariadb 12.3.1-MariaDB-binlog	Mariadb 12.3.1--WALs-1	Mariadb 12.3.1-MariaDB-WALs-0	Mariadb 12.3.1-MariaDB-WALs-2
Mean	49282.67	152317.33	189783.67	185384.33
Max	52077.00	160979.00	195315.00	188490.00
Min	44155.00	144053.00	184019.00	180629.00
StdDev	3630.69	6915.72	4614.52	3414.66
CoV	0.07	0.05	0.02	0.02
Median (p50)	51616.00	151920.00	190017.00	187034.00
p95	52030.90	160073.10	194785.20	188344.40
p99	52067.78	160797.82	195209.04	188460.88
Skewness	-0.70	0.09	-0.08	-0.61
Iteration 1	52077.00	144053.00	190017.00	180629.00
Iteration 2	51616.00	151920.00	184019.00	188490.00
Iteration 3	44155.00	160979.00	195315.00	187034.00