From owner-freebsd-stable@FreeBSD.ORG Fri Jun 10 19:52:59 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 F0A3316A41C for ; Fri, 10 Jun 2005 19:52:59 +0000 (GMT) (envelope-from tom.hurst@clara.net) Received: from spork.qfe3.net (spork.qfe3.net [212.13.207.101]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9808543D1D for ; Fri, 10 Jun 2005 19:52:59 +0000 (GMT) (envelope-from tom.hurst@clara.net) Received: from [81.104.55.176] (helo=voi.aagh.net) by spork.qfe3.net with esmtp (Exim 4.50) id 1DgpYo-0000A0-4k; Fri, 10 Jun 2005 20:52:58 +0100 Received: from freaky by voi.aagh.net with local (Exim 4.51 (FreeBSD)) id 1DgpYn-000Dgb-NG; Fri, 10 Jun 2005 20:52:57 +0100 Date: Fri, 10 Jun 2005 20:52:57 +0100 From: Thomas Hurst To: Steve Roome Message-ID: <20050610195257.GA44343@voi.aagh.net> Mail-Followup-To: Steve Roome , freebsd-stable@freebsd.org References: <746fd037f6ca8131a8fb8938f1e346e9@lonres.com> <20050610170537.GA67849@bibipentium.lonres.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050610170537.GA67849@bibipentium.lonres.com> Organization: Not much. User-Agent: Mutt/1.5.9i Sender: Thomas Hurst X-RBL-Warning: 81.104.55.176 is in RBL blacklist at dnsbl.sorbs.net 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: Fri, 10 Jun 2005 19:53:00 -0000 * Steve Roome (steve@lonres.com) wrote: > We're trying to get FreeBSD to perform reasonably well, in comparison > to Linux, or even what we should expect to see. We're getting about > half the performance we get from gentoo on the same application > (mysql). Fancy giving CURRENT a try? For the record, we run FreeBSD 5.3 in production as our master database server without problems, so long as we keep the few heavy queries we do off it: Uptime: 6044357 Threads: 146 Questions: 1963912006 Slow queries: 1842 Opens: 182277 Flush tables: 3733 Open tables: 357 Queries per second avg: 324.917 But it would be nice not to fall back on Linux for our slaves to do the heavy lifting. Maybe FreeBSD 6 will be less disappointing in this regard. -- Thomas 'Freaky' Hurst http://hur.st/