From owner-freebsd-performance@FreeBSD.ORG  Sun Oct 15 00:44:10 2006
Return-Path: <owner-freebsd-performance@FreeBSD.ORG>
X-Original-To: freebsd-performance@freebsd.org
Delivered-To: freebsd-performance@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 6D3FE16A403
	for <freebsd-performance@freebsd.org>;
	Sun, 15 Oct 2006 00:44:10 +0000 (UTC)
	(envelope-from jbell@stelesys.com)
Received: from stelesys.com (web3.stelesys.com [63.175.100.43])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 14A8543D46
	for <freebsd-performance@freebsd.org>;
	Sun, 15 Oct 2006 00:44:09 +0000 (GMT)
	(envelope-from jbell@stelesys.com)
Received: from [127.0.0.1] (helo=www.stelesys.com)
	by stelesys.com with esmtpa (Exim 4.63 (FreeBSD))
	(envelope-from <jbell@stelesys.com>)
	id 1GYu6r-000FmO-12; Sat, 14 Oct 2006 20:44:09 -0400
Received: from 71.56.92.181
	(SquirrelMail authenticated user jbell@stelesys.com)
	by www.stelesys.com with HTTP; Sat, 14 Oct 2006 20:44:09 -0400 (EDT)
Message-ID: <1227.71.56.92.181.1160873049.squirrel@www.stelesys.com>
In-Reply-To: <7.0.1.0.0.20061013161851.14c2f978@sentex.net>
References: <3731.71.56.92.181.1160009571.squirrel@www.stelesys.com>
	<45255A36.5010108@quip.cz>
	<2840.71.56.92.181.1160090644.squirrel@www.stelesys.com>
	<452603CA.8070800@thebeastie.org>
	<4472.209.134.164.20.1160162446.squirrel@www.stelesys.com>
	<7.0.1.0.0.20061013161851.14c2f978@sentex.net>
Date: Sat, 14 Oct 2006 20:44:09 -0400 (EDT)
From: "Jerry Bell" <jbell@stelesys.com>
To: "Mike Tancsa" <mike@sentex.net>
User-Agent: SquirrelMail/1.4.6-rc1
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Priority: 3 (Normal)
Importance: Normal
Cc: freebsd-performance@freebsd.org
Subject: Re: Help with improving mysql performance on 6.2PRE
X-BeenThere: freebsd-performance@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Performance/tuning <freebsd-performance.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-performance>
List-Post: <mailto:freebsd-performance@freebsd.org>
List-Help: <mailto:freebsd-performance-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sun, 15 Oct 2006 00:44:10 -0000

I will do some testing tonight with variations in the my.cnf file and post
the results tomorrow.

> At 03:20 PM 10/6/2006, Jerry Bell wrote:
>>I have actually made the changes to my.cnf before I ran these.  I
>> expanded
>>them quite a bit beyond what is in my-large.cnf.  I need to pull them
>> back
>
> Hi,
>          I was just looking at this thread as its relevant to a new
> DB server I am trying to put together. For the archives, can you post
> what you found to be your optimal configuration for mysql on 6.2 ?
>
>          ---Mike
>
>