TPROCC

MDEV39497: BINLOG BASELINE vs MIN vs NO BLOB

Comparison: NOPM

Threads12.3.3-MariaDB-log12.3.3-MariaDB-log12.3.3-MariaDB-log
5039275.00040976.33340845.667

System Info (per dataset)

Property12.3.3-MariaDB-log12.3.3-MariaDB-log12.3.3-MariaDB-log
Hosthz-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-13500
CPU Count202020
Core Count141414
Socket Count111
OSLinuxLinuxLinux
OS VersionAlmaLinux 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_64
RAM62.33 GB62.33 GB62.33 GB

Database Info (per dataset)

Property12.3.3-MariaDB-log12.3.3-MariaDB-log12.3.3-MariaDB-log
Database Makermariadbmariadbmariadb
Database Version12.3.3-MariaDB-log12.3.3-MariaDB-log12.3.3-MariaDB-log
EngineInnoDBInnoDBInnoDB
Install Dirmariadb-12.3.3-linux-systemd-x86_64mariadb-12.3.3-linux-systemd-x86_64mariadb-12.3.3-linux-systemd-x86_64
DB Config OriginCLICLICLI
DB Config Source FileMDEV39497_binlog.cnfMDEV39497_binlog_min.cnfMDEV39497_binlog_noblob.cnf
DB Generated Config Run Filemariadb_2026_8_29_04_47_29.cnfmariadb_2026_8_29_16_17_57.cnfmariadb_2026_8_29_17_14_24.cnf
Config Contentstable_open_cache=4000
innodb_buffer_pool_size=30G
open_files_limit=65535
default_authentication_plugin=mysql_native_password
log_bin=ON
(missing)
table_open_cache=4000
innodb_buffer_pool_size=30G
open_files_limit=65535
default_authentication_plugin=mysql_native_password
log_bin=ON
binlog_row_image=MINIMAL
table_open_cache=4000
innodb_buffer_pool_size=30G
open_files_limit=65535
default_authentication_plugin=mysql_native_password
log_bin=ON
binlog_row_image=NOBLOB

Test Info (per dataset)

Property12.3.3-MariaDB-log12.3.3-MariaDB-log12.3.3-MariaDB-log
Test Suitehammerdb-tprocchammerdb-tprocchammerdb-tprocc
Test NameTPROCCTPROCCTPROCC
Test Case TagMDEV39497_BINLOGMDEV39497_BINLOG_MINMDEV39497_BINLOG_NOBLOB
Duration151515
Iterations333
Timestamp2026-8-29 05:10:022026-8-29 16:39:132026-8-29 17:35:53
AutoGen Prop Filehammerdb-tprocc_TAF_AUTO_GEN_2026_8_29_04_47_41.propertieshammerdb-tprocc_TAF_AUTO_GEN_2026_8_29_16_18_08.propertieshammerdb-tprocc_TAF_AUTO_GEN_2026_8_29_17_14_37.properties
Checksum after runtruetruetrue
Checksum after setuptruetruetrue
Db typemariamariamaria
Include html metricstruetruetrue
Include html resulttruetruetrue
Include html tcounttruetruetrue
Include html timingtruetruetrue
Include json metricstruetruetrue
Include json resulttruetruetrue
Include json tcounttruetruetrue
Include json timingtruetruetrue
Number of warehouses100100100

Thread Count: 50

Metric12.3.3-MariaDB-log12.3.3-MariaDB-log12.3.3-MariaDB-log
Mean39275.0040976.3340845.67
Max40045.0042009.0041531.00
Min38542.0040432.0040217.00
StdDev614.15730.56537.93
CoV0.020.020.01
Median (p50)39238.0040488.0040789.00
p9539964.3041856.9041456.80
p9940028.8641978.5841516.16
Skewness0.090.700.16
Iteration 140045.0042009.0041531.00
Iteration 238542.0040488.0040789.00
Iteration 339238.0040432.0040217.00