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. 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 > > I am looking for a FreeBSD 5.4 hardware/configuration solutions for a MySQL > database server. > > My server is currently running FreeBSD 5.4 with a web/mail/database server > on a Proliant DL380 G4 (dual Xeon 3.2, 2 GB ram), and the speed isn't fast > enough. > > 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). > > > > Proliant DL580 looks fair to my eyes (as I'm pretty happy with HP) > > But I have a few indecisions: > > > > 1. 2/4 CPU > > 2. Amount of ram (4 GB+) > > 3. And most important (AFAIK) - Storage configuration (RAID 5 / RAID 0+1 > etc.) > > > > What would be the preferred solution? > > > > Thanks, > > Uzi > > > > P.S - Please CC me the replies as I'm not subscribed. Thanks. > > > > > > > _______________________________________________ > freebsd-hardware@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-hardware > To unsubscribe, send any mail to "freebsd-hardware-unsubscribe@freebsd.org" >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?6863f0c905081906061290c642>