From owner-freebsd-questions@FreeBSD.ORG  Fri Aug 29 18:21:28 2008
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 0F1141065675
	for <freebsd-questions@freebsd.org>;
	Fri, 29 Aug 2008 18:21:28 +0000 (UTC)
	(envelope-from pprocacci@datapipe.com)
Received: from fmailhost01.isp.att.net (fmailhost01.isp.att.net
	[204.127.217.101])
	by mx1.freebsd.org (Postfix) with ESMTP id EB56B8FC08
	for <freebsd-questions@freebsd.org>;
	Fri, 29 Aug 2008 18:21:27 +0000 (UTC)
	(envelope-from pprocacci@datapipe.com)
Received: from [10.5.21.122] (adsl-241-169-57.bna.bellsouth.net[74.241.169.57])
	by isp.att.net (frfwmhc01) with ESMTP
	id <20080829182127H01000j42de>; Fri, 29 Aug 2008 18:21:27 +0000
X-Originating-IP: [74.241.169.57]
Message-ID: <48B83E14.8050007@datapipe.com>
Date: Fri, 29 Aug 2008 13:21:08 -0500
From: "Paul A. Procacci" <pprocacci@datapipe.com>
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
To: Jim Pazarena <fquest@ccstores.com>
References: <48B83316.2020207@ccstores.com>
In-Reply-To: <48B83316.2020207@ccstores.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cc: FreeBSD <freebsd-questions@freebsd.org>
Subject: Re: Mysql Performance Question  4.1.22 vs 5.1.26.rc
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 29 Aug 2008 18:21:28 -0000

Jim Pazarena wrote:
> I changed from 4.1.22 to 5.1.26.rc and my performance in a very busy db,
> tanked!
>
> could the use of an 'rc' possibly be my issue?
>
> is there any chance that the 'rc' has debugging enabled which is 
> slowing me down?
Hello,

I've ran some tests just this past week (in fact I emailed 
freebsd-general about this yesterday), unfortunately however it was 
comparing performance between 5.0.51 and 5.1.26.

http://paul.procacci.me/benchmarks/freebsd7-Release.html

5.1 performs worse than 5.0 at higher workloads.  I'm unsure about 4, 
but am quite sure moving to 5.0 is probably the best decision you could 
make.

~Paul