From owner-freebsd-stable@FreeBSD.ORG  Fri Jun 17 14:48:35 2005
Return-Path: <owner-freebsd-stable@FreeBSD.ORG>
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 3D09116A41C
	for <freebsd-stable@freebsd.org>; Fri, 17 Jun 2005 14:48:35 +0000 (GMT)
	(envelope-from uzi@bmby.com)
Received: from mail.ilovesex.co.il (line26-112.adsl.actcom.co.il
	[192.115.26.112])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 50A5743D49
	for <freebsd-stable@freebsd.org>; Fri, 17 Jun 2005 14:48:33 +0000 (GMT)
	(envelope-from uzi@bmby.com)
Received: from uzi ([192.168.0.254])
	by mail.ilovesex.co.il (8.13.3/8.13.3) with SMTP id j5HEnccD010364;
	Fri, 17 Jun 2005 17:49:39 +0300 (IDT) (envelope-from uzi@bmby.com)
Message-ID: <005c01c57354$3e877900$fe00a8c0@uzi>
From: "Uzi" <uzi@bmby.com>
To: "David Sze" <dsze@alumni.uwaterloo.ca>
References: <6.2.1.2.2.20050617103807.058c6fa8@mail.distrust.net>
Date: Fri, 17 Jun 2005 17:50:06 +0200
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="ISO-8859-1";
	reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2527
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
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 <freebsd-stable.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>, 
	<mailto:freebsd-stable-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-stable>
List-Post: <mailto:freebsd-stable@freebsd.org>
List-Help: <mailto:freebsd-stable-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>,
	<mailto:freebsd-stable-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 17 Jun 2005 14:48:35 -0000

[...]
> super-smack select-key
>         5.4-RELEASE             ~20,000 queries/second
>         6.0-CURRENT             ~24,000 queries/second
>         CentOS w/async  ~36,000 queries/second
>         CentOS w/sync   ~26,000 queries/second
>
> super-smack update-select
>         5.4-RELEASE             ~4,000 queries/second
>         6.0-CURRENT             ~4,500 queries/second
>         CentOS w/async  ~7,500 queries/second
>         CentOS w/sync   ~750 queries/second
>
> That last CentOS number is not a typo, it was an order of magnitude 
> slower.  I didn't try other file systems on CentOS, just the default ext3. 
> It's possible that reiserfs or xfs might not be as affected by switching 
> from async to sync.
>
> So my production server is now happily running mysql 4.1 on 6.0-CURRENT 
> :).

I don't get it.
You get 30% less perfomance, running a non-production release for 
production, and happy about it?

U.

>
>
>
> _______________________________________________
> freebsd-stable@freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-stable
> To unsubscribe, send any mail to "freebsd-stable-unsubscribe@freebsd.org"
>