Date: Fri, 19 Aug 2005 08:06:36 -0500 From: jmc <jcagle@gmail.com> To: Uzi <uzi@bmby.com> Cc: freebsd-database@freebsd.org, freebsd-hardware@freebsd.org Subject: Re: FreeBSD hardware solution for a database server Message-ID: <6863f0c905081906061290c642@mail.gmail.com> In-Reply-To: <040f01c5a4b9$f5d2dff0$0700a8c0@uzi> References: <040f01c5a4b9$f5d2dff0$0700a8c0@uzi>
next in thread | previous in thread | raw e-mail | index | archive | help
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 <uzi@bmby.com> 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" >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?6863f0c905081906061290c642>