Skip site navigation (1)Skip section navigation (2)
Date:      Sat, 22 May 2004 21:33:22 -0700
From:      JG <amd64list@jpgsworld.com>
To:        freebsd-threads@freebsd.org
Subject:   Re: Why is MySQL nearly twice as fast on Linux? 
Message-ID:  <5.2.0.9.2.20040522212217.01511190@mail.ojoink.com>
In-Reply-To: <Pine.GSO.4.10.10405222334440.28212-100000@pcnet5.pcnet.com >
References:  <5.2.0.9.2.20040522153551.01459300@mail.ojoink.com>

next in thread | previous in thread | raw e-mail | index | archive | help


>Along with the other benchmarks it's still a little apples
>and oranges.  I've seen different versions of mysql run
>with different versions of FreeBSD.

I'm going to stick with 4.0.20 from now for tests.

Most of my tests were done on 4.0.20.


>  I'd like to see the
>same mysql version run on the same hardware with libpthread
>and linuxthreads.

I'll have to do that on the i386 install tomorrow, as Linuxthreads
is not available for FreeBSD/AMD64.


>This shows that -current (both SMP and UP) with libpthread is
>faster than linuxthreads (different versions of FreeBSD and
>mysql, though).

For FreeBSD nothing (remote) has been faster than the i386 Linuxthreads
test.

I'll do everything local tomorrow.


>Also, if you use the default mysql config settings, then
>FreeBSD remote vs Linuxthreads remote also wins (2685.53
>vs. 2091.10 from earlier post).

I understand what you're saying, but those numbers are horrible.


>What modifications are you making to /etc/my.cnf and why
>do they turn the results around the other way?

I used either my-huge.cnf or no config file at all (as noted in the 
benchmarks).




Tell me all the FreeBSD tests you want to see & I'll do them if I can.




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?5.2.0.9.2.20040522212217.01511190>