Why is MySQL nearly twice as fast on Linux?

[JG]

>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.