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