TPROCC

MDEV39497 BASE(no binlog) vs BIN-LOG vs BIN-LOG-WALs vs BIN-LOG(Replica Attached) vs BIN-LOG-WALs(Replica Attached)

Comparison: TPM

Threads	12.3.3-MariaDB	12.3.3-MariaDB-log	12.3.3-MariaDB-log	12.3.3-MariaDB-log	12.3.3-MariaDB-log
50	394986.667	112823.000	107578.667	316265.000	265542.333

System Info (per dataset)

Property	12.3.3-MariaDB	12.3.3-MariaDB-log	12.3.3-MariaDB-log	12.3.3-MariaDB-log	12.3.3-MariaDB-log
Host	hz-bench-jeb	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	13th Gen Intel(R) Core(TM) i5-13500
CPU Count	20	20	20	20	20
Core Count	14	14	14	14	14
Socket Count	1	1	1	1	1
OS	Linux	Linux	Linux	Linux	Linux
OS Version	AlmaLinux 9.7 (Moss Jungle Cat)	AlmaLinux 9.7 (Moss Jungle Cat)	AlmaLinux 9.7 (Moss Jungle Cat)	AlmaLinux 9.7 (Moss Jungle Cat)	AlmaLinux 9.7 (Moss Jungle Cat)
OS Kernel	5.14.0-611.35.1.el9_7.x86_64	5.14.0-611.35.1.el9_7.x86_64	5.14.0-611.35.1.el9_7.x86_64	5.14.0-611.35.1.el9_7.x86_64	5.14.0-611.35.1.el9_7.x86_64
RAM	62.33 GB	62.33 GB	62.33 GB	62.33 GB	62.33 GB

Database Info (per dataset)

Property	12.3.3-MariaDB	12.3.3-MariaDB-log	12.3.3-MariaDB-log	12.3.3-MariaDB-log	12.3.3-MariaDB-log
Database Maker	mariadb	mariadb	mariadb	mariadb	mariadb
Database Version	12.3.3-MariaDB	12.3.3-MariaDB-log	12.3.3-MariaDB-log	12.3.3-MariaDB-log	12.3.3-MariaDB-log
Engine	InnoDB	InnoDB	InnoDB	InnoDB	InnoDB
Install Dir	mariadb-12.3.3-linux-systemd-x86_64	mariadb-12.3.3-linux-systemd-x86_64	mariadb-12.3.3-linux-systemd-x86_64	mariadb-12.3.3-linux-systemd-x86_64	mariadb-12.3.3-linux-systemd-x86_64
DB Config Origin	USER_PROPERTIES_INLINE_BLOCK	USER_PROPERTIES_INLINE_BLOCK	(missing)	USER_PROPERTIES_INLINE_BLOCK	(missing)
DB Config Source File	MDEV39497_baseline.properties	MDEV39497_binlog.properties	(missing)	MDEV39497_binlog_wals.properties	(missing)
DB Generated Config Run File	mariadb_2026_9_14_22_20_10.cnf	mariadb_2026_9_15_01_01_05.cnf	(missing)	mariadb_2026_9_17_16_33_41.cnf	(missing)
Config Contents	thread_handling=one-thread-per-connection innodb_flush_log_at_trx_commit=1 aria_pagecache_buffer_size=1G default_authentication_plugin=mysql_native_password innodb_log_file_size=1G disable-log-bin innodb_buffer_pool_size=50G (missing) (missing) (missing)	thread_handling=one-thread-per-connection innodb_flush_log_at_trx_commit=1 aria_pagecache_buffer_size=1G default_authentication_plugin=mysql_native_password innodb_log_file_size=1G (missing) innodb_buffer_pool_size=50G log_bin server_id=1 (missing)	thread_handling=one-thread-per-connection innodb_flush_log_at_trx_commit=1 aria_pagecache_buffer_size=1G default_authentication_plugin=mysql_native_password innodb_log_file_size=1G (missing) innodb_buffer_pool_size=50G log_bin=ON server_id=1 (missing)	thread_handling=one-thread-per-connection innodb_flush_log_at_trx_commit=1 aria_pagecache_buffer_size=1G default_authentication_plugin=mysql_native_password innodb_log_file_size=1G (missing) innodb_buffer_pool_size=50G log_bin server_id=1 binlog_storage_engine=innodb	thread_handling=one-thread-per-connection innodb_flush_log_at_trx_commit=1 aria_pagecache_buffer_size=1G default_authentication_plugin=mysql_native_password innodb_log_file_size=1G (missing) innodb_buffer_pool_size=50G log_bin server_id=1 binlog_storage_engine=innodb

Property

12.3.3-MariaDB

12.3.3-MariaDB-log

Database Maker

mariadb

Database Version

12.3.3-MariaDB

12.3.3-MariaDB-log

Engine

InnoDB

Install Dir

mariadb-12.3.3-linux-systemd-x86_64

DB Config Origin

USER_PROPERTIES_INLINE_BLOCK

(missing)

USER_PROPERTIES_INLINE_BLOCK

(missing)

DB Config Source File

MDEV39497_baseline.properties

MDEV39497_binlog.properties

(missing)

MDEV39497_binlog_wals.properties

(missing)

DB Generated Config Run File

mariadb_2026_9_14_22_20_10.cnf

mariadb_2026_9_15_01_01_05.cnf

(missing)

mariadb_2026_9_17_16_33_41.cnf

(missing)

Config Contents

thread_handling=one-thread-per-connection
innodb_flush_log_at_trx_commit=1
aria_pagecache_buffer_size=1G
default_authentication_plugin=mysql_native_password
innodb_log_file_size=1G
disable-log-bin
innodb_buffer_pool_size=50G
(missing)
(missing)
(missing)

