From owner-freebsd-threads@FreeBSD.ORG Sat May 22 15:38:59 2004 Return-Path: Delivered-To: freebsd-threads@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 38D8B16A4CF for ; Sat, 22 May 2004 15:38:59 -0700 (PDT) Received: from ojoink.com (center.ojoink.com [216.65.123.180]) by mx1.FreeBSD.org (Postfix) with ESMTP id 12E5143D41 for ; Sat, 22 May 2004 15:38:59 -0700 (PDT) (envelope-from amd64list@jpgsworld.com) Received: (qmail 19276 invoked by uid 89); 22 May 2004 22:43:04 -0000 Received: from unknown (HELO MAINBX.jpgsworld.com) (amd64list@jpgsworld.com@24.10.96.33) by center.ojoink.com with SMTP; 22 May 2004 22:43:04 -0000 Message-Id: <5.2.0.9.2.20040522153551.01459300@mail.ojoink.com> X-Sender: amd64list@jpgsworld.com@mail.ojoink.com X-Mailer: QUALCOMM Windows Eudora Version 5.2.0.9 Date: Sat, 22 May 2004 15:38:42 -0700 To: freebsd-threads@freebsd.org From: JG In-Reply-To: <5.2.0.9.2.20040521154458.01627688@127.0.0.1> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed Subject: Re: Why is MySQL nearly twice as fast on Linux? X-BeenThere: freebsd-threads@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 22 May 2004 22:38:59 -0000 > >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.