From owner-freebsd-database@FreeBSD.ORG Sun Aug 21 19:15:38 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 DC06216A41F for ; Sun, 21 Aug 2005 19:15:38 +0000 (GMT) (envelope-from jcagle@gmail.com) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.197]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6709C43D46 for ; Sun, 21 Aug 2005 19:15:37 +0000 (GMT) (envelope-from jcagle@gmail.com) Received: by rproxy.gmail.com with SMTP id r35so848167rna for ; Sun, 21 Aug 2005 12:15:36 -0700 (PDT) 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=N9AVhfn1WFLBCvAWVw7czBGm6a8u7RhrGnM5s9hEfKDWH/aSwRqdkHoS9AY0FU0wOpeFJI/SUcUs02a989mqEySDGekvHMCKrqvJ5ct+UU5yyPUCfB8wdYjhEBqetTB5ISKGt9NZ3BjdJ2WKdc9Yn9FPL1skuYMUcbWeW59XwPg= Received: by 10.38.90.57 with SMTP id n57mr448344rnb; Sun, 21 Aug 2005 12:15:36 -0700 (PDT) Received: by 10.38.90.20 with HTTP; Sun, 21 Aug 2005 12:15:36 -0700 (PDT) Message-ID: <6863f0c9050821121520d2b076@mail.gmail.com> Date: Sun, 21 Aug 2005 14:15:36 -0500 From: jmc To: Uzi Klein In-Reply-To: <43088442.7000704@bmby.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <040f01c5a4b9$f5d2dff0$0700a8c0@uzi> <6863f0c905081906061290c642@mail.gmail.com> <43088442.7000704@bmby.com> Cc: freebsd-database@freebsd.org, freebsd-hardware@freebsd.org Subject: Re: FreeBSD hardware solution for a database server 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: Sun, 21 Aug 2005 19:15:39 -0000 On 8/21/05, Uzi Klein wrote: >=20 > jmc wrote: > > For the best database-write performance on the DL380G4, make sure you > > have the Battery-Backed Write Cache (BBWC) option. >=20 > Never heard of it. I'd take it as a hardware setup in BIOS? > (The server is in co-location, i have no physical access to it but i can > explain ISP sys-admin what to do if needed) It's an optional hardware module with 128MB of cache that survives power outages (which is key when using it as a write cache). However, if you have the DL380G4 with the SAS P600 controller, it already has 256MB of BBWC built in. > > The more spindles you have, the better. Are you using all 6 drive > > bays in the 380? Make sure they're all Ultra320 drives. 15K will > > give the best performance, but the 10K drives aren't too shabby. > > RAID0 will give the best performance, but it's not redundant. Next is > > RAID1, then RAID5 or ADG. >=20 > I have 5 drives 36 GB Ultra320 15K: >=20 > 2 mirrored drives mounted as / > 3 RAID 5 drives mounted as /var >=20 > www# df -h > Filesystem Size Used Avail Capacity Mounted on > /dev/da0s1a 33G 4.7G 26G 16% / > devfs 1.0K 1.0K 0B 100% /dev > /dev/da1s1d 62G 9.5G 47G 17% /var >=20 > > You might also try a DL385 (dual socket Opteron) or DL585 (quad socket > > Opteron) which will give you either 4 or 8 procs (if they are dual > > core). >=20 > Are you suggesting AMD based boxes outperforms Intel based machines? > That's what I'm really interested in... I can't really say that. It all depends on the application. If FreeBSD had NUMA support, then the Opteron's architecture would have a big advantage for memory-intensive applications.