thread_handling=one-thread-per-connection
innodb_flush_log_at_trx_commit=1
aria_pagecache_buffer_size=1G
default_authentication_plugin=mysql_native_password
innodb_log_file_size=1G
(missing)
innodb_buffer_pool_size=50G
log_bin
server_id=1
(missing)

thread_handling=one-thread-per-connection
innodb_flush_log_at_trx_commit=1
aria_pagecache_buffer_size=1G
default_authentication_plugin=mysql_native_password
innodb_log_file_size=1G
(missing)
innodb_buffer_pool_size=50G
log_bin=ON
server_id=1
(missing)

thread_handling=one-thread-per-connection
innodb_flush_log_at_trx_commit=1
aria_pagecache_buffer_size=1G
default_authentication_plugin=mysql_native_password
innodb_log_file_size=1G
(missing)
innodb_buffer_pool_size=50G
log_bin
server_id=1
binlog_storage_engine=innodb

Test Info (per dataset)

Property	12.3.3-MariaDB	12.3.3-MariaDB-log	12.3.3-MariaDB-log	12.3.3-MariaDB-log	12.3.3-MariaDB-log
Test Suite	hammerdb-tprocc	hammerdb-tprocc	hammerdb-tprocc	hammerdb-tprocc	hammerdb-tprocc
Test Name	TPROCC	TPROCC	TPROCC	TPROCC	TPROCC
Test Case Tag	MDEV39497_BASELINE	MDEV39497_BINLOG	MDEV39497_BIN_LOG_ATTACHED_REPLICAT	MDEV39497_BINLOG_WALS	MDEV39497_BINLOG_WALS_TRX_COMMIT_1_ATTACHED_REPLICANT
Duration	15	15	15	15	15
Iterations	3	3	3	3	3
Timestamp	2026-9-14 22:38:30	2026-9-15 01:19:21	2026-9-17 23:27:01	2026-9-17 16:52:01	2026-9-18 00:30:37
AutoGen Prop File	hammerdb-tprocc_TAF_AUTO_GEN_2026_9_14_22_20_23.properties	hammerdb-tprocc_TAF_AUTO_GEN_2026_9_15_01_01_23.properties	hammerdb-tprocc_TAF_AUTO_GEN_2026_9_17_23_09_29.properties	hammerdb-tprocc_TAF_AUTO_GEN_2026_9_17_16_33_54.properties	hammerdb-tprocc_TAF_AUTO_GEN_2026_9_18_00_12_57.properties
Checksum after run	true	true	true	true	true
Checksum after setup	true	true	true	true	true
Db type	maria	maria	maria	maria	maria
Include html metrics	true	true	true	true	true
Include html result	true	true	true	true	true
Include html tcount	true	true	true	true	true
Include html timing	true	true	true	true	true
Include json metrics	true	true	true	true	true
Include json result	true	true	true	true	true
Include json tcount	true	true	true	true	true
Include json timing	true	true	true	true	true
Number of warehouses	5	5	5	5	5

Property

12.3.3-MariaDB

12.3.3-MariaDB-log

Test Suite

hammerdb-tprocc

Test Name

TPROCC

Test Case Tag

MDEV39497_BASELINE

MDEV39497_BINLOG

MDEV39497_BIN_LOG_ATTACHED_REPLICAT

MDEV39497_BINLOG_WALS

MDEV39497_BINLOG_WALS_TRX_COMMIT_1_ATTACHED_REPLICANT

Duration

Iterations

Timestamp

2026-9-14 22:38:30

2026-9-15 01:19:21

2026-9-17 23:27:01

2026-9-17 16:52:01

2026-9-18 00:30:37

AutoGen Prop File

hammerdb-tprocc_TAF_AUTO_GEN_2026_9_14_22_20_23.properties

hammerdb-tprocc_TAF_AUTO_GEN_2026_9_15_01_01_23.properties

hammerdb-tprocc_TAF_AUTO_GEN_2026_9_17_23_09_29.properties

hammerdb-tprocc_TAF_AUTO_GEN_2026_9_17_16_33_54.properties

hammerdb-tprocc_TAF_AUTO_GEN_2026_9_18_00_12_57.properties

Checksum after run

true

Checksum after setup

true

Db type

maria

Include html metrics

true

Include html result

true

Include html tcount

true

Include html timing

true

Include json metrics

true

Include json result

true

Include json tcount

true

Include json timing

true

Number of warehouses

Thread Count: 50

Metric	12.3.3-MariaDB	12.3.3-MariaDB-log	12.3.3-MariaDB-log	12.3.3-MariaDB-log	12.3.3-MariaDB-log
Mean	394986.67	112823.00	107578.67	316265.00	265542.33
Max	406350.00	115177.00	110183.00	325092.00	272630.00
Min	386373.00	110681.00	105350.00	308551.00	257439.00
StdDev	8384.14	1841.60	1990.87	6798.54	6243.15
CoV	0.02	0.02	0.02	0.02	0.02
Median (p50)	392237.00	112611.00	107203.00	315152.00	266558.00
p95	404938.70	114920.40	109885.00	324098.00	272022.80
p99	406067.74	115125.68	110123.40	324893.20	272508.56
Skewness	0.46	0.17	0.28	0.24	-0.24
Iteration 1	406350.00	110681.00	105350.00	325092.00	272630.00
Iteration 2	392237.00	115177.00	110183.00	315152.00	266558.00
Iteration 3	386373.00	112611.00	107203.00	308551.00	257439.00