Date of Test: 2026-9-15 09:44:58
Time of Test: 09:44:58
Framework:               taf-perl
Framework Version:       4
Framework Rev:           0
Framework Patch:         0
taf_commandline_literal: perl ./taf.pl --prop=./properties/mariadb/MDEV39497/MDEV39497_log_slow_query_001_all_all.properties
TAF Commandline:         perl ./taf.pl --prop=./properties/mariadb/MDEV39497/MDEV39497_log_slow_query_001_all_all.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 log_slow_query=ON log_slow_query_time=0.001 log_slow_filter=ALL log_slow_verbosity=ALL [db_config_end] taf.db_ssl_mode=off 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_LOG_SLOW_QUERY_001_ALL_ALL taf.comments="MDEV39497 LOG_SLOW_QUERY_001_ALL_ALL" 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
Test Suite:          hammerdb-tprocc
Test Suite PM File:  hammerdb-tprocc.pm
Test Suite Version:  4
Test Suite Revision: 0
Test Client Version: HammerDB-6.0
Test Name:           TPROCC
Test Type:           adhoc
Comments:            "MDEV39497 LOG_SLOW_QUERY_001_ALL_ALL"
Duration:            15
Iteration:           3
Threads:             50
Warmup Threads:      1
Warmup Duration:     1
Test Host:    hz-bench-jeb
OS:           Linux
OS Version:   AlmaLinux 9.7 (Moss Jungle Cat)
OS Arch:      x86_64
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
test-case-tag:MDEV39497_LOG_SLOW_QUERY_001_ALL_ALL
Database Maker:      mariadb
Database Version:    12.3.3-MariaDB-log
DB Install Dir:      /home/jeb/taf-perl/database_software_installs/mariadb-12.3.3-linux-systemd-x86_64
Database Under Test: test
Database Eng:        InnoDB
Port:                3306
Socket:              /home/jeb/taf-perl/runtime/db.sock
DB Root User:        root
DB User:             mariadb_tester
Db_type:      maria
Notes:        HammerDB TPROCC test suite with config injection and override discipline.
Rampup:       1
Thread_model: client-driven
Warehouses:   5

db_config_origin: USER_PROPERTIES_INLINE_BLOCK
db_config_source_file: ./properties/mariadb/MDEV39497/MDEV39497_log_slow_query_001_all_all.properties
db_config_run_file: /home/jeb/taf-perl/tmp/mariadb_2026_9_15_09_08_34.cnf

generated_properties_file: /home/jeb/taf-perl/reports//hammerdb-tprocc_TAF_AUTO_GEN_2026_9_15_09_08_47.properties
### Auto Generated Test Case User Properties Start ###
#############################################################################
# MDEV39497 HammerDB-TPROCC
#
# URL: https://jira.mariadb.org/browse/MDEV-39497
# Created: Sept 2026
# Version: 2.0
#
#############################################################################
[db_config_start]
[mariadb]
default_authentication_plugin=mysql_native_password

# Baseline overrides (Monty-confirmed)
aria_pagecache_buffer_size=1G
innodb_buffer_pool_size=50G
innodb_log_file_size=1G

## Baseline Defaults
innodb_flush_log_at_trx_commit=1
disable-log-bin
thread_handling=one-thread-per-connection

# Variant
log_slow_query=ON
log_slow_query_time=0.001
log_slow_filter=ALL
log_slow_verbosity=ALL

[db_config_end]

# SSL=0
taf.db_ssl_mode=off

# Action TAF should perform.
taf.action=init-start-db-run-tests

# Report plugins (text, csv, json, chart_html)
taf.report_plugin=taf_res_raw_text.pm,text.pm,chart_and_test_info_results_tables_html.pm,json.pm,csv.pm

# Comment about why this run is being executed
taf.test_case_tag=MDEV39497_LOG_SLOW_QUERY_001_ALL_ALL
taf.comments="MDEV39497 LOG_SLOW_QUERY_001_ALL_ALL"

#############################################################################
# TEST EXECUTION SETTINGS
#############################################################################

# Duration of TPROC-C run in minutes
taf.duration=15

# Number of iterations per thread count
taf.iterations=3

# Test suite to load
taf.test_suite=hammerdb-tprocc

# Test type (adhoc, investigation, production, rerun, release)
taf.test_type=adhoc

# Test case from test suite (hammerdb-tprocc supports only tpcc)
taf.tests=tprocc

# Thread counts to run
taf.threads=50

# HammerDB warmup duration in minutes
taf.warmup_duration=1

#############################################################################
# TIMING CONTROLS
#############################################################################

# Turns on CPU-based rest detection for the DB process.
taf.db_process_rest_enable=true

# CPU percent at or below this value counts as "rest".
taf.db_process_rest_low=6

# CPU percent at or above this value resets the rest counter (DB not idle).
taf.db_process_rest_high=20

#############################################################################
# DATABASE SETTINGS
#############################################################################

# false = use TCP (default)
taf.db_clients_use_unix_socket=true

#############################################################################
# HAMMERDB-TPROCC TEST SUITE SETTINGS
#############################################################################

# Number of warehouses to create and load
hammerdb_tprocc.number_of_warehouses=5

# Database type for TCL configuration
hammerdb_tprocc.db_type=maria

# Checksum after setup
hammerdb_tprocc.checksum_after_setup=true

# Checksum after each run
hammerdb_tprocc.checksum_after_run=true

# HammerDB reports per iteration
# Reports are found in iterations sub results directory

# JSON report options
hammerdb_tprocc.include_json_tcount=true
hammerdb_tprocc.include_json_timing=true
hammerdb_tprocc.include_json_result=true
hammerdb_tprocc.include_json_metrics=true

# HTML report options
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 Debug #####
taf.tools_debug=true
taf.verbose=true
############################
### CLI OVERRIDES FOLLOW ###
############################
### Auto Generated Test Case User Properties End ###
Run Duration Seconds: 1035
Test End Date Time:   2026-9-15 10:02:13
 _EOF_
