
=== Performance Report: TPROCC ===

Timestamp:             2026-9-24 18:10:37
Test Name:             TPROCC
Comments:              MDEV39497 SSL
TAF Commandline:       perl ./taf.pl --prop=./properties/mariadb/MDEV39497/MDEV39497_ssl.properties :: 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 disable-log-bin thread_handling=one-thread-per-connection [db_config_end] taf.db_ssl_mode=required taf.db_ssl_ca=/home/jeb/taf-perl/database_software_installs/mariadb-12.3.3-linux-systemd-x86_64/ssl/ca.pem taf.db_ssl_cert=/home/jeb/taf-perl/database_software_installs/mariadb-12.3.3-linux-systemd-x86_64/ssl/client-cert.pem taf.db_ssl_key=/home/jeb/taf-perl/database_software_installs/mariadb-12.3.3-linux-systemd-x86_64/ssl/client-key.pem taf.db_ssl_linux_capath=/home/jeb/ taf.db_use_native_for_passwords=false 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.test_case_tag=MDEV39497_SSL taf.comments="MDEV39497 SSL" 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=0 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:            17:53:51
End Time:              18:45:52
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
DB Config Origin:      USER_PROPERTIES_INLINE_BLOCK
DB Config Source File: ./properties/mariadb/MDEV39497/MDEV39497_ssl.properties
DB Config Run File:    /home/jeb/taf-perl/tmp/mariadb_2026_9_24_17_52_16.cnf

=== 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
  disable-log-bin
  thread_handling=one-thread-per-connection

=== 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
db_type:               maria
generated_properties_file: /home/jeb/taf-perl/reports//hammerdb-tprocc_TAF_AUTO_GEN_2026_9_24_17_52_31.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:  1006
socket_count:          1
taf_commandline_literal: perl ./taf.pl --prop=./properties/mariadb/MDEV39497/MDEV39497_ssl.properties
test_case_tag:         MDEV39497_SSL
test_end_date_time:    2026-9-24 18:10:37
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: 173582

-- Additional Metrics --
Elapsed_Time_ms                      959001 ms
TPM                                  403265 txns/minute
NEWORD_ratio                         46.309 percent
PAYMENT                               7.786 ms
PAYMENT_calls                       2757363 
PAYMENT_total_ms                   21467484 ms
PAYMENT_ratio                        44.771 percent
DELIVERY                              11.96 ms
DELIVERY_calls                       275158 
DELIVERY_total_ms                   3290949 ms
DELIVERY_ratio                        6.863 percent
OSTAT                                 1.199 ms
OSTAT_calls                          275298 
OSTAT_total_ms                       329954 ms
OSTAT_ratio                           0.688 percent
SLEV                                  1.231 ms
SLEV_calls                           275489 
SLEV_total_ms                        339030 ms
SLEV_ratio                            0.707 percent

Thread Count: 50   |   Iteration: 2
NOPM: 167898

-- Additional Metrics --
Elapsed_Time_ms                      961100 ms
TPM                                  390267 txns/minute
NEWORD_ratio                         45.982 percent
PAYMENT                               7.962 ms
PAYMENT_calls                       2716877 
PAYMENT_total_ms                   21630744 ms
PAYMENT_ratio                        45.012 percent
DELIVERY                             12.214 ms
DELIVERY_calls                       271559 
DELIVERY_total_ms                   3316734 ms
DELIVERY_ratio                        6.902 percent
OSTAT                                 1.274 ms
OSTAT_calls                          271663 
OSTAT_total_ms                       346186 ms
OSTAT_ratio                            0.72 percent
SLEV                                  1.217 ms
SLEV_calls                           271094 
SLEV_total_ms                        329960 ms
SLEV_ratio                            0.687 percent

Thread Count: 50   |   Iteration: 3
NOPM: 165535

-- Additional Metrics --
Elapsed_Time_ms                      959668 ms
TPM                                  384102 txns/minute
NEWORD_ratio                         46.102 percent
PAYMENT                               8.085 ms
PAYMENT_calls                       2670380 
PAYMENT_total_ms                   21590349 ms
PAYMENT_ratio                        44.995 percent
DELIVERY                             12.316 ms
DELIVERY_calls                       266748 
DELIVERY_total_ms                   3285314 ms
DELIVERY_ratio                        6.847 percent
OSTAT                                 1.265 ms
OSTAT_calls                          266760 
OSTAT_total_ms                       337480 ms
OSTAT_ratio                           0.703 percent
SLEV                                  1.212 ms
SLEV_calls                           266996 
SLEV_total_ms                        323583 ms
SLEV_ratio                            0.674 percent


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

DELIVERY                       Count:   3   Min:      11.96   Max:      12.32   Avg:      12.16
DELIVERY_calls                 Count:   3   Min:  266748.00   Max:  275158.00   Avg:  271155.00
DELIVERY_ratio                 Count:   3   Min:       6.85   Max:       6.90   Avg:       6.87
DELIVERY_total_ms              Count:   3   Min: 3285314.00   Max: 3316734.00   Avg: 3297665.67
Elapsed_Time_ms                Count:   3   Min:  959001.00   Max:  961100.00   Avg:  959923.00
NEWORD_ratio                   Count:   3   Min:      45.98   Max:      46.31   Avg:      46.13
NOPM                           Count:   3   Min:  165535.00   Max:  173582.00   Avg:  169005.00
OSTAT                          Count:   3   Min:       1.20   Max:       1.27   Avg:       1.25
OSTAT_calls                    Count:   3   Min:  266760.00   Max:  275298.00   Avg:  271240.33
OSTAT_ratio                    Count:   3   Min:       0.69   Max:       0.72   Avg:       0.70
OSTAT_total_ms                 Count:   3   Min:  329954.00   Max:  346186.00   Avg:  337873.33
PAYMENT                        Count:   3   Min:       7.79   Max:       8.09   Avg:       7.94
PAYMENT_calls                  Count:   3   Min: 2670380.00   Max: 2757363.00   Avg: 2714873.33
PAYMENT_ratio                  Count:   3   Min:      44.77   Max:      45.01   Avg:      44.93
PAYMENT_total_ms               Count:   3   Min: 21467484.00   Max: 21630744.00   Avg: 21562859.00
SLEV                           Count:   3   Min:       1.21   Max:       1.23   Avg:       1.22
SLEV_calls                     Count:   3   Min:  266996.00   Max:  275489.00   Avg:  271193.00
SLEV_ratio                     Count:   3   Min:       0.67   Max:       0.71   Avg:       0.69
SLEV_total_ms                  Count:   3   Min:  323583.00   Max:  339030.00   Avg:  330857.67
TPM                            Count:   3   Min:  384102.00   Max:  403265.00   Avg:  392544.67
