TPROCC

MDEV39497 REPEATABLE-READ(BASELINE) vs READ-COMMITTED vs READ-UNCOMMITTED vs SERIALIZABLE

Comparison: NOPM

Threads	12.3.3-MariaDB	12.3.3-MariaDB	12.3.3-MariaDB	12.3.3-MariaDB
50	44013.333	42471.000	41127.333	44208.667

System Info (per dataset)

Property	12.3.3-MariaDB	12.3.3-MariaDB	12.3.3-MariaDB	12.3.3-MariaDB
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
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)
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
RAM	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	12.3.3-MariaDB	12.3.3-MariaDB
Database Maker	mariadb	mariadb	mariadb	mariadb
Database Version	12.3.3-MariaDB	12.3.3-MariaDB	12.3.3-MariaDB	12.3.3-MariaDB
Engine	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
DB Config Origin	CLI	CLI	CLI	CLI
DB Config Source File	MDEV39497_baseline.cnf	MDEV39497_rc_isolation.cnf	MDEV39497_ru_isolation.cnf	MDEV39497_serializable_isolation.cnf
DB Generated Config Run File	mariadb_2026_8_28_22_42_12.cnf	mariadb_2026_8_29_03_50_04.cnf	mariadb_2026_8_29_06_43_37.cnf	mariadb_2026_8_29_21_44_10.cnf
Config Contents	innodb_buffer_pool_size=30G table_open_cache=4000 default_authentication_plugin=mysql_native_password open_files_limit=65535 (missing)	innodb_buffer_pool_size=30G table_open_cache=4000 default_authentication_plugin=mysql_native_password open_files_limit=65535 transaction_isolation=READ-COMMITTED	innodb_buffer_pool_size=30G table_open_cache=4000 default_authentication_plugin=mysql_native_password open_files_limit=65535 transaction_isolation=READ-UNCOMMITTED	innodb_buffer_pool_size=30G table_open_cache=4000 default_authentication_plugin=mysql_native_password open_files_limit=65535 transaction_isolation=SERIALIZABLE

Property

12.3.3-MariaDB

Database Maker

mariadb

Database Version

12.3.3-MariaDB

Engine

InnoDB

Install Dir

mariadb-12.3.3-linux-systemd-x86_64

DB Config Origin

CLI

DB Config Source File

MDEV39497_baseline.cnf

MDEV39497_rc_isolation.cnf

MDEV39497_ru_isolation.cnf

MDEV39497_serializable_isolation.cnf

DB Generated Config Run File

mariadb_2026_8_28_22_42_12.cnf

mariadb_2026_8_29_03_50_04.cnf

mariadb_2026_8_29_06_43_37.cnf

mariadb_2026_8_29_21_44_10.cnf

Config Contents

innodb_buffer_pool_size=30G
table_open_cache=4000
default_authentication_plugin=mysql_native_password
open_files_limit=65535
(missing)

innodb_buffer_pool_size=30G
table_open_cache=4000
default_authentication_plugin=mysql_native_password
open_files_limit=65535
transaction_isolation=READ-COMMITTED

innodb_buffer_pool_size=30G
table_open_cache=4000
default_authentication_plugin=mysql_native_password
open_files_limit=65535
transaction_isolation=READ-UNCOMMITTED

innodb_buffer_pool_size=30G
table_open_cache=4000
default_authentication_plugin=mysql_native_password
open_files_limit=65535
transaction_isolation=SERIALIZABLE

Test Info (per dataset)

Property	12.3.3-MariaDB	12.3.3-MariaDB	12.3.3-MariaDB	12.3.3-MariaDB
Test Suite	hammerdb-tprocc	hammerdb-tprocc	hammerdb-tprocc	hammerdb-tprocc
Test Name	TPROCC	TPROCC	TPROCC	TPROCC
Test Case Tag	MDEV39497_BASELINE	MDEV39497_RC_ISOLATION	MDEV39497_RU_ISOLATION	MDEV39497_SERIALIZABLE_ISOLATION
Duration	15	15	15	15
Iterations	3	3	3	3
Timestamp	2026-8-28 23:04:25	2026-8-29 04:12:10	2026-8-29 07:06:07	2026-8-29 22:05:28
AutoGen Prop File	hammerdb-tprocc_TAF_AUTO_GEN_2026_8_28_22_42_24.properties	hammerdb-tprocc_TAF_AUTO_GEN_2026_8_29_03_50_17.properties	hammerdb-tprocc_TAF_AUTO_GEN_2026_8_29_06_43_54.properties	hammerdb-tprocc_TAF_AUTO_GEN_2026_8_29_21_44_21.properties
Checksum after run	true	true	true	true
Checksum after setup	true	true	true	true
Db type	maria	maria	maria	maria
Include html metrics	true	true	true	true
Include html result	true	true	true	true
Include html tcount	true	true	true	true
Include html timing	true	true	true	true
Include json metrics	true	true	true	true
Include json result	true	true	true	true
Include json tcount	true	true	true	true
Include json timing	true	true	true	true
Number of warehouses	100	100	100	100

Property

12.3.3-MariaDB

Test Suite

hammerdb-tprocc

Test Name

TPROCC

Test Case Tag

MDEV39497_BASELINE

MDEV39497_RC_ISOLATION

MDEV39497_RU_ISOLATION

MDEV39497_SERIALIZABLE_ISOLATION

Duration

Iterations

Timestamp

2026-8-28 23:04:25

2026-8-29 04:12:10

2026-8-29 07:06:07

2026-8-29 22:05:28

AutoGen Prop File

hammerdb-tprocc_TAF_AUTO_GEN_2026_8_28_22_42_24.properties

hammerdb-tprocc_TAF_AUTO_GEN_2026_8_29_03_50_17.properties

hammerdb-tprocc_TAF_AUTO_GEN_2026_8_29_06_43_54.properties

hammerdb-tprocc_TAF_AUTO_GEN_2026_8_29_21_44_21.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

100

Thread Count: 50

Metric	12.3.3-MariaDB	12.3.3-MariaDB	12.3.3-MariaDB	12.3.3-MariaDB
Mean	44013.33	42471.00	41127.33	44208.67
Max	44942.00	43167.00	41617.00	44355.00
Min	42517.00	41165.00	40386.00	44108.00
StdDev	1068.28	924.15	533.13	105.88
CoV	0.02	0.02	0.01	0.00
Median (p50)	44581.00	43081.00	41379.00	44163.00
p95	44905.90	43158.40	41593.20	44335.80
p99	44934.78	43165.28	41612.24	44351.16
Skewness	-0.65	-0.70	-0.60	0.57
Iteration 1	42517.00	43167.00	41617.00	44355.00
Iteration 2	44581.00	41165.00	40386.00	44108.00
Iteration 3	44942.00	43081.00	41379.00	44163.00