From owner-freebsd-stable@FreeBSD.ORG  Fri Jun 17 15:28:28 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 039A916A41C
	for <freebsd-stable@freebsd.org>; Fri, 17 Jun 2005 15:28:28 +0000 (GMT)
	(envelope-from jmartin37@speakeasy.net)
Received: from mail25.sea5.speakeasy.net (mail25.sea5.speakeasy.net
	[69.17.117.27]) by mx1.FreeBSD.org (Postfix) with ESMTP id D2B5B43D1F
	for <freebsd-stable@freebsd.org>; Fri, 17 Jun 2005 15:28:27 +0000 (GMT)
	(envelope-from jmartin37@speakeasy.net)
Received: (qmail 20747 invoked from network); 17 Jun 2005 15:28:27 -0000
Received: from adsl-211-141-154.asm.bellsouth.net (HELO [192.168.2.101])
	(moonlightcheese@[68.211.141.154])
	(envelope-sender <jmartin37@speakeasy.net>)
	by mail25.sea5.speakeasy.net (qmail-ldap-1.03) with SMTP
	for <jfarmer@goldsword.com>; 17 Jun 2005 15:28:27 -0000
Message-ID: <42B2EC18.3030407@speakeasy.net>
Date: Fri, 17 Jun 2005 11:28:24 -0400
From: JM <jmartin37@speakeasy.net>
User-Agent: Mozilla Thunderbird 1.0.2-1.3.3 (X11/20050513)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: "J. T. Farmer" <jfarmer@goldsword.com>
References: <6.2.1.2.2.20050617103807.058c6fa8@mail.distrust.net>	<005c01c57354$3e877900$fe00a8c0@uzi>
	<42B2E9B5.7090803@goldsword.com>
In-Reply-To: <42B2E9B5.7090803@goldsword.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
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 15:28:28 -0000

J. T. Farmer wrote:

> Uzi wrote:
>
>> [...]
>>
>>> 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?  
>
>
>
> Try reading it again.  The last time I checked, 24k queries/sec _is_ 
> faster than
> 20k queries/sec.  And 4.5k queries/sec is faster than 4.0k queries/sec.
>
> John
>
i think you're missing the point... using CURRENT on a production 
machine is a bad idea...  the performance is great, but hardly worth the 
risk of breaking something.