HammerDB

JULY 5, 2022

Python is a popular programming language, especially for beginners, and consequently we see it occurring in places where it just shouldn’t be used, such as database benchmarking. We use stored procedures because, as the introductory post shows, using single SQL statements turns our database benchmark into a network test).

Benchmarking 98

Benchmarking Database C++ Virtualization 98

HammerDB

MARCH 25, 2023

Copyright (C) 2003-2023 Steve Shaw Type "help" for a list of commands Initialized SQLite on-disk database /home/steve/HammerDB-4.7/TMP/hammer.DB using existing tables (188,416 KB) SETTING CONFIGURATION Database set to MariaDB Benchmark set to TPC-C for MariaDB. /scripts/tcl/maria/tprocc/maria_tprocc.sh TMP/hammer.DB TMP/hammer.DB

C++ 83

C++ Virtualization Benchmarking Database 83

HammerDB

DECEMBER 14, 2022

Copyright (C) 2003-2022 Steve Shaw Type "help" for a list of commands Initialized new SQLite on-disk database /tmp/hammer.DB Copyright (C) 2003-2022 Steve Shaw. Benchmark set to TPC-C for MariaDB. Building 20 Warehouses with 5 Virtual Users, 4 active + 1 Monitor VU(dict value maria_num_vu is set to 4). hammerdbcli.

C++ 62

C++ Virtualization Database Benchmarking 62

HammerDB

NOVEMBER 30, 2022

Copyright (C) 2003-2022 Steve Shaw. Copyright (C) 2003-2022 Steve Shaw. Why Tcl is 700% faster than Python for database benchmarking. Therefore, although on both Linux and Windows, you will see Python as the top process in performance monitoring tools when running the workload. /hammerdbcli py HammerDB CLI v4.6.

Virtualization 44

Virtualization C++ Lambda Monitoring 44

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 Use a different Browser.

Virtualization 57

Virtualization C++ Storage Database 57

HammerDB

MAY 10, 2021

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. This is because Virtual User 1 is the monitor Virtual User but this Virtual User does not run in the replica meaning it ends immediately. Step Workloads.

Virtualization 52

Virtualization C++ Database Monitoring 52

HammerDB

NOVEMBER 23, 2021

this web interface has been enhanced to add command line functionality to the service as well as extending the ability to query the database of configuration, results and timing data to be returned in JSON format, enabling a long-term repository of HammerDB benchmark data for integrating HammerDB into service based cloud environments.

Virtualization 70

Virtualization Benchmarking C++ Database 70