Date: Mon, 22 Aug 2005 20:19:54 -0500 From: "Jim C. Nasby" <decibel@decibel.org> To: Uzi Klein <uzi@bmby.com> Cc: freebsd-database@freebsd.org, jmc <jcagle@gmail.com>, freebsd-hardware@freebsd.org Subject: Re: FreeBSD hardware solution for a database server Message-ID: <20050823011954.GM17203@decibel.org> 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 Sun, Aug 21, 2005 at 03:40:18PM +0200, Uzi Klein wrote: > 2 mirrored drives mounted as / > 3 RAID 5 drives mounted as /var RAID5 pretty much sucks for databases that do anything more than 1-5% writes. > Are you suggesting AMD based boxes outperforms Intel based machines? > That's what I'm really interested in... At least with PostgreSQL they do, by a large margin. > I know it's time for a dedicated fast database server. > If i optimized my database and hardware settings, i could gain months, > not more. > The question is upgrade to what (Assuming my DL380 isn't enough) Keep in mind that a poorly designed app will completely kill you once you try and scale past a certain level. Also, I've heard that PostgreSQL tends to do better on complex queries than MySQL if migrating is an option. Might be worth looking at. Note that the out-of-the-box config for PostgreSQL is appropriate for like a 486, so you'd need to do some tweaking. -- Jim C. Nasby, Database Architect decibel@decibel.org Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?"
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050823011954.GM17203>