In the past few months I’ve been experimenting with many MariaDB instances, so after the initial setup I had to measure the DB performances and spot eventual bottlenecks using Sysbench. The natural choice for the operating system was Centos 6.4 x86_64, it was very odd for me to discover that the Sysbench package was not available from the yum repositories, even though few RPMs were available around the net, none of them were compiled with MariaDB support. Without wasting more time, I realized had to build it by myself from the sourcecode.
1) Make sure you have MariaDB already installed.
2) Install the dev tools and the dependencies to compile Sysbench.
yum -y install MariaDB-devel gcc gcc-c++ autoconf automake make libtool \
zlib zlib-devel openssl-devel
3) Grab Sysbench latest version (0.4.12).
3) Decompress the archive.
tar xvfz sysbench-0.4.12.tar.gz
4) LIBTOOL error free.
Comment AC_PROG_LIBTOOL as follow:
add the following line:
5) Compile and install Sysbench
make && make install
6) Test Sysbench
Missing required command argument.
sysbench [general-options]… –test=<test-name> [test-options]… command
–num-threads=N number of threads to use 
–max-requests=N limit for total number of requests 
–max-time=N limit for total execution time in seconds 
–forced-shutdown=STRING amount of time to wait after –max-time before forcing shutdown [off]
–thread-stack-size=SIZE size of stack per thread [32K]
–init-rng=[on|off] initialize random number generator [off]
–test=STRING test to run
–debug=[on|off] print more debugging info [off]
–validate=[on|off] perform validation checks where possible [off]
–help=[on|off] print help and exit
–version=[on|off] print version and exit
fileio – File I/O test
cpu – CPU performance test
memory – Memory functions speed test
threads – Threads subsystem performance test
mutex – Mutex performance test
oltp – OLTP test
Commands: prepare run cleanup help version
See ‘sysbench –test=<name> help’ for a list of options for each test.