Why is MySQL nearly twice as fast on Linux?

[JG]

At 09:59 AM 5/22/2004 +0300, you wrote:
>JG wrote:
>
>>
>>
>>Do you have any suggestions or ideas as to what the problem is?
>
>I failed to find benchmark numbers using libpthread or libthr. Did you 
>have some and I just missed them?
>
>Pete

Pete,

90% of the benchmarks I did were done with libptherads.

I haven't personally tested with libthr, but others have and their results 
were poor as well.

I wanted to avoid reposting pages of benchmarks, but I guess it's not going 
to happen.

I'll start posting mine here here soon, I'm going to retest everything 
local with super-smack
and run-all-tests today.

You can also see Mikes run-all-tests benchmarks here:
http://mikehost.com/~mike/tmp/bench.htm


Here is a quote from an email Chris Elsworth sent me:

"Just had a read through the web archive, all seems very familiar :)
A colleague and I spent hours fiddling with the various threading
libraries; kse, libc_r, libthr, linuxthreads I think were the main
ones - I mostly tweaked MySQL, he tweaked the threading libraries, and
nothing made any significant difference, so I'm not really convinced
this is even a threading problem - I don't see why all the threading
libraries we tried all struggle to outperform Linux's default
configuration on the same hardware."

Here is Chris Elsworths post to the MySQL general mailing list:
http://lists.mysql.com/mysql/165908

Here is an article at 2cpu.com showing how Linux improved 20%:
http://www.2cpu.com/articles/98_4.html
... But I wish I knew how he ran super-smack, those numbers are
insane.

And my original posts to the FreeBSD AMD64 list are here:
http://lists.freebsd.org/pipermail/freebsd-amd64/2004-May/

Scroll down to:

"Why is MySQL nearly twice as fast on Linux/AMD64 Vs. FreeBSD/AMD64?

A lot of top posts so it got broken up a few times.
-----------------------------------------------------------------------------------------------