11. CLI Example Scripts driven by Bash and Powershell

The default HammerDB installation includes a scripts directory that contains example scripts for both TPROC-C and TPROC-H workloads for all databases in both Tcl and Python format to provide a template for updating and modifying scripts for an individual environment.

At a minimum you should update the connection parameters in the scripts you wish to run for your environment. Additionally the default scripts will size the workload and run the number of Virtual Users according to the number of CPUs on the system where HammerDB is running and therefore if running the client on a separate system to the database then the number of virtual users and schema sizes should be modified accordingly.

All target directories include driver scripts in powershell for Windows and bash for Linux to run an automated sequence of scripts to build, test, delete and query results for a workload. These driver scripts should be run with the full path to the script from the HammerDB home directory for example on Windows:

powershell scripts\python\mssqls\tproch\mssqls_tproch_py.ps1

and on Linux

./scripts/tcl/maria/tprocc/maria_tprocc.sh

Example output for MariaDB is shown as follows:

./scripts/tcl/maria/tprocc/maria_tprocc.sh 
BUILD HAMMERDB SCHEMA
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
HammerDB CLI v5.0
Copyright © HammerDB Ltd hosted by tpc.org 2019-2025
Type "help" for a list of commands
Initialized Jobs on-disk database /opt/HammerDB-5.0/TMP/hammer.DB using existing tables (1,449,984 bytes)
SETTING CONFIGURATION
Database set to MariaDB
Benchmark set to TPC-C for MariaDB
Value localhost for connection:maria_host is the same as existing value localhost, no change made
Value 3306 for connection:maria_port is the same as existing value 3306, no change made
Value /tmp/mariadb.sock for connection:maria_socket is the same as existing value /tmp/mariadb.sock, no change made
Value 120 for tpcc:maria_count_ware is the same as existing value 120, no change made
Value 24 for tpcc:maria_num_vu is the same as existing value 24, no change made
Value root for tpcc:maria_user is the same as existing value root, no change made
Value maria for tpcc:maria_pass is the same as existing value maria, no change made
Value tpcc for tpcc:maria_dbase is the same as existing value tpcc, no change made
Value innodb for tpcc:maria_storage_engine is the same as existing value innodb, no change made
Value false for tpcc:maria_partition is the same as existing value false, no change made
SCHEMA BUILD STARTED
Script cleared
Building 120 Warehouses with 25 Virtual Users, 24 active + 1 Monitor VU(dict value maria_num_vu is set to 24)
Ready to create a 120 Warehouse MariaDB TPROC-C schema
in host LOCALHOST:/TMP/MARIADB.SOCK under user ROOT in database TPCC with storage engine INNODB?
Enter yes or no: replied yes
Vuser 1 created - WAIT IDLE
Vuser 2 created - WAIT IDLE
Vuser 3 created - WAIT IDLE
Vuser 4 created - WAIT IDLE
Vuser 5 created - WAIT IDLE
Vuser 6 created - WAIT IDLE
Vuser 7 created - WAIT IDLE
Vuser 8 created - WAIT IDLE
Vuser 9 created - WAIT IDLE
Vuser 10 created - WAIT IDLE
Vuser 11 created - WAIT IDLE
Vuser 12 created - WAIT IDLE
Vuser 13 created - WAIT IDLE
Vuser 14 created - WAIT IDLE
Vuser 15 created - WAIT IDLE
Vuser 16 created - WAIT IDLE
Vuser 17 created - WAIT IDLE
Vuser 18 created - WAIT IDLE
Vuser 19 created - WAIT IDLE
Vuser 20 created - WAIT IDLE
Vuser 21 created - WAIT IDLE
Vuser 22 created - WAIT IDLE
Vuser 23 created - WAIT IDLE
Vuser 24 created - WAIT IDLE
Vuser 25 created - WAIT IDLE
Vuser 1:RUNNING
Vuser 1:Monitor Thread
Vuser 1:CREATING TPCC SCHEMA
Vuser 1:Ssl_cipher 
Vuser 1:CHECKING IF DATABASE tpcc EXISTS
Vuser 1:CREATING DATABASE tpcc
Vuser 1:CREATING TPCC TABLES
Vuser 1:Loading Item
….
Vuser 1:CREATING TPCC STORED PROCEDURES
Vuser 1:GATHERING SCHEMA STATISTICS
Vuser 1:TPCC SCHEMA COMPLETE
Vuser 1:FINISHED SUCCESS
ALL VIRTUAL USERS COMPLETE
SCHEMA BUILD COMPLETED
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
CHECK HAMMERDB SCHEMA
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
HammerDB CLI v5.0
Copyright © HammerDB Ltd hosted by tpc.org 2019-2025
Type "help" for a list of commands
Initialized Jobs on-disk database /opt/HammerDB-5.0/TMP/hammer.DB using existing tables (1,404,928 bytes)
SETTING CONFIGURATION
Database set to MariaDB
Benchmark set to TPC-C for MariaDB
Value localhost for connection:maria_host is the same as existing value localhost, no change made
Value 3306 for connection:maria_port is the same as existing value 3306, no change made
Value /tmp/mariadb.sock for connection:maria_socket is the same as existing value /tmp/mariadb.sock, no change made
Value root for tpcc:maria_user is the same as existing value root, no change made
Value maria for tpcc:maria_pass is the same as existing value maria, no change made
Value tpcc for tpcc:maria_dbase is the same as existing value tpcc, no change made
 CHECK SCHEMA STARTED
