Saturday, January 17, 2009

New DBT2 version uploaded with more documentation of new scripts

I have had a number of request for help on how to use the DBT2
tree I'm maintaining on www.iclaustron.com. There is an extensive
set of scripts used to make it very easy to run DBT2 runs and
to start and stop cluster nodes and MySQL Servers. I personally
use it also to start MySQL Servers and clusters also when not
using DBT2.

However these scripts haven't had an overall description yet
although each component is very thoroughly documented by
using --help on the scripts (I tend to document very
heavily these things since I otherwise forget it myself).

Now I added a new README file README-ICLAUSTRON which
explains which scripts are used and their relation
and which configuration files to set-up and a
pointer to example configuration files.

Hopefully this will make it easier to use DBT2,
particularly DBT2 for MySQL Cluster.

3 comments:

Gabriela said...

Hi,

I'm trying to set up dbt2 for MySQL 5.1. I'm having trouble when executing the test with run_mysql.sh. One problem I get is that I get some rollbacks for NEW_ORDER stored procedure. Is that normal? Second problem is that my statistics file shows all 0s... I guess that happens because mix.log has zero bytes. Any hints?

Thanks!

Matthew Bilek said...

I have the same problem too.

Mikael Ronstrom said...

The idea with the DBT2 scripts I use is to use run_mysql.sh only as a
script called upon by the script dbt2.sh.

So the intention is to use dbt2.sh to run the benchmarks using the various
configuration files needed to set-up before running the benchmark. I've made changes to the run_mysql.sh such that it runs in two phases.

However all scripts are heavily documented so should be possible to track down the problem by using --help on the various scripts.

It is normal with some rollbacks, I've also seen occasional empty mix.log in some runs.