(DEHEMS) Benchmark environment

Hardware configuration

• System configuration:
  • Intel Core2 6300 @ 1.86 GHz, 2 MB L2 cache
  • 1 GB RAM DDR2-800 MHz
  • 160 GB HDD SATA-2 WD1600JS

  • GeForce 6600 LE

• Operating systems used:
  • Windows XP SP2 (20 GB partition)
  • Windows Vista 32-bit Ultimate (30 GB partition)
  • Ubuntu 8.10 32-bit (30 GB partition)

Remote access to the test system

• NX Client:
  • Hostname: 194.102.63.56 sau 194.102.63.58
  • Username: root / ciprian
  • Password: ciprian

MySQL 5 on Ubuntu 8.10

• Install required packages:
  • [Optional] Apache2 (required for PHPMyAdmin):
    • Install it:

      • sudo aptitude install mysql-server mysql-client libmysqlclient15-dev

    • Start the server:

      • sudo /etc/init.d/apache2 start

    • Browse to http://localhost to test result

  • MySQL 5:

    • sudo apt-get install mysqlclient15-dev

    • Setup user root with password ciprian

      • mysql -uroot -pciprian

  • [Optional] PHPMyAdmin:
    • Can be used to execute the startup queries for creating the database, table and index
    • Execute:

      • sudo apt-get install libapache2-mod-auth-mysql php5-mysql phpmyadmin

      • Select to configure for Apache2 server
    • Restart Apache2:

      • sudo /etc/init.d/apache2 restart

• Compile sources
  • Assign execute right to make script:

    • chmod +x Make.sh

  • Run make script and start the benchmark:

    • ./Make.sh

  • Read outputs from the output-all.trace file that gets created when benchmarking is complete.

MySQL 5 on Windows Vista 32-bit Ultimate

• Default installation of server

  • Table created using MyISAM engine (no transactions) (see Linux.com article)

  • Configured user root with password ciprian

• Run setup.sql script in MySQL console or PHPMyAdmin

• Run InsBench.exe and ScanBench.exe

  • Run build-trace.bat to build final output-all.trace file

• Read output from the output-all.trace file.

Microsoft SQL Server 2008 on Windows Vista

• To do

Informix 11.50 Dynamic Server Enterprise on Ubuntu 8.10

• Download Informix IDS Dynamic Server Enterprise Edition - TimeLimited 11.5 for Linux (x86) RHEL 4, 32bit (iif.11.50.UC3TL.Linux-RHEL4.tar)

• Update your Java version if necessary
  • Download version 6:

    • sudo apt-get install sun-java6-jre sun-java6-jdk sun-java6-plugin

  • Find all versions installed:

    • update-java-alternatives -l

  • Select the latest version installed:

    • sudo update-java-alternatives -s <JRE_version_goes_here>

• Install Informix:

  • sudo ./ids_install

  • When prompted for password for user informix, enter password dehems2008

  • Choose installation folder as /opt/IBM/informix

  • Select to install Client-SDK Version 3.50, Dynamic Server Version 11.50 and JDBC Driver Version 3.50. IConnect 3.50 is not necessary. Choose Typical installation for all products.

  • When asked to enable role separation, answer Yes.

    • Group for security-related tasks: informix

    • Group for audit-administration tasks: informix

    • Group for database users: <leave blank>

  • When asked if you want IDS to create a demo server instance, answer Yes.

    • In the next window, choose Customize the default configuration file to suit your needs and hardware.

    • Configure demo server instance:

      • Server name: demo_on

      • Server number: 0

      • Root path: /opt/IBM/informix/demo/server/online_root

      • Rootsize (MB): 4000 (change from the default value of 760 MB; this value causes the dbspace to fill at around 4,500,000 entries; the 0 MB value does not work either, the server returns an error when initializing for some reason)

  • Configure server settings:

    • Processors to use: 1

    • Memory to use (MB): 512 (tried with a value of 1024 and problems appeared when creating shared memory)

    • Online Transaction Clients: 1

    • Decision Support Clients: 1

  • Select a terminal emulator to launch for the demonstration database:

    • Select Xterm (important: sometimes errors appear when selecting this terminal) or specify a custom one: /usr/bin/gnome-terminal

• Configure the installed server to make it run:
  • Login as root:

    • su

  • Setup environment variables (type in shell):

    • INFORMIXSERVER=demo_on

    • INFORMIXDIR="/opt/IBM/informix"

    • ONCONFIG=onconfig

    • INFORMIXSQLHOSTS="/opt/IBM/informix/etc/sqlhosts.demo_on"

    • export INFORMIXSERVER

    • export INFORMIXDIR

    • export ONCONFIG

    • export INFORMIXSQLHOSTS

    • PATH=$INFORMIXDIR/bin:$PATH

    • export PATH

  • Execute script to remove server shared memory traces for the server (not sure why they cause problems on startup):

    • chmod +x remove-shared-memory.sh

    • sh remove-shared-memory.sh

  • Try to initialize the server:

    • $INFORMIXDIR/bin/oninit -i

  • Test that server is up and running (should bring up a list of statistics, or an error if problems occured):

    • $INFORMIXDIR/bin/onstat

  • To shutdown the server, use:

    • $INFORMIXDIR/bin/onmode -kui

• Compiling the ESQL/C benchmarking programs
  • Set the LD_LIBRARY_PATH environment variable:

    • LD_LIBRARY_PATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:$LD_LIBRARY_PATH

    • export LD_LIBRARY_PATH

  • Assign execute rights to Make.sh:

    • chmod +x Make.sh

  • Execute benchmarks

    • ./Make.sh

• Read benchmarking results from the output-all.trace file that gets created when benchmarking is finished.

• Observations

  • When testing the program with the configured settings (except the dbspace size was set to 760 MB, as mentioned earlier), the inserts stopped at a bit over 4,760,000 inserts. We had to increase the size to 4000 MB to make it work right.