Script cleared
Checking schema with 1 Virtual User
Do you want to check the TPCC TPROC-C schema
 in host LOCALHOST:/TMP/MARIADB.SOCK under user ROOT?
Enter yes or no: replied yes
Vuser 1 created - WAIT IDLE
Vuser 1:RUNNING
Vuser 1:Checking tpcc TPROC-C schema
Vuser 1:Ssl_cipher 
Vuser 1:Check database
Vuser 1:Check tables and indices
Vuser 1:Check procedures
Vuser 1:Check consistency 1
Vuser 1:Check consistency 2
Vuser 1:Check consistency 3
Vuser 1:Check consistency 4
Vuser 1:tpcc TPROC-C Schema has been checked successfully.
Vuser 1:FINISHED SUCCESS
ALL VIRTUAL USERS COMPLETE
CHECK SCHEMA COMPLETED
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
RUN HAMMERDB TEST
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
HammerDB CLI v5.0
Copyright © HammerDB Ltd hosted by tpc.org 2019-2025
Type "help" for a list of commands
Initialized Jobs on-disk database /opt/HammerDB-5.0/TMP/hammer.DB using existing tables (1,409,024 bytes)
SETTING CONFIGURATION
Database set to MariaDB
Benchmark set to TPC-C for MariaDB
Value localhost for connection:maria_host is the same as existing value localhost, no change made
Value 3306 for connection:maria_port is the same as existing value 3306, no change made
Value /tmp/mariadb.sock for connection:maria_socket is the same as existing value /tmp/mariadb.sock, no change made
Value root for tpcc:maria_user is the same as existing value root, no change made
Value maria for tpcc:maria_pass is the same as existing value maria, no change made
Value tpcc for tpcc:maria_dbase is the same as existing value tpcc, no change made
Value timed for tpcc:maria_driver is the same as existing value timed, no change made
Value 2 for tpcc:maria_rampup is the same as existing value 2, no change made
Value 5 for tpcc:maria_duration is the same as existing value 5, no change made
Changed tpcc:maria_allwarehouse from false to true for MariaDB
Changed tpcc:maria_timeprofile from false to true for MariaDB
Script loaded, Type "print script" to view
TEST STARTED
Vuser 1 created MONITOR - WAIT IDLE
Vuser 2 created - WAIT IDLE
Vuser 3 created - WAIT IDLE
Vuser 4 created - WAIT IDLE
Vuser 5 created - WAIT IDLE
Vuser 6 created - WAIT IDLE
Vuser 7 created - WAIT IDLE
Vuser 8 created - WAIT IDLE
Vuser 9 created - WAIT IDLE
Vuser 10 created - WAIT IDLE
Vuser 11 created - WAIT IDLE
Vuser 12 created - WAIT IDLE
Vuser 13 created - WAIT IDLE
Vuser 14 created - WAIT IDLE
Vuser 15 created - WAIT IDLE
Vuser 16 created - WAIT IDLE
Vuser 17 created - WAIT IDLE
Vuser 18 created - WAIT IDLE
Vuser 19 created - WAIT IDLE
Vuser 20 created - WAIT IDLE
Vuser 21 created - WAIT IDLE
Vuser 22 created - WAIT IDLE
Vuser 23 created - WAIT IDLE
Vuser 24 created - WAIT IDLE
Vuser 25 created - WAIT IDLE
25 Virtual Users Created with Monitor VU
Transaction Counter Started
Transaction Counter thread running with threadid:tid0x7ba2fcc00640
Vuser 1:RUNNING
Vuser 1:Initializing xtprof time profiler
0 MariaDB tpm
Vuser 1:Ssl_cipher 
Vuser 1:DBVersion:11.8.1
Vuser 1:Beginning rampup time of 2 minutes
Vuser 2:RUNNING
Vuser 2:Initializing xtprof time profiler
Vuser 2:Ssl_cipher 
Vuser 2:Assigned 5 WIDs = 1 25 49 73 97 based on VU count 24, Warehouses = 5 out of 120
Vuser 2:Processing 10000000 transactions with output suppressed...
Vuser 3:RUNNING
Vuser 3:Initializing xtprof time profiler
Vuser 3:Ssl_cipher 
Vuser 3:Assigned 5 WIDs = 2 26 50 74 98 based on VU count 24, Warehouses = 5 out of 120
Vuser 3:Processing 10000000 transactions with output suppressed...
Vuser 4:RUNNING
Vuser 4:Initializing xtprof time profiler
Vuser 4:Ssl_cipher 
Vuser 4:Assigned 5 WIDs = 3 27 51 75 99 based on VU count 24, Warehouses = 5 out of 120
Vuser 4:Processing 10000000 transactions with output suppressed...
Vuser 5:RUNNING
Vuser 5:Initializing xtprof time profiler
Vuser 5:Ssl_cipher 
Vuser 5:Assigned 5 WIDs = 4 28 52 76 100 based on VU count 24, Warehouses = 5 out of 120
Vuser 5:Processing 10000000 transactions with output suppressed...
Vuser 6:RUNNING
Vuser 6:Initializing xtprof time profiler
Vuser 6:Ssl_cipher 
Vuser 6:Assigned 5 WIDs = 5 29 53 77 101 based on VU count 24, Warehouses = 5 out of 120
Vuser 6:Processing 10000000 transactions with output suppressed...
Vuser 7:RUNNING
Vuser 7:Initializing xtprof time profiler
Vuser 7:Ssl_cipher 
Vuser 7:Assigned 5 WIDs = 6 30 54 78 102 based on VU count 24, Warehouses = 5 out of 120
Vuser 7:Processing 10000000 transactions with output suppressed...
Vuser 8:RUNNING
Vuser 8:Initializing xtprof time profiler
Vuser 8:Ssl_cipher 
Vuser 8:Assigned 5 WIDs = 7 31 55 79 103 based on VU count 24, Warehouses = 5 out of 120
Vuser 8:Processing 10000000 transactions with output suppressed...
Vuser 9:RUNNING
Vuser 9:Initializing xtprof time profiler
Vuser 9:Ssl_cipher 
Vuser 9:Assigned 5 WIDs = 8 32 56 80 104 based on VU count 24, Warehouses = 5 out of 120
Vuser 9:Processing 10000000 transactions with output suppressed...
Vuser 10:RUNNING
Vuser 10:Initializing xtprof time profiler
Vuser 10:Ssl_cipher 
Vuser 10:Assigned 5 WIDs = 9 33 57 81 105 based on VU count 24, Warehouses = 5 out of 120
Vuser 10:Processing 10000000 transactions with output suppressed...
Vuser 11:RUNNING
Vuser 11:Initializing xtprof time profiler
Vuser 11:Ssl_cipher 
Vuser 11:Assigned 5 WIDs = 10 34 58 82 106 based on VU count 24, Warehouses = 5 out of 120
Vuser 11:Processing 10000000 transactions with output suppressed...
Vuser 12:RUNNING
Vuser 12:Initializing xtprof time profiler
Vuser 12:Ssl_cipher 
Vuser 12:Assigned 5 WIDs = 11 35 59 83 107 based on VU count 24, Warehouses = 5 out of 120
Vuser 12:Processing 10000000 transactions with output suppressed...
Vuser 13:RUNNING
Vuser 13:Initializing xtprof time profiler
Vuser 13:Ssl_cipher 
Vuser 13:Assigned 5 WIDs = 12 36 60 84 108 based on VU count 24, Warehouses = 5 out of 120
Vuser 13:Processing 10000000 transactions with output suppressed...
Vuser 14:RUNNING
Vuser 14:Initializing xtprof time profiler
Vuser 14:Ssl_cipher 
Vuser 14:Assigned 5 WIDs = 13 37 61 85 109 based on VU count 24, Warehouses = 5 out of 120
Vuser 14:Processing 10000000 transactions with output suppressed...
Vuser 15:RUNNING
Vuser 15:Initializing xtprof time profiler
Vuser 15:Ssl_cipher 
Vuser 15:Assigned 5 WIDs = 14 38 62 86 110 based on VU count 24, Warehouses = 5 out of 120
Vuser 15:Processing 10000000 transactions with output suppressed...
Vuser 16:RUNNING
Vuser 16:Initializing xtprof time profiler
Vuser 16:Ssl_cipher 
Vuser 16:Assigned 5 WIDs = 15 39 63 87 111 based on VU count 24, Warehouses = 5 out of 120
Vuser 16:Processing 10000000 transactions with output suppressed...
Vuser 17:RUNNING
Vuser 17:Initializing xtprof time profiler
Vuser 17:Ssl_cipher 
Vuser 17:Assigned 5 WIDs = 16 40 64 88 112 based on VU count 24, Warehouses = 5 out of 120
Vuser 17:Processing 10000000 transactions with output suppressed...
Vuser 18:RUNNING
Vuser 18:Initializing xtprof time profiler
Vuser 18:Ssl_cipher 
Vuser 18:Assigned 5 WIDs = 17 41 65 89 113 based on VU count 24, Warehouses = 5 out of 120
Vuser 18:Processing 10000000 transactions with output suppressed...
Vuser 19:RUNNING
Vuser 19:Initializing xtprof time profiler
Vuser 19:Ssl_cipher 
Vuser 19:Assigned 5 WIDs = 18 42 66 90 114 based on VU count 24, Warehouses = 5 out of 120
Vuser 19:Processing 10000000 transactions with output suppressed...
Vuser 20:RUNNING
Vuser 20:Initializing xtprof time profiler
Vuser 20:Ssl_cipher 
Vuser 20:Assigned 5 WIDs = 19 43 67 91 115 based on VU count 24, Warehouses = 5 out of 120
Vuser 20:Processing 10000000 transactions with output suppressed...
Vuser 21:RUNNING
Vuser 21:Initializing xtprof time profiler
185196 MariaDB tpm
Vuser 21:Ssl_cipher 
Vuser 21:Assigned 5 WIDs = 20 44 68 92 116 based on VU count 24, Warehouses = 5 out of 120
Vuser 21:Processing 10000000 transactions with output suppressed...
Vuser 22:RUNNING
Vuser 22:Initializing xtprof time profiler
Vuser 22:Ssl_cipher 
Vuser 22:Assigned 5 WIDs = 21 45 69 93 117 based on VU count 24, Warehouses = 5 out of 120
Vuser 22:Processing 10000000 transactions with output suppressed...
Vuser 23:RUNNING
Vuser 23:Initializing xtprof time profiler
Vuser 23:Ssl_cipher 
Vuser 23:Assigned 5 WIDs = 22 46 70 94 118 based on VU count 24, Warehouses = 5 out of 120
Vuser 23:Processing 10000000 transactions with output suppressed...
Vuser 24:RUNNING
Vuser 24:Initializing xtprof time profiler
Vuser 24:Ssl_cipher 
Vuser 24:Assigned 5 WIDs = 23 47 71 95 119 based on VU count 24, Warehouses = 5 out of 120
Vuser 24:Processing 10000000 transactions with output suppressed...
Vuser 25:RUNNING
Vuser 25:Initializing xtprof time profiler
Vuser 25:Ssl_cipher 
Vuser 25:Assigned 5 WIDs = 24 48 72 96 120 based on VU count 24, Warehouses = 5 out of 120
Vuser 25:Processing 10000000 transactions with output suppressed...
309240 MariaDB tpm
303012 MariaDB tpm
308850 MariaDB tpm
300828 MariaDB tpm
Vuser 1:Rampup 1 minutes complete ...
294708 MariaDB tpm
291780 MariaDB tpm
309612 MariaDB tpm
292572 MariaDB tpm
308898 MariaDB tpm
294198 MariaDB tpm
Vuser 1:Rampup 2 minutes complete ...
Vuser 1:Rampup complete, Taking start Transaction Count.
Vuser 1:Timing test period of 5 in minutes
295320 MariaDB tpm
296226 MariaDB tpm
292506 MariaDB tpm
296832 MariaDB tpm
298662 MariaDB tpm
296694 MariaDB tpm
Vuser 1:1 ...,
304416 MariaDB tpm
295938 MariaDB tpm
295140 MariaDB tpm
300540 MariaDB tpm
297570 MariaDB tpm
296370 MariaDB tpm
Vuser 1:2 ...,
298410 MariaDB tpm
299760 MariaDB tpm
297546 MariaDB tpm
296340 MariaDB tpm
297756 MariaDB tpm
291090 MariaDB tpm
Vuser 1:3 ...,
294612 MariaDB tpm
309450 MariaDB tpm
295866 MariaDB tpm
291948 MariaDB tpm
297936 MariaDB tpm
294774 MariaDB tpm
Vuser 1:4 ...,
295446 MariaDB tpm
301026 MariaDB tpm
304896 MariaDB tpm
303936 MariaDB tpm
303192 MariaDB tpm
308934 MariaDB tpm
Vuser 1:5 ...,
Vuser 1:Test complete, Taking end Transaction Count.
Vuser 1:24 Active Virtual Users configured
Vuser 1:TEST RESULT : System achieved 128176 NOPM from 298394 MariaDB TPM
Vuser 1:Gathering timing data from Active Virtual Users...
Vuser 9:FINISHED SUCCESS
Vuser 25:FINISHED SUCCESS
Vuser 24:FINISHED SUCCESS
Vuser 15:FINISHED SUCCESS
Vuser 8:FINISHED SUCCESS
Vuser 13:FINISHED SUCCESS
305400 MariaDB tpm
Vuser 12:FINISHED SUCCESS
Vuser 17:FINISHED SUCCESS
Vuser 6:FINISHED SUCCESS
Vuser 4:FINISHED SUCCESS
Vuser 5:FINISHED SUCCESS
Vuser 3:FINISHED SUCCESS
Vuser 20:FINISHED SUCCESS
Vuser 18:FINISHED SUCCESS
Vuser 16:FINISHED SUCCESS
Vuser 7:FINISHED SUCCESS
Vuser 10:FINISHED SUCCESS
Vuser 11:FINISHED SUCCESS
Vuser 2:FINISHED SUCCESS
Vuser 19:FINISHED SUCCESS
Vuser 22:FINISHED SUCCESS
Vuser 21:FINISHED SUCCESS
Vuser 14:FINISHED SUCCESS
Vuser 23:FINISHED SUCCESS
Vuser 1:Calculating timings...
Vuser 1:Writing timing data to /opt/HammerDB-5.0/TMP/hdbxtprofile.log
Vuser 1:FINISHED SUCCESS
ALL VIRTUAL USERS COMPLETE
vudestroy success
Transaction Counter thread running with threadid:tid0x7ba2fcc00640
Stopping Transaction Counter
TEST COMPLETE
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
DROP HAMMERDB SCHEMA
HammerDB CLI v5.0
Copyright © HammerDB Ltd hosted by tpc.org 2019-2025
Type "help" for a list of commands
Initialized Jobs on-disk database /opt/HammerDB-5.0/TMP/hammer.DB using existing tables (1,449,984 bytes)
SETTING CONFIGURATION
Database set to MariaDB
Benchmark set to TPC-C for MariaDB
Value localhost for connection:maria_host is the same as existing value localhost, no change made
Value 3306 for connection:maria_port is the same as existing value 3306, no change made
Value /tmp/mariadb.sock for connection:maria_socket is the same as existing value /tmp/mariadb.sock, no change made
Value root for tpcc:maria_user is the same as existing value root, no change made
Value maria for tpcc:maria_pass is the same as existing value maria, no change made
Value tpcc for tpcc:maria_dbase is the same as existing value tpcc, no change made
 DROP SCHEMA STARTED
