From owner-freebsd-database@FreeBSD.ORG  Tue Nov 15 13:26:11 2005
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
X-Original-To: freebsd-database@freebsd.org
Delivered-To: freebsd-database@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id DB7B116A41F
	for <freebsd-database@freebsd.org>;
	Tue, 15 Nov 2005 13:26:11 +0000 (GMT)
	(envelope-from joseph.koshy@gmail.com)
Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.194])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 6FA4543D46
	for <freebsd-database@freebsd.org>;
	Tue, 15 Nov 2005 13:26:11 +0000 (GMT)
	(envelope-from joseph.koshy@gmail.com)
Received: by xproxy.gmail.com with SMTP id s9so830961wxc
	for <freebsd-database@freebsd.org>;
	Tue, 15 Nov 2005 05:26:11 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=Itq4WoQ4YAP63hJPYN9eJnSx7R1rOWlGKhePIx0O7+vAI/DmEbZ7lQderYn0ZolI1mGt4xp1WNbgt5izjgf3u2iSl7DnngcJG6a5NaEmoUlPE6vLPqcsUXLHbhf6MplE3LdaALlItTy9wyyOdj7QfcwIgjgI9XwjnzIvn1pBqK8=
Received: by 10.70.54.2 with SMTP id c2mr2739510wxa;
	Tue, 15 Nov 2005 05:18:56 -0800 (PST)
Received: by 10.70.105.13 with HTTP; Tue, 15 Nov 2005 05:18:56 -0800 (PST)
Message-ID: <84dead720511150518m250e073bgdbf9afe2dd4a3894@mail.gmail.com>
Date: Tue, 15 Nov 2005 18:48:56 +0530
From: Joseph Koshy <joseph.koshy@gmail.com>
To: Ashok Shrestha <ashok.shrestha@gmail.com>
In-Reply-To: <79e2026f0511142357m6093e636y6a988725d783391f@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <79e2026f0511142357m6093e636y6a988725d783391f@mail.gmail.com>
Cc: freebsd-database@freebsd.org, freebsd-performance@freebsd.org
Subject: Re: HowTo Get Max Peform with MySQL 5.0 and FreeBSD 5.4 ??
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Database use and development under FreeBSD
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 15 Nov 2005 13:26:12 -0000

On 11/15/05, Ashok Shrestha <ashok.shrestha@gmail.com> wrote:
> I'm using MySQL 5.0.15 with FreeBSD 5.4-RELEASE amd64.

> I would like to get the maximum performance out of this box.
> What options (MAKE, kernel, etc...) should I use to achieve
> this? What about loading the INDEX file into memory?

You might want to take a look at:

  http://wikitest.freebsd.org/moin.cgi/MySQL


--
FreeBSD Volunteer,     http://people.freebsd.org/~jkoshy