TPROCC

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

Comparison: NOPM

Threads12.3.3-MariaDB12.3.3-MariaDB12.3.3-MariaDB12.3.3-MariaDB
5044013.33342471.00041127.33344208.667

System Info (per dataset)

Property12.3.3-MariaDB12.3.3-MariaDB12.3.3-MariaDB12.3.3-MariaDB
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
OS VersionAlmaLinux 9.7 (Moss Jungle Cat)AlmaLinux 9.7 (Moss Jungle Cat)AlmaLinux 9.7 (Moss Jungle Cat)AlmaLinux 9.7 (Moss Jungle Cat)
OS Kernel5.14.0-611.35.1.el9_7.x86_645.14.0-611.35.1.el9_7.x86_645.14.0-611.35.1.el9_7.x86_645.14.0-611.35.1.el9_7.x86_64
RAM62.33 GB62.33 GB62.33 GB62.33 GB

Database Info (per dataset)

Property12.3.3-MariaDB12.3.3-MariaDB12.3.3-MariaDB12.3.3-MariaDB
Database Makermariadbmariadbmariadbmariadb
Database Version12.3.3-MariaDB12.3.3-MariaDB12.3.3-MariaDB12.3.3-MariaDB
EngineInnoDBInnoDBInnoDBInnoDB
Install Dirmariadb-12.3.3-linux-systemd-x86_64mariadb-12.3.3-linux-systemd-x86_64mariadb-12.3.3-linux-systemd-x86_64mariadb-12.3.3-linux-systemd-x86_64
DB Config OriginCLICLICLICLI
DB Config Source FileMDEV39497_baseline.cnfMDEV39497_rc_isolation.cnfMDEV39497_ru_isolation.cnfMDEV39497_serializable_isolation.cnf
DB Generated Config Run Filemariadb_2026_8_28_22_42_12.cnfmariadb_2026_8_29_03_50_04.cnfmariadb_2026_8_29_06_43_37.cnfmariadb_2026_8_29_21_44_10.cnf
Config Contentsinnodb_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)

Property12.3.3-MariaDB12.3.3-MariaDB12.3.3-MariaDB12.3.3-MariaDB
Test Suitehammerdb-tprocchammerdb-tprocchammerdb-tprocchammerdb-tprocc
Test NameTPROCCTPROCCTPROCCTPROCC
Test Case TagMDEV39497_BASELINEMDEV39497_RC_ISOLATIONMDEV39497_RU_ISOLATIONMDEV39497_SERIALIZABLE_ISOLATION
Duration15151515
Iterations3333
Timestamp2026-8-28 23:04:252026-8-29 04:12:102026-8-29 07:06:072026-8-29 22:05:28
AutoGen Prop Filehammerdb-tprocc_TAF_AUTO_GEN_2026_8_28_22_42_24.propertieshammerdb-tprocc_TAF_AUTO_GEN_2026_8_29_03_50_17.propertieshammerdb-tprocc_TAF_AUTO_GEN_2026_8_29_06_43_54.propertieshammerdb-tprocc_TAF_AUTO_GEN_2026_8_29_21_44_21.properties
Checksum after runtruetruetruetrue
Checksum after setuptruetruetruetrue
Db typemariamariamariamaria
Include html metricstruetruetruetrue
Include html resulttruetruetruetrue
Include html tcounttruetruetruetrue
Include html timingtruetruetruetrue
Include json metricstruetruetruetrue
Include json resulttruetruetruetrue
Include json tcounttruetruetruetrue
Include json timingtruetruetruetrue
Number of warehouses100100100100

Thread Count: 50

Metric12.3.3-MariaDB12.3.3-MariaDB12.3.3-MariaDB12.3.3-MariaDB
Mean44013.3342471.0041127.3344208.67
Max44942.0043167.0041617.0044355.00
Min42517.0041165.0040386.0044108.00
StdDev1068.28924.15533.13105.88
CoV0.020.020.010.00
Median (p50)44581.0043081.0041379.0044163.00
p9544905.9043158.4041593.2044335.80
p9944934.7843165.2841612.2444351.16
Skewness-0.65-0.70-0.600.57
Iteration 142517.0043167.0041617.0044355.00
Iteration 244581.0041165.0040386.0044108.00
Iteration 344942.0043081.0041379.0044163.00