Remove 2003 Remove Benchmarking Remove Database Remove Testing
article thumbnail

HammerDB v4.8 New Features : Viewing your Benchmark results with the HammerDB Web Service

HammerDB

Configuring the Jobs Database The base configuration is set in the xml files in the config directory with the jobs SQLite database being set in the commandline section of generic.xml by specifying the filename. Copyright (C) 2003-2023 Steve Shaw Type "help" for a list of commands Initialized new Jobs on-disk database /opt/HammerDB-4.8/DATA/hammer.db

article thumbnail

HammerDB v4.7 New Features Pt 2: Example CLI Scripts

HammerDB

When you list the HammerDB directory you can now see a directory called “scripts” This directory contains CLI scripts to build, run, delete and query TPROC-C and TPROC-H workloads against all databases. If HammerDB is running on a separate system from the database under test then you should modify this value accordingly.

C++ 83
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

HammerDB v4.7 New Features Pt 3: Lightweight Docker Images for rapid testing

HammerDB

introduced a Dockerfile and Docker Images to pull from Docker Hub for rapid deployment of HammerDB with builds already including third-party database libraries. When the script has finished we can gather our results, having installed, started and run a benchmark in our HammerDB Docker image in 3 steps. HammerDB v4.5 TMP/hammer.DB

article thumbnail

HammerDB v4.6 New Features Pt2: Jobs Interface

HammerDB

In particular, after a running a test it would be ideal to have a repository where we could verify the configuration of the workload that was run, the results and any timing or transaction count data generated to bring all the log output into a central location. . <commandline> This happens for both a schema build and running a test.

article thumbnail

HammerDB v4.6 New Features Pt1: Python CLI Interface

HammerDB

Copyright (C) 2003-2022 Steve Shaw. Copyright (C) 2003-2022 Steve Shaw. print(z," VU TEST") . print("TEST SEQUENCE COMPLETE"). Vuser 1:Timing test period of 1 in minutes Vuser 2:RUNNING Vuser 2:Initializing xtprof time profiler Vuser 2:Processing 10000000 transactions with output suppressed. >hammerdbcli py.

article thumbnail

HammerDB v4.3 New Features Pt2: Enhanced Webservice with SQLite repository

HammerDB

cloud based usage led to the development of a HammerDB HTTP based web service interface with output data stored in a SQLite database repository. ws_port defines on which port to start the HTTP service, whilst sqlite_db sets the location of the SQLite repository database. Running a Test. HammerDB Web Service v4.3

article thumbnail

HammerDB v4.1 New Features Pt3: Step Workloads

HammerDB

HammerDB Variable or Step Workloads are an advanced testing feature that enables you to automatically vary the load on the database over a period of time. When taking this approach you would not focus on the test result but instead monitor the databases ability to cope with the variation in demand and transaction response times.