HammerDB

MARCH 25, 2023

Docker build, example CLI scripts were added to build and run the TPROC-C workload in the Tcl language. these were enhanced to also add Python based scripts, and to include scripts for both TPROC-C and TPROC-H and a driver script for Linux environments. Copy Code Copied Use a different Browser ~/HammerDB-4.7$ In HammerDB v4.6

C++ 83

C++ Virtualization Benchmarking Database 83

HammerDB

JUNE 22, 2023

Copy Code Copied Use a different Browser hammerdb>jobs disable 1 Disabling jobs repository, restart HammerDB to take effect and in the GUI use the Jobs Disabled/Enabled option. in in the DATA directory, set this as follows: Copy Code Copied Use a different Browser <commandline> <sqlite_db>/opt/HammerDB-4.8/DATA/hammer.db</sqlite_db>

Benchmarking 57

Benchmarking C++ Virtualization Database 57

HammerDB

DECEMBER 1, 2022

Copyright (C) 2003-2022 Steve Shaw Type "help" for a list of commands Initialized new SQLite on-disk database C:/Users/Hdb/AppData/Local/Temp/hammer.DB Copyright (C) 2003-2022 Steve Shaw Type "help" for a list of commands Initialized new SQLite on-disk database C:/Users/Hdb/AppData/Local/Temp/hammer.DB

Virtualization 57

Virtualization C++ Storage Database 57

HammerDB

NOVEMBER 30, 2022

Copyright (C) 2003-2022 Steve Shaw. Copyright (C) 2003-2022 Steve Shaw. Vuser 1:1 Active Virtual Users configured Vuser 1:TEST RESULT : System achieved 39945 NOPM from 92893 SQL Server TPM Vuser 1:Gathering timing data from Active Virtual Users. Use a different Browser. $./hammerdbcli >hammerdbcli py.

Virtualization 44

Virtualization C++ Lambda Monitoring 44

HammerDB

MARCH 27, 2023

Copy Code Copied Use a different Browser ~/pgsql$ sudo docker run --network=host -it --name hammerdb-postgres tpcorg/hammerdb:postgres bash As HammerDB has built in example scripts, if our database has default connection parameters, we can go straight ahead and run the PostgreSQL driver script. Copy Code Copied Use a different Browser.

Benchmarking 51

Benchmarking Testing Database C++ 51

HammerDB

JULY 14, 2021

adds full support for MariaDB in both the GUI as shown: And in the CLI as a separate database from MySQL, this post describes a setup and test for MariaDB using the CLI on Linux as an example running the TPROC-C workload. dbset db maria dbset bm TPC-C diset connection maria_socket /tmp/mariadb10234.sock HammerDB v4.2 linux-x86_64.tar.gz

Testing 57

Testing C++ Virtualization Tuning 57

HammerDB

MAY 5, 2019

Fortunately the HammerDB TPC-C/OLTP workload intentionally has a great deal of contention between threads and is therefore ideal for testing spin-locks. Copyright (C) 2003-2018 Steve Shaw. The following was the results in graph form: with a peak performance of the following: Vuser 1:64 Active Virtual Users configured.

Testing 48

Testing Tuning Latency Storage 48