Table of Contents

OSDL DBT-1 home page

OSDL-DBT-1 home page.

OSDL-DBT-1 simulates a web server to give results similar to the proprietary TPC-W benchmark.

Assumptions

Configuration

SAPDB

Postgresql

Required packages

Compiling you own Postgrsql

Setting Up the Database

Environment Variables

Getting the source

Compiling

Setup the benchmark database

  1. cd into the datagen directory and run datagen

    ./datagen  -d PGSQL -i 10000 -u 10 -p $DBPATH
    This will produce a small sample. You may want to increase the number of items and users in the system.
    • -i, has to be 1000, 10000 or 100000.

    • -u, can be any positive integer.

    • NOTE with values of -i 100000 and -u 10000, data generation will take considerable time and consume a lot of disk space, for example the following was produced on an 2 * i2 1500 MHz rx2600.

      pgsql@vanilla:~/dbt1-BK/scripts/pgsql$ ls -lh /tmp/DBT1-files/
      total 31G
      -rw-r--r--    1 pgsql    root         5.8G Aug 26 15:12 address.data
      -rw-r--r--    1 pgsql    root         8.9M Aug 26 14:59 author.data
      -rw-r--r--    1 pgsql    root         2.8G Aug 26 15:43 cc_xacts.data
      -rw-r--r--    1 pgsql    root          14G Aug 26 14:59 customer.data
      -rw-r--r--    1 pgsql    root          51M Aug 26 14:27 item.data
      -rw-r--r--    1 pgsql    root         6.3G Aug 26 15:43 order_line.data
      -rw-r--r--    1 pgsql    root         2.7G Aug 26 15:43 orders.data
      pgsql@vanilla:~/dbt1-BK/scripts/pgsql$
      
        real    75m34.662s
        user    72m56.411s
        sys     2m29.652s
  2. cd into the scripts/pgsql and run the build_db.sh

    ./build_db.sh "-c tcpip_socket=[on|off]" 0 0
  3. The -c flag above will depend on how the postmater server is started, see /var/log/pgsql/postgresql.conf for more details.

    The first argument is rather pointless unless you would like to pass options to the postmaster server --- see man postmaster.

    • pgsql@vanilla:~/dbt1-BK/scripts/pgsql$ ls -lh ../../../postgresDB/
      total 36M
      -rw-r--r--    1 pgsql    root         5.8M Aug 24 12:26 address.data
      -rw-r--r--    1 pgsql    root         894K Aug 24 12:26 author.data
      -rw-r--r--    1 pgsql    root         2.7M Aug 24 12:26 cc_xacts.data
      -rw-r--r--    1 pgsql    root          13M Aug 24 12:26 customer.data
      -rw-r--r--    1 pgsql    root         5.0M Aug 24 12:26 item.data
      -rw-r--r--    1 pgsql    root         6.1M Aug 24 12:26 order_line.data
      -rw-r--r--    1 pgsql    root         2.5M Aug 24 12:26 orders.data
      pgsql@vanilla:~/dbt1-BK/scripts/pgsql$
      
        real    1m39.830s
        user    0m0.236s
        sys     0m0.229s

Running the benchmark

Run Times

Getting Results

Benefits

Problems

Results

IA64wiki: OSDL-DBT-1 (last edited 2012-02-15 02:18:51 by PeterChubb)

Gelato@UNSW is sponsored by
the University of New South Wales National ICT Australia The Gelato Federation Hewlett-Packard Company Australian Research Council
Please contact us with any questions or comments.