Re: FreeBSD hardware solution for a database server
"Jim C. Nasby" <[email protected]>
| Newsgroups | gmane.os.freebsd.devel.hardware,gmane.os.freebsd.devel.database |
|---|---|
| Message-ID | <[email protected]> |
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 [email protected] 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?" _______________________________________________ [email protected] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-hardware To unsubscribe, send any mail to "[email protected]"