- 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.
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.
After downloading Sysbench, uncompress and extract files from the archive:
tar -xvf sysbench-0.4.7.tar
Then navigate to the sysbench-0.4.7 directory and run
./configureto configure the package.
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
Now to apply changes to our current shell, we "dot" the bashrc file.
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...