FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64

[Kris Kennaway]

On Tue, Mar 13, 2007 at 09:19:08PM +0100, Martin wrote:

> > Also some more discussion would be useful, e.g. you appear to be
> > testing on different machines so the most important thing to
> > understand is how, or whether, the hardware differs.  You do link to
> > the dmesgs, but it's hard to process this into a summary form whereas
> > you presumably know the details.
> > 
> I use the same hw (3 dell 1435 server)
> 
> 
> > I am also unfamiliar with the benchmark itself, can you give me a
> > pointer to the software?  
> 
> I used sql-bench 
> /usr/ports/databases/mysql50-server/work/mysql-5.0.33/sql-bench/
> (at this time)
> the default Makefile of port have "--without-bench" options  so u need
> to make manually

Hmm.  This seems to be a single-user test, so while it's presumably
testing some relevant basic ingredients of database performance it's
probably not a realistic measure of server performance.  i.e. if you
really only have a maximum of one client accessing your database then
your 4-core system is being more than 75% wasted :)

> > If it is doing disk I/O then you may be
> > mostly measuring the speed of your disks, which is why the previous
> > paragraph is so important to understand.
> 
> the disk was the same of 3 test

OK, cool.

The difference between i386 and amd64 is actually kind of surprising.
I would have expected amd64 to be slower.  One thing that is missing
is an estimate of standard deviation of the data points: some
benchmarks have very high variance, meaning the numbers vary a lot
between runs; this makes direct comparison more difficult without
statistical work.  In FreeBSD the /usr/src/tools/tools/ministat
utility is excellent for this purpose.

Kris
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-stable/attachments/20070313/e9b49f26/attachment-0001.pgp