
=== Performance Report: TPROCC ===

Timestamp:             2026-9-17 23:27:01
Test Name:             TPROCC
Comments:              MDEV39497 BINLOG
TAF Commandline:       perl ./taf.pl --prop=./properties/mariadb/MDEV39497/MDEV39497_binlog.properties --test-case-tag=MDEV39497_BIN_LOG_ATTACHED_REPLICAT --action=run-tests :: prop file contents -> [db_config_start] [mariadb] default_authentication_plugin=mysql_native_password aria_pagecache_buffer_size=1G innodb_buffer_pool_size=50G innodb_log_file_size=1G innodb_flush_log_at_trx_commit=1 thread_handling=one-thread-per-connection log_bin=ON server_id=1 [db_config_end] taf.db_ssl_mode=off taf.test_case_tag=MDEV39497_BINLOG taf.action=init-start-db-run-tests taf.report_plugin=taf_res_raw_text.pm,text.pm,chart_and_test_info_results_tables_html.pm,json.pm,csv.pm taf.comments="MDEV39497 BINLOG" taf.duration=15 taf.iterations=3 taf.test_suite=hammerdb-tprocc taf.test_type=adhoc taf.tests=tprocc taf.threads=50 taf.warmup_duration=1 taf.db_process_rest_enable=true taf.db_process_rest_low=6 taf.db_process_rest_high=20 taf.db_clients_use_unix_socket=true hammerdb_tprocc.number_of_warehouses=5 hammerdb_tprocc.db_type=maria hammerdb_tprocc.checksum_after_setup=true hammerdb_tprocc.checksum_after_run=true hammerdb_tprocc.include_json_tcount=true hammerdb_tprocc.include_json_timing=true hammerdb_tprocc.include_json_result=true hammerdb_tprocc.include_json_metrics=true hammerdb_tprocc.include_html_tcount=true hammerdb_tprocc.include_html_timing=true hammerdb_tprocc.include_html_result=true hammerdb_tprocc.include_html_metrics=true taf.tools_debug=true taf.verbose=true

=== TAF Info ===

Framework:             taf-perl
Framework Version:     4
Framework Rev:         0
Framework Patch:       0

=== Host Info ===

Test Host:             hz-bench-jeb
OS:                    Linux
OS Version:            AlmaLinux 9.7 (Moss Jungle Cat)
OS Kernel:             5.14.0-611.35.1.el9_7.x86_64
CPU:                   13th Gen Intel(R) Core(TM) i5-13500
CPU COUNT:             20
CORE COUNT:            14
SOCKET COUNT:          1
RAM:                   62.33 GB
Disk:                  N/A

=== Test Suite Info ===

Test Suite:            hammerdb-tprocc
Suite Version:         4
Suite Revision:        0
Suite Source File:     N/A

=== Test Info ===

Start Time:            23:10:22
End Time:              00:00:35
Iterations:            3
Test Type:             adhoc
Duration:              15
Warmup Threads:        1
Warmup Duration:       1

=== Database Info ===

Maker:                 mariadb
Install Dir:           /home/jeb/taf-perl/database_software_installs/mariadb-12.3.3-linux-systemd-x86_64
Under Test:            test
Engine:                InnoDB
Port:                  3306
Socket:                /home/jeb/taf-perl/runtime/db.sock
DB User:               mariadb_tester
DB Root User:          root
DB Version:            12.3.3-MariaDB-log
DB Config Origin:      N/A
DB Config Source File: N/A
DB Config Run File:    N/A

=== DB Config ===

  [mariadb]
  default_authentication_plugin=mysql_native_password
  aria_pagecache_buffer_size=1G
  innodb_buffer_pool_size=50G
  innodb_log_file_size=1G
  innodb_flush_log_at_trx_commit=1
  thread_handling=one-thread-per-connection
  log_bin=ON
  server_id=1

=== Extra Metadata ===

backend_config:        N/A
backend_parser_jar:    ./libs/reporter_libs/backend/working/BackendParser.jar
core_count:            14
cpu_count:             20
created:               Sept 2026
database_version:      12.3.3-MariaDB-log
db_type:               maria
generated_properties_file: /home/jeb/taf-perl/reports//hammerdb-tprocc_TAF_AUTO_GEN_2026_9_17_23_09_29.properties
java_bin:              N/A
jdbc_jar:              N/A
json_jar:              N/A
notes:                 HammerDB TPROCC test suite with config injection and override discipline.
rampup:                1
results_iteration_allowed_duration_drift_pct: 10
results_threshold_fail_pct: 5
results_threshold_gain_pct: 5
results_threshold_warning_pct: 3
run_duration_seconds:  999
socket_count:          1
taf_commandline_literal: perl ./taf.pl --prop=./properties/mariadb/MDEV39497/MDEV39497_binlog.properties --test-case-tag=MDEV39497_BIN_LOG_ATTACHED_REPLICAT --action=run-tests
test_case_tag:         MDEV39497_BIN_LOG_ATTACHED_REPLICAT
test_end_date_time:    2026-9-17 23:27:01
test_suite_pm_file:    hammerdb-tprocc.pm
thread_count:          50
thread_model:          client-driven
url:                   https://jira.mariadb.org/browse/MDEV-39497
version:               2.0
warehouses:            5

