From owner-freebsd-stable@FreeBSD.ORG Thu Jun 16 16:15:03 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 5C23016A41C; Thu, 16 Jun 2005 16:15:03 +0000 (GMT) (envelope-from steve@lonres.com) Received: from anchor-post-31.mail.demon.net (anchor-post-31.mail.demon.net [194.217.242.89]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1AD6843D1F; Thu, 16 Jun 2005 16:15:03 +0000 (GMT) (envelope-from steve@lonres.com) Received: from mail.lonres.com ([194.70.153.187]) by anchor-post-31.mail.demon.net with esmtp (Exim 4.42) id 1DiwxL-000OzY-3G; Thu, 16 Jun 2005 16:11:04 +0000 Received: from bibipentium.lonres.com (bibipentium.lonres.com [10.10.10.225]) by mail.lonres.com (Postfix) with SMTP id C64752E0A2; Thu, 16 Jun 2005 17:14:57 +0100 (BST) Received: by bibipentium.lonres.com (sSMTP sendmail emulation); Thu, 16 Jun 2005 17:15:06 +0100 From: "Steve Roome" Date: Thu, 16 Jun 2005 17:15:06 +0100 To: Robert Watson , Daniel Eischen , Greg 'groggy' Lehey , Guy Helmer , Jon Dama , Kris Kennaway , Thomas Hurst , Xin LI , steve@pepcross.com Message-ID: <20050616161506.GB28794@bibipentium.lonres.com> References: <746fd037f6ca8131a8fb8938f1e346e9@lonres.com> <20050610170537.GA67849@bibipentium.lonres.com> <20050611085604.J75625@fledge.watson.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050611085604.J75625@fledge.watson.org> User-Agent: Mutt/1.4.2.1i X-Mailman-Approved-At: Fri, 17 Jun 2005 12:49:01 +0000 Cc: freebsd-stable@freebsd.org 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:15:03 -0000 Thank you all for your suggestions on this thread, here's a brief breakdown of most of the ideas from people: Billy Newsom: COMPILER, DISK, MYSQLVERSION Daniel Eischen: +/-HTT, Thread scopes Greg Lehey: MALLOC Guy Helmer: PREEMPTIVE, vfs.read_max Jon Dama: David Xu's Thrds, Ptmalloc, cpu affinity, sched+hwcacheing Kris Kennaway: +/-HTT Robert Watson: Thread scopes, LIBTHR/Linuxthr on 5 and 6?, LOCKING, HTT, SMP/UP Thomas Hurst: FreeBSD-current, Don't overload mysql! Vladimir Chukharev: COMPILEOPTS, TABLETYPES Xin Li: PROFILE, HTT insignificant The bad news is that I've not managed to get very far at all lately as MySQL has been crashing too much to even stop and test stuff elsewhere. 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. Thanks again everyone, Steve Roome