[osdldbt-general] Re: Setting up dbt2-1tier

[Mary E. M. <mar...@os...>]

On Wed, 2003-09-24 at 09:23, Lars Marowsky-Bree wrote:
> Good morning Mary,
>=20
> cliffw referred me to you with my question. I'm trying to get some
> numbers to find out how much storage replication affects database
> processing (ie, transactions/second).=20
>=20
> The dbt2 benchmark sounds like a good start for this. However, I'm
> unsure what I need to set it up quickly. I found the stp version of it,
> but the README doesn't say what I should install and how before running
> it. I'm also not too concerned with high performance tuning for this
> testrun, as I mainly want to compare numbers.
>=20
> If you could point me to or provide me with a brief step by step guide,
> it would be greatly appreciated. Maybe you have something around?
>=20
>=20
> Sincerely,
>     Lars Marowsky-Br=E9e <lm...@su...>


I don't think the stp version is quite what you want unless you want to
embed dbt2 in an STP framework that you have installed somewhere.  You
are right that we did not do a "how to" for that. The stp version can
serve as an example of running dbt2.

However, if you want to install dbt2 on a machine to give it a try,
please go to sourceforge and down load the kit.  You will have something
then with some docs and examples (at least for the sapdb
version).http://sourceforge.net/projects/osdldbt

The kit is set up so that you can use either sapdb or postgreSQL,
however for dbt2 the postreSQL version is still under development. We
are getting close, so giving it a try is not out of the question.


As for ease of use, I highly recommend you also consider the dbt3, which
is the decision support workload that closely resembles the TPC-H.  It
is quite easy to set up, you can run different phases of the test (the
database load, the single stream test, or the throughput test) at will.=20
You can even substitute other queries than the ones provided.  There is
also a little bit of update mixed in the workload.  For sapdb, the dbt3
user guide is a little better than the one for dbt2, in fact you might
want to refer to it for the part about installing sapdb. =20

Both sapdb and postreSQL versions of dbt3 are working well, although we
may need to update the user guide to account for some new driver options
of late...  There is a version running on stp (dbt3-pgsql) if you want
to see the output and workload characteristics..  Here is an example run
on an 8way system:
http://khack.osdl.org/stp/280348/

I suggest you get on the osdldbt-general alias and fire off questions
you are bound to have as you work thorough the install.
http://lists.sourceforge.net/lists/listinfo/osdldbt-general
=20
If you are unfamiliar with whichever database you choose or want help
choosing, let us know.  They (particularly PostgreSQL) have philosophies
that are quite different from many commercial databases.  The way they
approach disk lay-out and memory allocation to get optimal performance
may not be what you are expecting.

Thanks for your interest!


--=20
Mary Edie Meredith <mar...@os...>
Open Source Development Lab