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

[Steven Hartland]

I'd say that's pretty conclusive that its only using one of the CPU's
Unfortunately I don't have any answers why :(

    Steve / K
----- Original Message ----- 
From: "JG" <amd64list at jpgsworld.com>

> 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
> /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: 
> mysql-server-5.0.0_2)
> 
>  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}' \
>                  --enable-thread-safe-client
> 
> 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. 



================================================
This e.mail is private and confidential between Multiplay (UK) Ltd. and the person or entity to whom it is addressed. In the event of misdirection, the recipient is prohibited from using, copying, printing or otherwise disseminating it or any information contained in it. 

In the event of misdirection, illegible or incomplete transmission please telephone (023) 8024 3137
or return the E.mail to postmaster at multiplay.co.uk.