From owner-freebsd-database@FreeBSD.ORG Thu Nov 17 17:58:00 2005 Return-Path: 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 18C7B16A41F for ; Thu, 17 Nov 2005 17:58:00 +0000 (GMT) (envelope-from ashok.shrestha@gmail.com) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.196]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7FE0E43D46 for ; Thu, 17 Nov 2005 17:57:59 +0000 (GMT) (envelope-from ashok.shrestha@gmail.com) Received: by wproxy.gmail.com with SMTP id i20so1775934wra for ; Thu, 17 Nov 2005 09:57:58 -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:references; b=AzPUKpFc/jTPnhU1XOuRKAt3He2sn45qxXdGfYfC6fLSFbk3Jr46sMBQmjOc4wnyB2spVG3WxGxzFm5bx1hEkyN72hSKvO3Nw39Sqm5Os3mLZQIXKn1kgxsWcgiuXrj6APwqM7g7EsJCX4kbuaN0wMOtiAq9FpyJZb+BrXKiuXg= Received: by 10.54.101.18 with SMTP id y18mr7312103wrb; Thu, 17 Nov 2005 09:57:58 -0800 (PST) Received: by 10.54.72.2 with HTTP; Thu, 17 Nov 2005 09:57:58 -0800 (PST) Message-ID: <79e2026f0511170957l75c97958j33c278954cfc0b7c@mail.gmail.com> Date: Thu, 17 Nov 2005 12:57:58 -0500 From: Ashok Shrestha To: Joseph Koshy In-Reply-To: <84dead720511150518m250e073bgdbf9afe2dd4a3894@mail.gmail.com> MIME-Version: 1.0 References: <79e2026f0511142357m6093e636y6a988725d783391f@mail.gmail.com> <84dead720511150518m250e073bgdbf9afe2dd4a3894@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: freebsd-database@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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 17 Nov 2005 17:58:00 -0000 Thanx. I wanted to add more info to the wiki, but it appears that only developers are allowed to make changes. =3D( Do you know if this wiki will turn more public? On 11/15/05, Joseph Koshy wrote: > > On 11/15/05, Ashok Shrestha 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 > -- Ashok Shrestha