Running Sysbench 0.4.12 on Ubuntu 9.04

I decided to try benchmarking MySQL 5 with Sysbench 0.4.12 but as it turned out it was not so easy task.First I followed the steps as described by the dbadojo blog:

  1. Download last version of Sysbench
  2. tar -xzvf sysbench-0.4.XX.tar.gz
  3. cd sysbench-0.4.XX
  4. ./configure && make && make install

But the compiling wasn’t done and I get a strange error:

../libtool: line 2412: Xsysbench: command not found

Thanks to the tip from  randombugs.com I managed to compile it properly.Here what you have to do in short.

Edit configure.ca:

#AC_PROG_LIBTOOL
AC_PROG_RANLIB

and re-run

./autogen.sh

and your are ready to

./configure && make && make install

After successfully compiling Sysbench you have to create a database called sbtest in MySQL:

mysql -u root -p yourpassword
create database sbtest;
grant all on *.* to ‘root’@'%’;

Then you can prepare your Sysbench test and start benchmarking:

  1. sysbench –test=oltp –mysql-table-engine=innodb –oltp-table-size=1000000 –mysql-user=root –mysql-password=yourpassword prepare
  2. sysbench –num-threads=4 –max-time=900 –max-requests=500000 –test=oltp –oltp-table-size=80000000 –mysql-user=root –mysql-password=yourpassword –mysql-table-engine=innodb –oltp-test-mode=complex run  >  test_thrd_4.txt
  3. sysbench –num-threads=4 –max-time=900 –max-requests=500000 –test=oltp –oltp-table-size=80000000 –mysql-user=root –mysql-password=yourpassword –mysql-table-engine=innodb –oltp-test-mode=complex cleanup

Here how the output from test_thrd_4.txt look like:

sysbench 0.4.12:  multi-threaded system evaluation benchmark

No DB drivers specified, using mysql
Running the test with following options:
Number of threads: 4

Doing OLTP test.
Running mixed OLTP test
Using Special distribution (12 iterations,  1 pct of values are returned in 75 pct cases)
Using “BEGIN” for starting transactions
Using auto_inc on the id column
Maximum number of requests for OLTP test is limited to 500000
Threads started!
Time limit exceeded, exiting…
(last message repeated 3 times)
Done.

OLTP test statistics:
queries performed:
read:                            2541588
write:                           907710
other:                           363070
total:                           3812368
transactions:                        181528 (201.68 per sec.)
deadlocks:                           14     (0.02 per sec.)
read/write requests:                 3449298 (3832.30 per sec.)
other operations:                    363070 (403.38 per sec.)

Test execution summary:
total time:                          900.0583s
total number of events:              181528
total time taken by event execution: 3597.9221
per-request statistics:
min:                                  0.00ms
avg:                                 19.82ms
max:                                484.69ms
approx.  95 percentile:             118.68ms

Threads fairness:
events (avg/stddev):           45382.0000/149.29
execution time (avg/stddev):   899.4805/0.02

For more information on all possible input parameters and test types you can check the Sysbench manual page . I hope this helps and wish you successful benchmarking !

2 thoughts on “Running Sysbench 0.4.12 on Ubuntu 9.04

  1. Pingback: sysbench - StartTags.com

  2. Jamsheer AkNo Gravatar

    sir while i am installing the sysbench i am geting the arror after make. the error was like this
    ddxSigGiveUp: Closing log
    ../libtool: line 5175: : command not found
    test -z “/usr/local/bin” || /bin/mkdir -p “/usr/local/bin”
    make[3]: Nothing to be done for `install-data-am’.
    make[3]: Leaving directory `/home/jamsheer/Downloads/sysbench-0.4.12/sysbench’
    make[2]: Leaving directory `/home/jamsheer/Downloads/sysbench-0.4.12/sysbench’
    make[1]: Leaving directory `/home/jamsheer/Downloads/sysbench-0.4.12/sysbench’
    make[1]: Entering directory `/home/jamsheer/Downloads/sysbench-0.4.12′
    make[2]: Entering directory `/home/jamsheer/Downloads/sysbench-0.4.12′
    make[2]: Nothing to be done for `install-exec-am’.
    make[2]: Nothing to be done for `install-data-am’.
    make[2]: Leaving directory `/home/jamsheer/Downloads/sysbench-0.4.12′
    make[1]: Leaving directory `/home/jamsheer/Downloads/sysbench-0.4.12′

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>