From owner-freebsd-amd64@FreeBSD.ORG Thu Sep 1 08:17:21 2005 Return-Path: X-Original-To: freebsd-amd64@freebsd.org Delivered-To: freebsd-amd64@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 674C616A41F for ; Thu, 1 Sep 2005 08:17:21 +0000 (GMT) (envelope-from freebsd@meijome.net) Received: from sigma.octantis.com.au (ns2.octantis.com.au [207.44.189.124]) by mx1.FreeBSD.org (Postfix) with ESMTP id EBFD243D48 for ; Thu, 1 Sep 2005 08:17:20 +0000 (GMT) (envelope-from freebsd@meijome.net) Received: (qmail 27179 invoked from network); 1 Sep 2005 18:17:15 +1000 Received: from andromeda.lef.com.au (HELO ?10.168.101.24?) (210.8.93.2) by sigma.octantis.com.au with (DHE-RSA-AES256-SHA encrypted) SMTP; 1 Sep 2005 18:17:15 +1000 Message-ID: <4316B906.50002@meijome.net> Date: Thu, 01 Sep 2005 18:17:10 +1000 From: Norberto Meijome User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Holger Kipp References: <4316A5BC.1000405@meijome.net> <20050901075851.GA19900@intserv.int1.b.intern> In-Reply-To: <20050901075851.GA19900@intserv.int1.b.intern> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-amd64@freebsd.org Subject: Re: Which SCHED_ for DB server X-BeenThere: freebsd-amd64@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting FreeBSD to the AMD64 platform List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 01 Sep 2005 08:17:21 -0000 Holger Kipp wrote: > Hello, > >>4 x SATA 150 drives, 90% of it RAID5 with gvinum. > > > I do not know your applications, but if writing to disk is an issue: > > - WAL-files should be written to physically separated disks. sorry, what do you mean by WAL-files > - Write performance to RAID5 is not very good (tm). > This is both with softraid and with hardware raid, although > those raid controllers with 64MB or higher (+batterybackup) > might increase the visible performance if only a few processes > generate disk-i/o-load. > - ATA is not good for production - better use SCSI. I hear you... Budget reasons forced me to use this. I could go RAID10, but I'd lose about 200 GB which I probably will need. thanks