Re: Performance versus FreeBSD 7.0

Previous message: [thread] [date] [author]
Next message: [thread] [date] [author]
From: Andi Kleen
Date: Monday, March 3, 2008 - 5:34 am

"Stephen Cuppett" <cuppett@gmail.com> writes:


I posted a comment on that on the LWN thread, but their website 
has eaten it.

Anyways I would be very careful with any benchmarks testing mysql
especially on sysbench on larger systems (like they did with a 8 core
system). I did some similar testing on a slightly larger system (16 core) 
some time ago and found that mysql itself didn't scale at all.
With sysbench which only exercises a single table it would end up basically 
just banging on a single mysql user space lock and spend nearly all
the kernel time in the scheduler over-scheduling like crazy.

The FreeBSD people are not very clear on what they exactly benchmarked
(MySQL has lots of configuration options and engines), but I'll assume
they used the standard MyISAM.

I don't think that's a very useful benchmark to tune for in this
form at least not until MySQL is fixed to actually scale and sysbench
replaced with some a little more sane. It's worse than dbench. 

-Andi
--
Previous message: [thread] [date] [author]
Next message: [thread] [date] [author]

Messages in current thread:
Performance versus FreeBSD 7.0, Stephen Cuppett, (Fri Feb 29, 6:38 am)
Re: Performance versus FreeBSD 7.0, Diego Calleja, (Fri Feb 29, 7:54 am)
Re: Performance versus FreeBSD 7.0, Andi Kleen, (Mon Mar 3, 5:34 am)
Re: Performance versus FreeBSD 7.0, Nick Piggin, (Mon Mar 3, 6:04 am)
Re: Performance versus FreeBSD 7.0, Cyrus Massoumi, (Mon Mar 3, 12:02 pm)
Re: Performance versus FreeBSD 7.0, Nick Piggin, (Mon Mar 3, 12:24 pm)
Re: Performance versus FreeBSD 7.0, Cyrus Massoumi, (Mon Mar 3, 3:47 pm)
Re: Performance versus FreeBSD 7.0, Andi Kleen, (Mon Mar 3, 4:23 pm)
Re: Performance versus FreeBSD 7.0, Cyrus Massoumi, (Mon Mar 3, 10:51 pm)
Re: Performance versus FreeBSD 7.0, Nick Piggin, (Thu Mar 6, 5:53 am)
Re: Performance versus FreeBSD 7.0, Andi Kleen, (Thu Mar 6, 6:12 am)
Re: Performance versus FreeBSD 7.0, debian developer, (Thu Mar 6, 10:29 am)
Re: Performance versus FreeBSD 7.0, debian developer, (Thu Mar 6, 10:34 am)