From owner-freebsd-database@FreeBSD.ORG Fri Aug 19 13:06: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 1DCEC16A420 for ; Fri, 19 Aug 2005 13:06:38 +0000 (GMT) (envelope-from jcagle@gmail.com) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.202]) by mx1.FreeBSD.org (Postfix) with ESMTP id 16A4743D53 for ; Fri, 19 Aug 2005 13:06:36 +0000 (GMT) (envelope-from jcagle@gmail.com) Received: by rproxy.gmail.com with SMTP id r35so504795rna for ; Fri, 19 Aug 2005 06:06: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=JkmBZaGMQCUwVdmTTl/0XgeQtIPAoATUkngrNVNPSKnPnrlbm+jruA7oZYQ0/L2FJ+TSYKfGuXhFtHpRCBUgRazPQ9IncQlheLZgqRdn9KuEYJwsR/pdfrE++acwoYI7P2rDkV2X6tQ8S/DnNHH7cwYblglGXG3sgo2Ayt6q69k= Received: by 10.38.59.29 with SMTP id h29mr119616rna; Fri, 19 Aug 2005 06:06:36 -0700 (PDT) Received: by 10.38.90.20 with HTTP; Fri, 19 Aug 2005 06:06:36 -0700 (PDT) Message-ID: <6863f0c905081906061290c642@mail.gmail.com> Date: Fri, 19 Aug 2005 08:06:36 -0500 From: jmc To: Uzi In-Reply-To: <040f01c5a4b9$f5d2dff0$0700a8c0@uzi> 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> 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: Fri, 19 Aug 2005 13:06:38 -0000 For the best database-write performance on the DL380G4, make sure you have the Battery-Backed Write Cache (BBWC) option. 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.=20 RAID0 will give the best performance, but it's not redundant. Next is RAID1, then RAID5 or ADG. 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). Regards, John http://people.freebsd.org/~jcagle/ On 8/19/05, Uzi wrote: > Hi >=20 > I am looking for a FreeBSD 5.4 hardware/configuration solutions for a MyS= QL > database server. >=20 > My server is currently running FreeBSD 5.4 with a web/mail/database serve= r > on a Proliant DL380 G4 (dual Xeon 3.2, 2 GB ram), and the speed isn't fas= t > enough. >=20 > We have a pretty big database with allot of complex joins/indexes, so a > dedicated database server seems like the next step (among with > optimizing/normalizing the database). >=20 >=20 >=20 > Proliant DL580 looks fair to my eyes (as I'm pretty happy with HP) >=20 > But I have a few indecisions: >=20 >=20 >=20 > 1. 2/4 CPU >=20 > 2. Amount of ram (4 GB+) >=20 > 3. And most important (AFAIK) - Storage configuration (RAID 5 / RAID 0+1 > etc.) >=20 >=20 >=20 > What would be the preferred solution? >=20 >=20 >=20 > Thanks, >=20 > Uzi >=20 >=20 >=20 > P.S - Please CC me the replies as I'm not subscribed. Thanks. >=20 >=20 >=20 >=20 >=20 >=20 > _______________________________________________ > freebsd-hardware@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-hardware > To unsubscribe, send any mail to "freebsd-hardware-unsubscribe@freebsd.or= g" >