TPROCC

MDEV39497: PERFORMANCE_SCHEMA vs PERFORMANCE_SCHEMA_MEDIUM vs PERFORMANCE_SCHEMA_ALL

Comparison: NOPM

Threads12.3.3-MariaDB12.3.3-MariaDB12.3.3-MariaDB
5044081.33344888.33344047.000

System Info (per dataset)

Property12.3.3-MariaDB12.3.3-MariaDB12.3.3-MariaDB
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-MariaDB12.3.3-MariaDB12.3.3-MariaDB
Database Makermariadbmariadbmariadb
Database Version12.3.3-MariaDB12.3.3-MariaDB12.3.3-MariaDB
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_performance_schema.cnfMDEV39497_performance_schema_medium.cnfMDEV39497_performance_schema_medium.cnf
DB Generated Config Run Filemariadb_2026_8_30_18_20_15.cnfmariadb_2026_8_29_19_51_15.cnfmariadb_2026_8_29_20_47_24.cnf
Config Contentsdefault_authentication_plugin=mysql_native_password
table_open_cache=4000
performance_schema=ON
open_files_limit=65535
innodb_buffer_pool_size=30G
(missing)
(missing)
(missing)
(missing)
default_authentication_plugin=mysql_native_password
table_open_cache=4000
performance_schema=ON
open_files_limit=65535
innodb_buffer_pool_size=30G
performance-schema-consumer-events-stages-history=ON
performance-schema-instrument='stage/%=ON'
performance-schema-consumer-events-stages-current=ON
performance-schema-consumer-events-stages-history-long=ON
default_authentication_plugin=mysql_native_password
table_open_cache=4000
performance_schema=ON
open_files_limit=65535
innodb_buffer_pool_size=30G
performance-schema-consumer-events-stages-history=ON
performance-schema-instrument='stage/%=ON'
performance-schema-consumer-events-stages-current=ON
performance-schema-consumer-events-stages-history-long=ON

Test Info (per dataset)

Property12.3.3-MariaDB12.3.3-MariaDB12.3.3-MariaDB
Test Suitehammerdb-tprocchammerdb-tprocchammerdb-tprocc
Test NameTPROCCTPROCCTPROCC
Test Case TagMDEV39497_PERFORMANCE_SCHEMAMDEV39497_PERFORMANCE_SCHEMA_MEDMDEV39497_PERFORMANCE_SCHEMA_ALL
Duration151515
Iterations333
Timestamp2026-8-30 18:42:282026-8-29 20:12:152026-8-29 21:08:35
AutoGen Prop Filehammerdb-tprocc_TAF_AUTO_GEN_2026_8_30_18_20_27.propertieshammerdb-tprocc_TAF_AUTO_GEN_2026_8_29_19_51_27.propertieshammerdb-tprocc_TAF_AUTO_GEN_2026_8_29_20_47_34.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-MariaDB12.3.3-MariaDB12.3.3-MariaDB
Mean44081.3344888.3344047.00
Max45512.0046239.0045347.00
Min43016.0044022.0043260.00
StdDev1051.22967.71926.02
CoV0.020.020.02
Median (p50)43716.0044404.0043534.00
p9545332.4046055.5045165.70
p9945476.0846202.3045310.74
Skewness0.480.630.66
Iteration 145512.0046239.0045347.00
Iteration 243016.0044404.0043260.00
Iteration 343716.0044022.0043534.00