Your ads will be inserted here by

Easy Plugin for AdSense.

Please go to the plugin admin page to
Paste your ad code OR
Suppress this ad slot.

cd /usr/local/src

wget http://sourceforge.net/projects/sysbench/files/latest/download
tar -xvzf sysbench-0.4.xx.tar.gz
cd sysbench-0.4.12
libtoolize --force --copy
./autogen.sh
./configure
make

Problem:

/usr/bin/ld: cannot find -lmysqlclient_r
collect2: ld returned 1 exit status
make[2]: *** [sysbench] Error 1
make[2]: Leaving directory `/usr/local/src/sysbench-0.4.12/sysbench’
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/local/src/sysbench-0.4.12/sysbench’
make: *** [all-recursive] Error 1

Solution:

Pass linker: LDFLAGS linker flags, e.g. -L

export LDFLAGS='-L/usr/lib/mysql'
./configure
make
make install

Testing Parameter

Your ads will be inserted here by

Easy Plugin for AdSense.

Please go to the plugin admin page to
Paste your ad code OR
Suppress this ad slot.

CPU Benchmark

sysbench --test=cpu --cpu-max-prime=20000 run

Fileio

sysbench --num-threads=16 --test=fileio --file-total-size=3G --file-test-mode=rndrw prepare

DB Benchmark

sysbench --test=oltp --oltp-table-size=1000000 --mysql-db=databasename --mysql-user=root --mysql-password=PASSWORD prepare
sysbench --test=oltp --oltp-table-size=1000000 --mysql-db=databasename --mysql-user=root --mysql-password=PASSWORD --max-time=60 --oltp-read-only=on --max-requests=0 --num-threads=8 run

# Ideally take more than ram size

sysbench --test=fileio --file-total-size=30G prepare

sysbench --test=fileio --file-total-size=30G --file-test-mode=rndrw --init-rng=on --max-time=300 --max-requests=0 run

Ref Doc: http://sysbench.sourceforge.net/docs/