MySQL Benchmarking 1

From time to time every MySQL DBA needs to benchmark queries. Fortunately there are many benchmarking tools available. In this and future posts I will walk you through using various MySQL benchmarking tools.

• MySQL Super Smack: Sasha Pachev originally developed MySQL Super Smack. After that Jeremy Zawodny maintained it for some time. Currently it is maintained by Tony Bourke. The current downloadable version of Super Smack is 1.3.
  
  References:
  Using MySQL to benchmark operating system performance
  Part 2: Comparing MySQL Performance
  


• Sysbench: Primarily developed for MySQL, "SysBench is a modular, cross-platform and multi-threaded benchmark tool for evaluating OS parameters that are important for a system running a database under intensive load." Download current version of Sysbench (0.4.7).


• mybench: A "simple" MySQL benchmarking tool written in Perl by Jeremy Zawodny. Download version 1.0 of mybench.


• mysqlslap is a load emulation client available with MySQL 5.1.4 and later. Here's Brian "Krow" Aker's post about mysqlslap.

Sysbench
After downloading Sysbench, uncompress and extract files from the archive:

gunzip sysbench-0.4.7.tar.gz
tar -xvf sysbench-0.4.7.tar

Then navigate to the sysbench-0.4.7 directory and run

./configure

to configure the package.

[root@db32:/home/fmashraqi/install/bench/sysbench-0.4.7] ./configure
checking build system type... sparc-sun-solaris2.10
checking host system type... sparc-sun-solaris2.10
checking target system type... sparc-sun-solaris2.10
checking for a BSD-compatible install... config/install-sh -c
checking whether build environment is sane... yes
checking for gawk... no
checking for mawk... no
checking for nawk... nawk
checking whether make sets $(MAKE)... no
checking whether to compile with MySQL support... (cached) yes
checking whether to compile with Oracle support... (cached) no
checking whether to compile with PostgreSQL support... (cached) no
checking for style of include used by make... none
checking for gcc... no
checking for cc... no
checking for cc... no
checking for cl... no
configure: error: no acceptable C compiler found in $PATH
See `config.log' for more details.

Notice we got an error about no acceptable C compiler being found. To resolve this situation we need to add the path to gcc (or cc) to $PATH. So we open .bashrc file and export new value of $PATH

PATH=$PATH:/usr/local/bin:.
export PATH

Now to apply changes to our current shell, we "dot" the bashrc file.

 . /.bashrc

Running "gcc -v" now produces

 Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.10/3.3.2/specs
Configured with: ../configure --with-as=/usr/ccs/bin/as --with-ld=/usr/ccs/bin/ld --disable-nls
Thread model: posix
gcc version 3.3.2

Yay, we can now proceed with running ./configure.

To be continued...