From owner-freebsd-performance@FreeBSD.ORG Tue Jun 28 05:59:28 2005 Return-Path: X-Original-To: performance@freebsd.org Delivered-To: freebsd-performance@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 63FC516A42A for ; Tue, 28 Jun 2005 05:59:28 +0000 (GMT) (envelope-from martin@gneto.com) Received: from mxfep01.bredband.com (mxfep01.bredband.com [195.54.107.70]) by mx1.FreeBSD.org (Postfix) with ESMTP id 78CB443D49 for ; Tue, 28 Jun 2005 05:59:26 +0000 (GMT) (envelope-from martin@gneto.com) Received: from as6-1-5.kr.m.bonet.se ([83.227.181.30] [83.227.181.30]) by mxfep01.bredband.com with ESMTP id <20050628055922.LRSS24612.mxfep01.bredband.com@as6-1-5.kr.m.bonet.se>; Tue, 28 Jun 2005 07:59:22 +0200 Received: from [192.168.10.11] (euklides.gneto.com [192.168.10.11]) by as6-1-5.kr.m.bonet.se (Postfix) with ESMTP id 4E353678B9; Tue, 28 Jun 2005 07:59:12 +0200 (CEST) Message-ID: <42C0E730.5010703@gneto.com> Date: Tue, 28 Jun 2005 07:59:12 +0200 From: Martin Nilsson User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050326) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Steve Roome References: <20050623145041.GC64879@bibipentium.lonres.com> <42BD64F1.4080001@roq.com> <20050627134146.GA626@bibipentium.lonres.com> In-Reply-To: <20050627134146.GA626@bibipentium.lonres.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: performance@freebsd.org Subject: Re: FreeBSD MySQL still WAY slower than Linux X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 28 Jun 2005 05:59:28 -0000 Steve Roome wrote: > Sorry, good point, here's the my.cnf we're using. Please note however > that although the configuration may not be optimal, we have been using > the same config for benchmarking on Linux also. No matter how broken > this my.cnf is we still shouldn't find MySQL running half the speed on > an "identical" setups only switching from Linux to FreeBSD. Hi, Have you tested some more real-world queries on Linux vs. FreeBSD? The select-key.smack is a very simple test, a very small table (5.3MB on disk, 90k rows), no joins/sorts and only selects from index. Maybe the performance difference just affects the connect/communication/thread syncronistaion and thus this simple test is a worst case test of performance between Linux & FreeBSD. I'll try to set up something here so I can make some tests too... How does a P4/Xeon compare to Athlon64/Opteron on these tests (Linux vs FreeBSD) the long pipeline in the P4 (Prescott/Nocona) is difficult to optimize for, SMP syncronisation is also much more expensive on netburst, maybe the are better at doing this in Linux? Regards, Martin