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

[Gregor Bittel]

Hi,

On Donnerstag, 20. Mai 2004 21:33 JG wrote:
> After I do my i386 OS / AMD64 hardware benchmarking tests, I'll
> post the results here and then a summary of all of this to
> freebsd-threads as it does seem to be becoming more of an issue for
> them than the AMD64 team.
>
> I guess we'll know that from the upcoming i386 benchmarks, how
> libpthreads is working for MySQL on either port.

Sure, I'm really off-topic now (don't hit me), but I have running
MySQL on my workstation since a few weeks just for fun and testing
for my small database.
My setup is: Dual-Xeon 2,4GHz on a Tiger S2668AN running on
4.8-Release, 2GB memory, Mylex Raid-5 with 4x 18GB-Disks and
with this MySQL-version:
=>pkg_info | grep -i mysql
mysql-client-3.23.55 Multithreaded SQL database (client)
mysql-server-3.23.55 Multithreaded SQL database (server)
p5-Mysql-modules-1.2216 Perl5 modules for accessing MySQL databases
phpMyAdmin-2.3.2    A set of PHP-scripts to adminstrate MySQL

I think it is _not_ comparable between the different MySQL-Versions,
is it?

This are the kernel-"tweaks" (not very interesting):
machdep.cpu_idle_hlt=1
vfs.ioopt=1

and this are the results of mybench:
Generating 500000 records...
Creation of 500000 records took 50 seconds.
Average of 10000 records per second.
Creating records for 10 seconds...
Created 94526 records in 10 seconds.
Average of 9452.6 records per second.
Creating random 50000 md5 hash records.
Creation of 50000 random md5 hash inserts took 6 seconds.
Average of 8333.33333333 records per second.
Creating random md5 hash records for 10 seconds...
Created 77027 random records in 10 seconds.
Average of 7702.7 records per second.
Your databases overall average score is 8872.15833333 records per
second.

@Jeremy:
> Mine is the S2880UGNR which has the LSI SCSI chipset & allows
> you to expand it to raid with the LSI Megaraid 320-0 zero channel
> raid card.

Ok, I see - but this one (S2880UGNR) isn't on the list[1], too :)
If you are installing next time the 32Bit-Version, I will add both
dmesgs+mptables, if I get it.

-Gregor.

-- 
Gregor.Bittel at GMX.de
[1]= http://www.bnv-bamberg.de/home/ba3294/smp/index.htm