From owner-freebsd-stable@FreeBSD.ORG Tue Oct 24 01:10:07 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 F38FA16A47C for ; Tue, 24 Oct 2006 01:10:06 +0000 (UTC) (envelope-from chinhngt@sectorb.msk.ru) Received: from hq.sectorb.msk.ru (petaflop.b.gz.ru [194.88.210.5]) by mx1.FreeBSD.org (Postfix) with ESMTP id 749ED43D45 for ; Tue, 24 Oct 2006 01:10:05 +0000 (GMT) (envelope-from chinhngt@sectorb.msk.ru) Received: from it.local (it.local [172.16.20.8]) by hq.sectorb.msk.ru (Postfix) with ESMTP id A2EFF95C; Tue, 24 Oct 2006 05:10:00 +0400 (MSD) Date: Tue, 24 Oct 2006 05:10:19 +0400 (MSD) From: Nguyen Tam Chinh X-X-Sender: chinhngt@it.hackers To: Bill Moran In-Reply-To: <20061023190931.73ab17d3.wmoran@collaborativefusion.com> Message-ID: <20061024050121.Q923@it.hackers> References: <453D49D2.1010705@rogers.com> <20061023190931.73ab17d3.wmoran@collaborativefusion.com> X-Operating-System: FreeBSD 6-STABLE Keywords: 216091683 MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed Cc: Mike Jakubik , 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: Tue, 24 Oct 2006 01:10:07 -0000 On Mon, 23 Oct 2006, Bill Moran wrote: > 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. > This is not another holy war, we also have a dual Xeon 3.6, 2xSCSI RAID0, 8GB of RAM and a database of 40Gb. But after using mysql 5.0 with all performance tricks I found in google and FreeBSD Wiki page, we decided to change to PostgreSQL and now are happy with it. PS. RAID5 is a bad choice for large DB. I'd recommended a RAID0 with standalone backup server. ----- With best regards, | The Power to Serve Nguyen Tam Chinh | http://www.FreeBSD.org Loc: sp.cs.msu.su |