From owner-freebsd-questions@FreeBSD.ORG  Fri Aug 29 18:11:26 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 BBA1B1065677
	for <freebsd-questions@freebsd.org>;
	Fri, 29 Aug 2008 18:11:26 +0000 (UTC)
	(envelope-from fquest@ccstores.com)
Received: from mail.qcislands.net (mail.qcislands.net [209.53.238.4])
	by mx1.freebsd.org (Postfix) with ESMTP id 94DCC8FC1C
	for <freebsd-questions@freebsd.org>;
	Fri, 29 Aug 2008 18:11:26 +0000 (UTC)
	(envelope-from fquest@ccstores.com)
Received: from [209.53.237.85] (helo=dick.ccstores.com)
	by mail.qcislands.net with esmtp (Exim 4.69)
	(envelope-from <fquest@ccstores.com>)
	id 1KZ8RS-000CiO-ET; Fri, 29 Aug 2008 11:11:26 -0700
Received: from [192.168.1.4] by dick.ccstores.com with esmtp (Exim 4.69)
	(envelope-from <fquest@ccstores.com>)
	id 1KZ8Sk-0009FU-1n; Fri, 29 Aug 2008 11:12:46 -0700
Message-ID: <48B83BCF.9090406@ccstores.com>
Date: Fri, 29 Aug 2008 11:11:27 -0700
From: Jim Pazarena <fquest@ccstores.com>
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
To: FreeBSD <freebsd-questions@freebsd.org>
References: <495884.53943.qm@web33705.mail.mud.yahoo.com>
In-Reply-To: <495884.53943.qm@web33705.mail.mud.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-local_scan: locally submitted (85)
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:11:26 -0000

Abdullah Ibn Hamad Al-Marri wrote:
> ----- Original Message ----
>
>> From: Jim Pazarena <fquest@ccstores.com>
>> To: FreeBSD <freebsd-questions@freebsd.org>
>> Sent: Friday, August 29, 2008 8:34:14 PM
>> Subject: Mysql Performance Question  4.1.22 vs 5.1.26.rc
>>
>> 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?
>> -- 
>> Jim Pazarena  fquest@ccstores.com
>
> Kris said MySQL 5.1.x has performance issues.
>
> Why don't you try 5.0.x?
>
>  Regards,
> -Abdullah Ibn Hamad Al-Marri

I already 'updated' the databases to 5.1.26, and I do not think I can change
the databases to go 'back' to 5.0.

Oh my :-[
-- 
Jim Pazarena  fquest@ccstores.com