=== Metrics ===

Thread Count: 50   |   Iteration: 1
NOPM: 45356

-- Additional Metrics --
Elapsed_Time_ms                      960544 ms
TPM                                  105350 txns/minute
NEWORD_ratio                         11.631 percent
PAYMENT                              58.662 ms
PAYMENT_calls                        708532 
PAYMENT_total_ms                   41563761 ms
PAYMENT_ratio                        86.542 percent
DELIVERY                             10.083 ms
DELIVERY_calls                        70798 
DELIVERY_total_ms                    713885 ms
DELIVERY_ratio                        1.486 percent
OSTAT                                 0.761 ms
OSTAT_calls                           70776 
OSTAT_total_ms                        53843 ms
OSTAT_ratio                           0.112 percent
SLEV                                  0.834 ms
SLEV_calls                            70901 
SLEV_total_ms                         59096 ms
SLEV_ratio                            0.123 percent

Thread Count: 50   |   Iteration: 2
NOPM: 47453

-- Additional Metrics --
Elapsed_Time_ms                      961834 ms
TPM                                  110183 txns/minute
NEWORD_ratio                         11.764 percent
PAYMENT                              53.819 ms
PAYMENT_calls                        771518 
PAYMENT_total_ms                   41522193 ms
PAYMENT_ratio                         86.34 percent
DELIVERY                              9.716 ms
DELIVERY_calls                        77736 
DELIVERY_total_ms                    755273 ms
DELIVERY_ratio                         1.57 percent
OSTAT                                 0.794 ms
OSTAT_calls                           77369 
OSTAT_total_ms                        61447 ms
OSTAT_ratio                           0.128 percent
SLEV                                  0.824 ms
SLEV_calls                            77180 
SLEV_total_ms                         63624 ms
SLEV_ratio                            0.132 percent

Thread Count: 50   |   Iteration: 3
NOPM: 46166

-- Additional Metrics --
Elapsed_Time_ms                      960828 ms
TPM                                  107203 txns/minute
NEWORD_ratio                         11.466 percent
PAYMENT                              55.467 ms
PAYMENT_calls                        750440 
PAYMENT_total_ms                   41624583 ms
PAYMENT_ratio                        86.643 percent
DELIVERY                              9.835 ms
DELIVERY_calls                        74911 
DELIVERY_total_ms                    736727 ms
DELIVERY_ratio                        1.534 percent
OSTAT                                  0.81 ms
OSTAT_calls                           75022 
OSTAT_total_ms                        60734 ms
OSTAT_ratio                           0.126 percent
SLEV                                  0.828 ms
SLEV_calls                            75038 
SLEV_total_ms                         62126 ms
SLEV_ratio                            0.129 percent


=== Summary for Thread Count: 50 ===

DELIVERY                       Count:   3   Min:       9.72   Max:      10.08   Avg:       9.88
DELIVERY_calls                 Count:   3   Min:   70798.00   Max:   77736.00   Avg:   74481.67
DELIVERY_ratio                 Count:   3   Min:       1.49   Max:       1.57   Avg:       1.53
DELIVERY_total_ms              Count:   3   Min:  713885.00   Max:  755273.00   Avg:  735295.00
Elapsed_Time_ms                Count:   3   Min:  960544.00   Max:  961834.00   Avg:  961068.67
NEWORD_ratio                   Count:   3   Min:      11.47   Max:      11.76   Avg:      11.62
NOPM                           Count:   3   Min:   45356.00   Max:   47453.00   Avg:   46325.00
OSTAT                          Count:   3   Min:       0.76   Max:       0.81   Avg:       0.79
OSTAT_calls                    Count:   3   Min:   70776.00   Max:   77369.00   Avg:   74389.00
OSTAT_ratio                    Count:   3   Min:       0.11   Max:       0.13   Avg:       0.12
OSTAT_total_ms                 Count:   3   Min:   53843.00   Max:   61447.00   Avg:   58674.67
PAYMENT                        Count:   3   Min:      53.82   Max:      58.66   Avg:      55.98
PAYMENT_calls                  Count:   3   Min:  708532.00   Max:  771518.00   Avg:  743496.67
PAYMENT_ratio                  Count:   3   Min:      86.34   Max:      86.64   Avg:      86.51
PAYMENT_total_ms               Count:   3   Min: 41522193.00   Max: 41624583.00   Avg: 41570179.00
SLEV                           Count:   3   Min:       0.82   Max:       0.83   Avg:       0.83
SLEV_calls                     Count:   3   Min:   70901.00   Max:   77180.00   Avg:   74373.00
SLEV_ratio                     Count:   3   Min:       0.12   Max:       0.13   Avg:       0.13
SLEV_total_ms                  Count:   3   Min:   59096.00   Max:   63624.00   Avg:   61615.33
TPM                            Count:   3   Min:  105350.00   Max:  110183.00   Avg:  107578.67
