From owner-freebsd-database@FreeBSD.ORG Tue Aug 23 01:19:58 2005 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 4655D16A41F; Tue, 23 Aug 2005 01:19:58 +0000 (GMT) (envelope-from decibel@decibel.org) Received: from flake.decibel.org (flake.decibel.org [67.100.216.10]) by mx1.FreeBSD.org (Postfix) with ESMTP id E184743D45; Tue, 23 Aug 2005 01:19:57 +0000 (GMT) (envelope-from decibel@decibel.org) Received: by flake.decibel.org (Postfix, from userid 1001) id BF30D152AE; Mon, 22 Aug 2005 20:19:54 -0500 (CDT) Date: Mon, 22 Aug 2005 20:19:54 -0500 From: "Jim C. Nasby" To: Uzi Klein Message-ID: <20050823011954.GM17203@decibel.org> References: <040f01c5a4b9$f5d2dff0$0700a8c0@uzi> <6863f0c905081906061290c642@mail.gmail.com> <43088442.7000704@bmby.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <43088442.7000704@bmby.com> X-Operating-System: FreeBSD 4.11-RELEASE-p10 i386 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.9i Cc: freebsd-database@freebsd.org, jmc , freebsd-hardware@freebsd.org Subject: Re: FreeBSD hardware solution for a database server X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 23 Aug 2005 01:19:58 -0000 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?"