FreeBSD MySQL still WAY slower than Linux

[Mark Kirkwood]

Steve Roome wrote:

> I posted these results and anything else that went with this thread to
> the freebsd-performance mailing list.
> 
> -current proved a slightly better performer for us, but not enough to
> bring it even close to the performance we get with gentoo.
> 
> Off the top of my head the select key benchmarks were ROUGHLY:
> 
> FreeBSD 5.various + MySQL 4.various    : ROUGHLY 16k queries/second
> FreeBSD 6.0-current + MySQL 4.1.12     : ROUGHLY 18k queries/second
> Gentoo-something + MySQL 4.1.something : ROUGHLY 30k queries/second.
> 
> The exact figures were posted to performance- (6.0 tests) and stable-
> (gentoo vs. freebsd 5.x).
> 
> Good luck to anyone who can manage to get MySQL to perform as well on
> FreeBSD as Linux, we've been right out of luck so far and that's
> really not advocating FreeBSD very well, which is what I'd rather be
> doing.
> 

I missed the mail where you mentioned this (apologies), thanks for 
updating us, well - me anyway :-)

Hmmm - the results are a bit discouraging aren't they? I notice that 
(you mentioned) the Mysql guys were going to see if they can identify 
where the issue is. That would be good!

best wishes

Mark