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

JG amd64list at jpgsworld.com
Thu May 20 14:15:12 PDT 2004

Well... here's my first AMD64 hardware on i386 results using linuxthreads.

amd32f# uname -a
FreeBSD amd32f.attbi.com 5.2-RELEASE FreeBSD 5.2-RELEASE #0: Sun Jan 11 
04:21:45 GMT 2004

amd32f# /usr/local/libexec/mysqld --version
/usr/local/libexec/mysqld  Ver 4.1.1-alpha for portbld-freebsd5.2 on i386 
(FreeBSD port: mysql-server-4.1.1_2)

amd32f# ldd /usr/local/libexec/mysqld
         liblthread.so.3 => /usr/local/lib/liblthread.so.3 (0x2848f000)
         liblstdc++.so.4 => /usr/local/lib/liblstdc++.so.4 (0x284b4000)
         libz.so.2 => /lib/libz.so.2 (0x28570000)
         libcrypt.so.2 => /lib/libcrypt.so.2 (0x2857e000)
         libstdc++.so.4 => /usr/lib/libstdc++.so.4 (0x28597000)
         libm.so.2 => /lib/libm.so.2 (0x28653000)
         libc.so.5 => /lib/libc.so.5 (0x2866c000)

Port options:

Benchmark results:

Generating 500000 records...
Creation of 500000 records took 164 seconds.
Average of 3048.7804878049 records per second.
Creating records for 10 seconds...
Created 28176 records in 10 seconds.
Average of 2817.6 records per second.
Creating random 50000 md5 hash records.
Creation of 50000 random md5 hash inserts took 18 seconds.
Average of 2777.7777777778 records per second.
Creating random md5 hash records for 10 seconds...
Created 27379 random records in 10 seconds.
Average of 2737.9 records per second.

Your databases overall average score is 2845.5145663957 records per second.

Not the worst among the FreeBSD benchmarks, not the best

  - but still very bad compared to my Linux results :(

Btw, while it was running and I did a ps -H, there was only one MySQL 
process listed.
If I did a ps aux, there were (and still are) 12.

More information about the freebsd-amd64 mailing list