From owner-freebsd-database@FreeBSD.ORG Tue Nov 15 07:57:06 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 D197016A41F for ; Tue, 15 Nov 2005 07:57:06 +0000 (GMT) (envelope-from ashok.shrestha@gmail.com) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.205]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0622243D53 for ; Tue, 15 Nov 2005 07:57:05 +0000 (GMT) (envelope-from ashok.shrestha@gmail.com) Received: by wproxy.gmail.com with SMTP id i31so1152564wra for ; Mon, 14 Nov 2005 23:57:05 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=SVln6foxu+xrckgpn1MN3Afc2Kjni++Pf/eZAYRn4O3z8bgJup7L6Sl6DCMRD9FeC9qjrQHm9A7hXH1fDOGpVnGrmX5E3vdq+8iihM0CG+5wa0Ag1AACam4MZ+Oi/URNLkheuvjJTIwV+3HhL3HEn3dsRy29BT0bmDadavo11vg= Received: by 10.54.76.9 with SMTP id y9mr3958499wra; Mon, 14 Nov 2005 23:57:04 -0800 (PST) Received: by 10.54.72.2 with HTTP; Mon, 14 Nov 2005 23:57:04 -0800 (PST) Message-ID: <79e2026f0511142357m6093e636y6a988725d783391f@mail.gmail.com> Date: Tue, 15 Nov 2005 02:57:04 -0500 From: Ashok Shrestha To: freebsd-database@freebsd.org, freebsd-performance@freebsd.org MIME-Version: 1.0 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: Subject: 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: Tue, 15 Nov 2005 07:57:06 -0000 I'm using MySQL 5.0.15 with FreeBSD 5.4-RELEASE amd64. The box specs: CPU: Dual Core AMD Opteron(tm) Processor 275 (2193.76-MHz K8-class CPU) Memory: 4 GB My databases will be anywhere from 2GB-20GB. 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? Should I build WITH_LINUXTHREADS? Is it still necessary to do so on FreeBSD 5.4? I know it is better on a 4.X machine. Note: It is not possible to buil= d WITH_LINUXTHREADS on a FreeBSD 5.4 AMD64. What are the advantages of building with (MAKE) BUILD_OPTIMIZED? Is there an advantage in using a 64bit FreeBSD? How should I configure the following in /etc/loader.conf? I could not find an authoritative definition any of these variables; do you know of any? kern.maxdsiz=3D"3221225472" # 3GB; should it be closer to 4GB? kern.dfldsiz=3D"3221225472" # 3GB; should it be closer to 4GB? kern.maxssiz=3D"134217728" # 128MB; what is this? stack size? how large sho= uld I make it? -- Ashok Shrestha