Why is MySQL nearly twice as fast on Linux?
JG
amd64list at jpgsworld.com
Sat May 22 15:38:59 PDT 2004
>
>Do you have any suggestions or ideas as to what the problem is?
Here's some interesting benchmarks I just did...
-----------------------------------------------------------------------
System Specs:
Dual AMD Opteron 240's (1.4ghz)
Tyan 2880UGNR server-class motherboard
2G PC-2700 reg ECC memory (2x 1gb modules)
(3) Identical 40g ATA100 hot-swap system drives (for testing different OS's)
LSI MegaRaid Zero channel RAID
RAID-0 array consisting of 2x 15krpm 18gig SCSI U160 drives. (mysql data dir)
-------------------------------------------------------------------------
OS / Software Configuration:
FreeBSD 5.2-CURRENT FreeBSD 5.2-CURRENT #0: Fri May 21 05:09:21 PDT 2004
MySQL Compiled from mysql40-server port with:
BUILD_OPTIMIZED=yes
CONFIGURE_ARGS= --localstatedir=${DB_DIR} \
--without-debug \
--without-readline \
--with-bench \
--without-extra-tools \
--without-libwrap \
--with-mysqlfs \
--with-vio \
--with-low-memory \
--with-comment='FreeBSD port: ${PKGNAME}' \
--enable-thread-safe-client
amd64f# ldd /usr/local/libexec/mysqld
/usr/local/libexec/mysqld:
libpthread.so.1 => /usr/lib/libpthread.so.1 (0x2008ac000)
libz.so.2 => /lib/libz.so.2 (0x2009d6000)
libcrypt.so.2 => /lib/libcrypt.so.2 (0x200ae5000)
libstdc++.so.4 => /usr/lib/libstdc++.so.4 (0x200bff000)
libm.so.2 => /lib/libm.so.2 (0x200de6000)
libc.so.5 => /lib/libc.so.5 (0x200f06000)
(Compiled with libpthread)
Also w/ http://people.freebsd.org/~deischen/mysql40-server.diffs patch.
-------------------------------------------------------------------------
BENCHMARK RESULTS:
Local test:
- Using AMD64-4BSD SMP kernel w/SCHED_4BSD
- Using default mysql config (no config file)
amd64f# super-smack update-select.smack 30 10000
Query Barrel Report for client smacker
connect: max=25ms min=4ms avg= 15ms from 30 clients
Query_type num_queries max_time min_time q_per_s
select_index 300000 11 0 2819.41
update_index 300000 7 0 2819.41
- Using AMD64-4BSD-NOSMP SINGLE CPU kernel w/SCHED_4BSD
- Using default mysql config (no config file)
amd64f# super-smack update-select.smack 30 10000
Query Barrel Report for client smacker
connect: max=21ms min=9ms avg= 16ms from 30 clients
Query_type num_queries max_time min_time q_per_s
select_index 300000 5 0 3015.96
update_index 300000 23 5 3015.96
The ONLY thing different between the two tests was a kernel with a
commented SMP line.
- and the single CPU kernel outperformed the dual CPU kernel.
More information about the freebsd-threads
mailing list