Script cleared
Deleting schema with 1 Virtual User
Do you want to delete the TPCC TPROC-C schema
 in host LOCALHOST:/TMP/MARIADB.SOCK under user ROOT?
Enter yes or no: replied yes
Vuser 1 created - WAIT IDLE
Vuser 1:RUNNING
Vuser 1:Ssl_cipher 
Vuser 1:tpcc TPROC-C Schema has been deleted successfully.
Vuser 1:FINISHED SUCCESS
ALL VIRTUAL USERS COMPLETE
DROP SCHEMA COMPLETED
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
HAMMERDB RESULT
HammerDB CLI v5.0
Copyright © HammerDB Ltd hosted by tpc.org 2019-2025
Type "help" for a list of commands
Initialized Jobs on-disk database /opt/HammerDB-5.0/TMP/hammer.DB using existing tables (1,449,984 bytes)
TRANSACTION RESPONSE TIMES
{
  "NEWORD": {
    "elapsed_ms": "414691.5",
    "calls": "1805808",
    "min_ms": "0.586",
    "avg_ms": "5.765",
    "max_ms": "108.869",
    "total_ms": "10412109.138",
    "p99_ms": "13.309",
    "p95_ms": "9.818",
    "p50_ms": "5.354",
    "sd": "2437.527",
    "ratio_pct": "52.308"
  },
  "PAYMENT": {
    "elapsed_ms": "414691.5",
    "calls": "1812876",
    "min_ms": "0.419",
    "avg_ms": "3.696",
    "max_ms": "101.212",
    "total_ms": "6701684.17",
    "p99_ms": "8.856",
    "p95_ms": "6.463",
    "p50_ms": "3.422",
    "sd": "1702.923",
    "ratio_pct": "33.668"
  },
  "DELIVERY": {
    "elapsed_ms": "414691.5",
    "calls": "180264",
    "min_ms": "1.651",
    "avg_ms": "10.186",
    "max_ms": "108.887",
    "total_ms": "1836174.18",
    "p99_ms": "20.46",
    "p95_ms": "15.917",
    "p50_ms": "9.601",
    "sd": "3354.046",
    "ratio_pct": "9.225"
  },
  "OSTAT": {
    "elapsed_ms": "414691.5",
    "calls": "182140",
    "min_ms": "0.258",
    "avg_ms": "2.176",
    "max_ms": "97.373",
    "total_ms": "396506.022",
    "p99_ms": "6.151",
    "p95_ms": "4.458",
    "p50_ms": "1.927",
    "sd": "1304.251",
    "ratio_pct": "1.992"
  },
  "SLEV": {
    "elapsed_ms": "414691.5",
    "calls": "180616",
    "min_ms": "0.446",
    "avg_ms": "2.175",
    "max_ms": "72.883",
    "total_ms": "392867.218",
    "p99_ms": "5.919",
    "p95_ms": "4.215",
    "p50_ms": "1.914",
    "sd": "1205.891",
    "ratio_pct": "1.974"
  }
}

