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

[Kris Kennaway]

On Wed, Mar 14, 2007 at 01:27:22AM +0100, Alban Hertroys wrote:
> 
> On Mar 13, 2007, at 22:45, Kris Kennaway wrote:
> 
> >>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 :)
> 
> Sorry, couldn't resist...
> 
> This being mysql, the number of processors isn't going to matter  
> much, no matter how many connections you have. Mysql doesn't scale  
> very well to multiple cpu's.

This might be standard dogma, but it also appears not to be true:

  http://people.freebsd.org/~kris/scaling/mysql.html

> It doesn't compare[1] to a tuned PostgreSQL database, which I think  
> is a considerably more interesting benchmark. And of course that  
> would include multiple simultaneous connections.

On the same test postgresql is indeed faster, I haven't finished
benchmarking it yet though.

Kris