Re: MySQL timings

[Dimitri Kovalov <dimitri_kovalov@xxxxxxxxx>]

--- "Justin C. Sherrill" <justin@xxxxxxxxxxxxxxxxxx> wrote:

> On Mon, June 19, 2006 10:08 am, Dimitri Kovalov wrote:
> > I have a test application that loads a database with
> about
> > 20K records. Just sequential writes and I get very
> strange
> > results. With 1 CPU it take :49 and with 2 cpu it take
> > 2:55. Is this possible? Its a slow disk but I surprized
> by
> > results.
> 
> MySQL performance is historically poorer under FreeBSD,
> and we probably
> inherited the general malaise.  (Note I'm saying that
> without benchmarking
> it myself...)  You may want to look at:
> 
>
http://software.newsforge.com/article.pl?sid=04/12/27/1243207
>
http://www.mysqlperformanceblog.com/2006/06/15/freebsd-tests/
> http://wikitest.freebsd.org/MySQL
> 
> Interestingly, that second link shows much better results
> with a
> 4BSD-style scheduler, which is what we pretty much have
> now.
> 
> 
I was more concerned with the difference between one cpu
and two. But I don't know what happened. Now I'm getting
:49 for 1 cpu and 1:01 for 2, which is more right for me.

Dimitri


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com