database workload simulation hammerdb - ghdrako/doc_snipets GitHub Wiki

• HammerDB
• https://github.com/TPC-Council/HammerDB
• https://www.tpc.org/

supporting Microsoft SQL Server, IBM Db2, Oracle, PostgreSQL, MariaDB and MySQL on-premis and cloud

HammerDB has graphical and command line interfaces for the Windows and Linux operating systems.

HammerDB supports 2 workloads derived from TPC specifications to test these different requirements, namely TPROC-C derived from TPC-C for OLTP and TPROC-H derived from TPC-H for OLAP.

By default HammerDB implements a cached vs a scaled workload but can implement both types of benchmark

Docker

• https://www.hammerdb.com/blog/uncategorized/how-to-deploy-hammerdb-cli-fast-with-docker/

hammerdb@REDPOLL:~$docker pull tpcorg/hammerdb
hammerdb@REDPOLL:~$ sudo docker run --network=host -it --name hammerdb tpcorg/hammerdb bash
## inside container
root@REDPOLL:/home/hammerdb/HammerDB-4.6#
root@REDPOLL:/home/hammerdb/HammerDB-4.6# ./hammerdbcli 

Usage

• https://www.hammerdb.com/blog/uncategorized/hammerdb-cli-101/

Postgres

• https://www.hammerdb.com/blog/uncategorized/how-to-analyze-postgresql-benchmark-performance-with-hammerdb/ HammerDB PostgreSQL metrics is based on a superb tool called pgSentinel that brings active session history functionality to PostgreSQL. An active session history allows us to look back at a database workload and see the workload being run over time.