2003, Benchmarking and Virtualization - Technology Performance Pulse

Why Tcl is 700% faster than Python for database benchmarking

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

Benchmarking Database C++ Virtualization

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

HammerDB

JUNE 22, 2023

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 Copyright (C) 2003-2023 Steve Shaw Type "help" for a list of commands Initialized new Jobs on-disk database /opt/HammerDB-4.8/TMP/hammer.DB So for example to change this to hammer.db DATA/hammer.db

Benchmarking

Benchmarking C++ Virtualization Database

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

HammerDB

MARCH 25, 2023

It will create the number of virtual users to the number of CPUs on the system where HammerDB is running. 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 scripts/tcl/maria/tprocc/maria_tprocc.sh TMP/hammer.DB TMP/hammer.DB TMP/hammer.DB

C++

C++ Virtualization Benchmarking Database

How to deploy HammerDB CLI fast with Docker

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 and the test will run with the number of Virtual Users equivalent to the number of CPUs. Copyright (C) 2003-2022 Steve Shaw. Benchmark set to TPC-C for MariaDB. ALL VIRTUAL USERS COMPLETE.

C++

C++ Virtualization Database Benchmarking

HammerDB v4.6 New Features Pt2: Jobs Interface

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

Virtualization C++ Storage Database

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

HammerDB

MARCH 27, 2023

introduces more lightweight database specific Docker Images, so if you only want to run benchmarks against a specific database you can go from having no benchmarking environment to reviewing your results in as little as 3 commands. How to deploy HammerDB CLI fast with Docker HammerDB v4.7 Copy Code Copied Use a different Browser.

Benchmarking

Benchmarking Testing Database C++

HammerDB v4.6 New Features Pt1: Python CLI Interface

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. /hammerdbcli py HammerDB CLI v4.6. Type "help()" for a list of commands.

Virtualization

Virtualization C++ Lambda Monitoring

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

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

Virtualization Benchmarking C++ Database

HammerDB v4.1 New Features Pt3: Step Workloads

HammerDB

MAY 10, 2021

The replicas are defined in steps.xml in the config directory to determine how many virtual users each replica will configure, how soon after the previous instance has started the replica should start and how long it will run for. <steps> Note that it is expected for Virtual User 1 of the replicas to end immediately with the message.

Virtualization

Virtualization C++ Database Monitoring

Using HammerDB as a Web Service

HammerDB

JULY 8, 2019

Copyright (C) 2003-2019 Steve Shaw Type "help" for a list of commands The xml is well-formed, applying configuration Initialized new SQLite in-memory database Starting HammerDB Web Service on port 8080 Listening for HTTP requests on TCP port 8080. see the documentation for setting the port). . $./hammerdbws hammerdbws HammerDB Web Service v3.2

Benchmarking

Benchmarking Virtualization C++ Database

What Adrian Did Next?—?Part 2?—?Sun Microsystems

Adrian Cockcroft

JUNE 21, 2022

Another big jump, but now it was my job to run benchmarks in the lab, and write white papers that explained the new products to the world, as they were launched. I was mostly coding in C, tuning FORTRAN, and when I needed to do a lot of data analysis of benchmark results used the S-PLUS statistics language, that is the predecessor to R.

Tuning

Tuning Benchmarking Engineering C++

HammerDB Concepts and Architecture

HammerDB

NOVEMBER 30, 2018

This article Threads Done Right… With Tcl gives an excellent overview of these capabilities and it should be clear that to build a scalable benchmarking tool this thread performance and scalability is key. As virtual users are started the database specific packages and workload specific modules are loaded into the virtual user threads.

Architecture

Architecture Virtualization Open Source C++

HammerDB MySQL and MariaDB Best Practice for Performance and Scalability

HammerDB

OCTOBER 12, 2018

For anyone benchmarking MySQL with HammerDB it is important to understand the differences from sysbench workloads as HammerDB is targeted at a testing a different usage model from sysbench. Copyright (C) 2003-2018 Steve Shaw. Error in Virtual User 1: mysqlexec/db server: Table 'mysql.proc' doesn't exist. H ammerDB CLI v3.1.

Best Practices

Best Practices Scalability Performance C++

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

JANUARY 11, 2020

Latch enforcement changes the virtual memory protection ( VirtualProtect ) as the database pages are transitioned between the clean and dirty states. When the modification latch is acquired.

Servers

Servers Cache Database Media

Technology Performance Pulse

Why Tcl is 700% faster than Python for database benchmarking

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

Trending Sources

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

How to deploy HammerDB CLI fast with Docker

HammerDB v4.6 New Features Pt2: Jobs Interface

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

HammerDB v4.6 New Features Pt1: Python CLI Interface

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

HammerDB v4.1 New Features Pt3: Step Workloads

Using HammerDB as a Web Service

What Adrian Did Next?—?Part 2?—?Sun Microsystems

HammerDB Concepts and Architecture

HammerDB MySQL and MariaDB Best Practice for Performance and Scalability

SQL Server I/O Basics Chapter #2

Stay Connected