From owner-freebsd-performance@FreeBSD.ORG  Fri Oct 13 20:22: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 1783816A47C
	for <freebsd-performance@freebsd.org>;
	Fri, 13 Oct 2006 20:22:10 +0000 (UTC) (envelope-from mike@sentex.net)
Received: from smarthost2.sentex.ca (smarthost2.sentex.ca [205.211.164.50])
	by mx1.FreeBSD.org (Postfix) with ESMTP id C906D43DA3
	for <freebsd-performance@freebsd.org>;
	Fri, 13 Oct 2006 20:21:55 +0000 (GMT) (envelope-from mike@sentex.net)
Received: from lava.sentex.ca (pyroxene.sentex.ca [199.212.134.18])
	by smarthost2.sentex.ca (8.13.8/8.13.8) with ESMTP id k9DKLthe034222;
	Fri, 13 Oct 2006 16:21:55 -0400 (EDT) (envelope-from mike@sentex.net)
Received: from mdt-xp.sentex.net (simeon.sentex.ca [192.168.43.27])
	by lava.sentex.ca (8.13.6/8.13.3) with ESMTP id k9DKLsUw048499
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO);
	Fri, 13 Oct 2006 16:21:54 -0400 (EDT) (envelope-from mike@sentex.net)
Message-Id: <7.0.1.0.0.20061013161851.14c2f978@sentex.net>
X-Mailer: QUALCOMM Windows Eudora Version 7.0.1.0
Date: Fri, 13 Oct 2006 16:19:56 -0400
To: "Jerry Bell" <jbell@stelesys.com>
From: Mike Tancsa <mike@sentex.net>
In-Reply-To: <4472.209.134.164.20.1160162446.squirrel@www.stelesys.com>
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>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed
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: Fri, 13 Oct 2006 20:22:10 -0000

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