From owner-freebsd-stable@FreeBSD.ORG Mon Oct 23 23:09:38 2006 Return-Path: X-Original-To: stable@freebsd.org Delivered-To: freebsd-stable@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 14E8216A5B0 for ; Mon, 23 Oct 2006 23:09:38 +0000 (UTC) (envelope-from wmoran@collaborativefusion.com) Received: from mx00.pub.collaborativefusion.com (mx00.pub.collaborativefusion.com [206.210.89.199]) by mx1.FreeBSD.org (Postfix) with ESMTP id 50ECE43D53 for ; Mon, 23 Oct 2006 23:09:37 +0000 (GMT) (envelope-from wmoran@collaborativefusion.com) Received: from localhost (c-71-60-174-60.hsd1.pa.comcast.net [71.60.174.60]) (AUTH: LOGIN wmoran, TLS: TLSv1/SSLv3,256bits,AES256-SHA) by wingspan with esmtp; Mon, 23 Oct 2006 19:09:36 -0400 id 00056427.453D4BB0.0000EFF2 Date: Mon, 23 Oct 2006 19:09:31 -0400 From: Bill Moran To: Mike Jakubik Message-Id: <20061023190931.73ab17d3.wmoran@collaborativefusion.com> In-Reply-To: <453D49D2.1010705@rogers.com> References: <453D49D2.1010705@rogers.com> Organization: Collaborative Fusion X-Mailer: Sylpheed version 2.2.7 (GTK+ 2.8.20; i386-portbld-freebsd6.1) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Cc: stable@freebsd.org Subject: Re: Running large DB's on FreeBSD X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 23 Oct 2006 23:09:38 -0000 Mike Jakubik wrote: > > I am in the process of implementing a fairly large mysql server for > an even larger company, and naturally i want to use FreeBSD. The > hardware will be an HP DL385, 2 x dual-core Opterons, 16GB RAM, 7 x 15k > rpm disks in a RAID5 setup. Generally speaking, RAID 5 is known for lousy performance in database loads. Consider using RAID 10. > So, first of all, am i crazy for choosing fbsd+mysql for this rather > than something like Solaris + Oracle? :) Well, you should be using FreeBSD+PostgreSQL, but that's just my religion. > Secondly, i am just looking for > some suggestions, opinions, success/failure story's that may help me > out. Is anyone out there using FreeBSD for something of this size? I am > hoping that everything will work out well, and the client will be happy. > This would generate some good PR for FreeBSD, as it is a very large > international company and it would be the first FreeBSD server (that i > know of) of this type there. Yes, this is being done. I would suggest surfing the Postgresql performance mailing list archives a bit. There are often discussions of huge databases there: http://archives.postgresql.org/pgsql-performance/ -- Bill Moran The presence of stale files in this directory can cause the dreaded unpredictable results, and therefore it is highly recommended that you delete them.