A New Release of Swingbench

A New Release of Swingbench…

Along with a new website, I’m rolling out a new build of Swingbench. This release is a little embarrassing for me, as it includes a lot of code I shelved nearly 18 months ago and only recently “rediscovered”. It took some time to merge those changes and add the features shown below. The big changes to the code include

  • New TPC-H Like Benchmark with new wizard and workload config files
  • Command-line output is now in colour. This can be disabled with -nc
  • Properties can now be set at the command line with the -P option
  • Look and feel uses a new more modern skin
  • New option to output content in JSON format
  • Additional error messages are handled more gracefully exiting earlier in the data generation or load process
  • Added a config file for Application Continuity setup
  • Countless small fixes

You can download it here or from github

Checksum below.

$ cksum swingbenchlatest.zip 
1679811525 41211958 swingbenchlatest.zip

So a little more detail on two of the bigger features in this release; TPC-H (Like) support and colour on the command line.

TPC-H Like Benchmark

I’ve been promising support for TPC-H for a while. While the benchmark is somewhat antiquated and doesn’t pose much of a challenge to most modern databases, it’s still a helpful database test. It’s purely analytical and comprises of 19/20 queries of varying complexity. My implementation is close but not identical to the official version, and over time I’ll look to bring it closer into line. As it’s implemented today, each run could be slightly different but over the coming weeks I’ll release some numbers describing its characteristics.

Installing it is the same as all of the other Swinbench benchmarks.

For a graphical install simply change into the swingbench/bin directory and use the command

./tpchwizard

or on Windows simply change into the winbin directory and use this command

tpcwizard

if you’d prefer to do it from the command line use a command such as

./tpchwizard -cl -v -create -cs //localhost/tpch -u tpch -p tpch -cl -scale 10 -v

Once the benchmark has run you can then run swingbench/charbench/minibench against it with the command

./swingbench -c ../configs/TPCH_Like_Workload.xml

or if you prefer the command line

./charbench -c ../configs/TPCH_Like_Workload.xml -u tpch -p tpch -uc 2 -v users,trem,,tpm,tps,resp -rt 0:0.10 -mr -cs //localhost/soe

Colour on the Command Line

We all could do with a little more colour in our life and that’s what this release delivers. By default swingbench (command line specifically) uses colour to highlight errors and make things just a little simpler to parse. You can disable it with the -nc command line option. The gif below shows the install and the running of the TPC-H benchmark from the command line in all it’s coloured glory.

full

If you have any issues please post them to the issues section on the public swingbench git hub repository

2023

New functionality for swingbench…

4 minute read

A small but significant set of changes Last weekend I updated swingbench to add a few features that I’ve had frequent requests for. One is the addition of da...

Swingbench 2.7 June 2023 Update

less than 1 minute read

A new build of Swingbench with a whole bunch of small changes mainly related to the benchmarks. Faster build time for the JSON benchmark when creating lar...

Size Makes A Difference

6 minute read

In my previous post “Going Big” I discussed the difference testing a data set of a representative size can make to the usefulness of a benchmark. Running a w...

Going Big

10 minute read

Swingbench makes it simple to generate a dataset that you can simulate transactions against. However one of the problems I commonly see is that the users of ...

Back to Top ↑

2022

Swingbench 2.7

1 minute read

Swingbench 2.7 So I finally found some time to get a new build of swingbench done. The big change is that swingbench now only supports JDK-17 and above. Now,...

A new build of DB Time Monitor

less than 1 minute read

Following quickly on the heels of the update to MonitorDB I’m releasing a new build of DBTimeMonitor. This is a simple update using the latest Oracle jdbc dr...

A new build of MonitorDB

less than 1 minute read

I’ve just updated MonitorDB. It’s never going to replace Grafana but if you need a quick solution to monitor a few values inside of the Oracle Database and y...

Making Colour work on the Command Line for Windows

less than 1 minute read

I’ll make a confession. I don’t own a Microsoft Windows Machine. I never have and probably never will. This means that I generally never get the oppertunity ...

A New Release of Swingbench

2 minute read

A New Release of Swingbench… Along with a new website, I’m rolling out a new build of Swingbench. This release is a little embarrassing for me, as it include...

A New Look

2 minute read

A New Start… Quite a lot has changed since I last posted on this website. I had just left Oracle to join Google… A year and a half later I returned to Oracle...

Back to Top ↑