Steps to install Sysbench for Linux ( Centos 5 )

Download your Sysbench source from 

http://sysbench.sourceforge.net/

Extract the tar file.

Before proceed to execute the command below in the Linux shell, run the 

shell> ldconfig -p| grep mysql

to check if libmysqlclient is install, result screen would be as following

--------------------------------------------------------------------------------------------------------

libmysqlclient.so.16 (libc6,x86-64) => /usr/lib64/libmysqlclient.so.16

libmysqlclient.so (libc6,x86-64) => /usr/lib64/libmysqlclient.so

--------------------------------------------------------------------------------------------------------

if it's empty, proceed to install the "libmysqlclient" by download the "MySQL-shared-5.5.9-1.linux2.6.x86_64.rpm" and install it via execute the command below at where your rpm file is.

     rpm -ivh MySQL-shared-5.5.9-1.linux2.6.x86_64.rpm

After all the checking steps above is done, execute the following linux commands steps by steps.

shell > aclocal

shell > libtoolize --force --copy

sysbench_installation_root_folder >  ./autogen.sh    (this file is inside the sysbench source folder)

sysbench_installation_root_folder > ./configure

sysbench_installation_root_folder > make

sysbench_installation_root_folder > make install 

Below is the READ ONLY test

shell > sysbench --num-threads=16 --max-requests=100000 --test=oltp --oltp-table-size=500000 --mysql-socket=/var/lib/mysql/mysql.sock --oltp-read-only --mysql-user=sqlUser --mysql-password=pswd --mysql-db=test run