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

JG amd64list at jpgsworld.com
Wed May 19 06:30:30 PDT 2004

At 01:42 PM 5/19/2004 +0100, you wrote:
>Something silly to try on both linux and FreeBSD disable the
>second processor / use a none SMP kernel.
>Do you then see similar results?
>     Steve


Good idea. I just tried this & the results were in the same range.

The actual results are below:

FreeBSD 5.2-CURRENT FreeBSD 5.2-CURRENT #0: Tue May 18 07:17:39 PDT 2004

With SCHED_ULE & debugging turned off in kernel.
** WITHOUT SMP ** option in kernel (just testing single CPU results)

amd64f# ldd /usr/local/libexec/mysqld
         libpthread.so.1 => /usr/lib/libpthread.so.1 (0x2009ab000)
         libz.so.2 => /lib/libz.so.2 (0x200ad5000)
         libcrypt.so.2 => /lib/libcrypt.so.2 (0x200be4000)
         libstdc++.so.4 => /usr/lib/libstdc++.so.4 (0x200cfe000)
         libm.so.2 => /lib/libm.so.2 (0x200ee5000)
         libc.so.5 => /lib/libc.so.5 (0x201005000)

amd64f# /usr/local/libexec/mysqld --version
Ver 5.0.0-alpha for portbld-freebsd5.2 on amd64 (FreeBSD port: 

 From Makefile:
CONFIGURE_ARGS= --localstatedir=${DB_DIR} \
                 --without-debug \
                 --without-readline \
                 --without-libedit \
                 --without-bench \
                 --without-extra-tools \
                 --without-libwrap \
                 --with-mysqlfs \
                 --with-vio \
                 --with-low-memory \
                 --with-comment='FreeBSD port: ${PKGNAME}' \

Benchmark Results:

Generating 500000 records...
Creation of 500000 records took 166 seconds.
Average of 3012.0481927711 records per second.
Creating records for 10 seconds...
Created 31882 records in 10 seconds.
Average of 3188.2 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 27658 random records in 10 seconds.
Average of 2765.8 records per second.

Your databases overall average score is 2935.9564926372 records per second. 

More information about the freebsd-amd64 mailing list