On Mon, Oct 01, 2007 at 05:33:45PM +0100, Andrew Doran wrote:

quoted text
> On Sun, Sep 30, 2007 at 11:14:40PM +0000, Jaime Fournier wrote:
> 
> > http://www.netbsd.org/~ober/
> > Some basic tests on a 4x P-III 500mhz Xeon with 2MB L2.
> > I created one million rows and ran sysbench in oltp mode in both default 
> > ReadWrite, and Readonly.
> > 
> > Did not make use of ZFS or any other optimizations.
> > Will be testing the recommendations for Mysql on Solaris.
> 
> Nice! If you fancy doing more tests, here are some files that might be of
> use:
> 
> http://www.netbsd.org/~ad/sysbench/my.cnf
> http://www.netbsd.org/~ad/sysbench/jemalloc-libc.tar.gz
> http://www.netbsd.org/~ad/sysbench/start.sh
> http://www.netbsd.org/~ad/sysbench/netbsd.bz2
> 
> start.sh ups the limits and sets LD_LIBRARY_PATH so that MySQL is using the
> libc with jemalloc. netbsd.bz2 is a kernel from the 'vmlocking' branch. It
> will panic if you unmount a file system, so make sure you do a few syncs
> before shutting the machine down if you do run it.. If you experiment with
> driving the machine with sysbench remotely, the host needs to be reasonably
> powerful (say, a 3GHz Pentium 4) or it will not be able to keep the DB fully
> loaded.

Something that Jeff Roberson mentioned to me (but that I have not tried to
reproduce) is that once you do a read/write run, the performance of the DB
is permanently changed. So it may make sense to reinitialize the DB if doing
another read-only run.

Andrew