From owner-freebsd-stable@FreeBSD.ORG Thu Jun 16 16:26:15 2005 Return-Path: X-Original-To: freebsd-stable@freebsd.org Delivered-To: freebsd-stable@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 3868516A41C; Thu, 16 Jun 2005 16:26:15 +0000 (GMT) (envelope-from rwatson@FreeBSD.org) Received: from cyrus.watson.org (cyrus.watson.org [204.156.12.53]) by mx1.FreeBSD.org (Postfix) with ESMTP id EEB5643D1F; Thu, 16 Jun 2005 16:26:14 +0000 (GMT) (envelope-from rwatson@FreeBSD.org) Received: from fledge.watson.org (fledge.watson.org [204.156.12.50]) by cyrus.watson.org (Postfix) with ESMTP id 78AA846BAA; Thu, 16 Jun 2005 12:26:14 -0400 (EDT) Date: Thu, 16 Jun 2005 17:28:27 +0100 (BST) From: Robert Watson X-X-Sender: robert@fledge.watson.org To: Steve Roome In-Reply-To: <20050616161506.GB28794@bibipentium.lonres.com> Message-ID: <20050616172638.Y27625@fledge.watson.org> References: <746fd037f6ca8131a8fb8938f1e346e9@lonres.com> <20050610170537.GA67849@bibipentium.lonres.com> <20050611085604.J75625@fledge.watson.org> <20050616161506.GB28794@bibipentium.lonres.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Mailman-Approved-At: Fri, 17 Jun 2005 12:49:01 +0000 Cc: steve@pepcross.com, freebsd-stable@freebsd.org, Guy Helmer , Kris Kennaway , Greg 'groggy' Lehey Subject: Re: FreeBSD MySQL still WAY slower than Linux X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 16 Jun 2005 16:26:15 -0000 On Thu, 16 Jun 2005, Steve Roome wrote: > The good news though, is that the Mysql folks have agreed to setup tests > to profile mysql on identical hardware running FreeBSD and Linux with an > aim to find out exactly where the problem really is. They reckon they'll > spend at least two weeks trying to find out why Linux is so much faster > - if they do this right I'd be surprised if we can't improve things > quite a lot. > > Also, it'd be good if any of you who still have an interest in this > could add any ideas or suggestions that may help *them* with their > testing. If so, just get in touch with me asap before they get too stuck > into anything that might prove fruitless. > > Here's hoping we can get MySQL running as well on FreeBSD as it ought > to. Please let me know if there's any support for this activity I can provide. I spent a fair amount of time identifying bottlenecks for MySQL in the 5.x cycle, and I know David Xu (davidxu@FreeBSD.org) has also spent quite a bit of time looking at the threading side, resulting in a lot of his work on libthr in 6.x. It would probably be a good idea to (a) move further discussion to performance@FreeBSD.org, and (b) make sure that the performance work is starting with a recent 6.x baseline (with debugging turned off). thanks for the time you've been putting into this! Robert N M Watson