TRANSACTION COUNT
{"MariaDB tpm": {
    "2025-04-14 17:09:41": "0",
    "2025-04-14 17:09:51": "185196",
    "2025-04-14 17:10:01": "309240",
    "2025-04-14 17:10:11": "303012",
    "2025-04-14 17:10:21": "308850",
    "2025-04-14 17:10:31": "300828",
    "2025-04-14 17:10:41": "294708",
    "2025-04-14 17:10:51": "291780",
    "2025-04-14 17:11:01": "309612",
    "2025-04-14 17:11:11": "292572",
    "2025-04-14 17:11:21": "308898",
    "2025-04-14 17:11:31": "294198",
    "2025-04-14 17:11:41": "295320",
    "2025-04-14 17:11:51": "296226",
    "2025-04-14 17:12:01": "292506",
    "2025-04-14 17:12:12": "296832",
    "2025-04-14 17:12:22": "298662",
    "2025-04-14 17:12:32": "296694",
    "2025-04-14 17:12:42": "304416",
    "2025-04-14 17:12:52": "295938",
    "2025-04-14 17:13:02": "295140",
    "2025-04-14 17:13:12": "300540",
    "2025-04-14 17:13:22": "297570",
    "2025-04-14 17:13:32": "296370",
    "2025-04-14 17:13:42": "298410",
    "2025-04-14 17:13:52": "299760",
    "2025-04-14 17:14:02": "297546",
    "2025-04-14 17:14:12": "296340",
    "2025-04-14 17:14:22": "297756",
    "2025-04-14 17:14:32": "291090",
    "2025-04-14 17:14:42": "294612",
    "2025-04-14 17:14:52": "309450",
    "2025-04-14 17:15:02": "295866",
    "2025-04-14 17:15:12": "291948",
    "2025-04-14 17:15:22": "297936",
    "2025-04-14 17:15:32": "294774",
    "2025-04-14 17:15:42": "295446",
    "2025-04-14 17:15:52": "301026",
    "2025-04-14 17:16:02": "304896",
    "2025-04-14 17:16:12": "303936",
    "2025-04-14 17:16:22": "303192",
    "2025-04-14 17:16:32": "308934",
    "2025-04-14 17:16:42": "305400"
  }}

HAMMERDB RESULT
[
  "67FD3345479A03E263133333",
  "2025-04-14 17:09:41",
  "24 Active Virtual Users configured",
  "TEST RESULT : System achieved 128176 NOPM from 298394 MariaDB TPM"
]

Note that the performance results are gathered and reported at the end of the workload using the HammerDB Jobs interface and this Jobs interface is detailed in the following section.