From owner-freebsd-stable@FreeBSD.ORG  Tue Oct 24 01:25:07 2006
Return-Path: <owner-freebsd-stable@FreeBSD.ORG>
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 9A6F216A407
	for <stable@freebsd.org>; Tue, 24 Oct 2006 01:25:07 +0000 (UTC)
	(envelope-from jd@ugcs.caltech.edu)
Received: from riyal.ugcs.caltech.edu (riyal.ugcs.caltech.edu
	[131.215.176.123])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 5679443D4C
	for <stable@freebsd.org>; Tue, 24 Oct 2006 01:25:07 +0000 (GMT)
	(envelope-from jd@ugcs.caltech.edu)
Received: by riyal.ugcs.caltech.edu (Postfix, from userid 3640)
	id BDA1045806; Mon, 23 Oct 2006 18:25:05 -0700 (PDT)
Date: Mon, 23 Oct 2006 18:25:05 -0700
From: Paul Allen <nospam@ugcs.caltech.edu>
To: Mike Jakubik <mikej@rogers.com>
Message-ID: <20061024012505.GF30707@riyal.ugcs.caltech.edu>
References: <453D49D2.1010705@rogers.com>
	<3861E2E8-4232-4C46-8D0A-1B6079BCA07D@mac.com>
	<453D53ED.5050403@rogers.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <453D53ED.5050403@rogers.com>
Sender: jd@ugcs.caltech.edu
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 <freebsd-stable.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>, 
	<mailto:freebsd-stable-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-stable>
List-Post: <mailto:freebsd-stable@freebsd.org>
List-Help: <mailto:freebsd-stable-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>,
	<mailto:freebsd-stable-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 24 Oct 2006 01:25:07 -0000

>From Mike Jakubik <mikej@rogers.com>, Mon, Oct 23, 2006 at 07:44:45PM -0400:
> Chuck Swiger wrote:
> >On Oct 23, 2006, at 4:01 PM, Mike Jakubik wrote:
> >>   So, first of all, am i crazy for choosing fbsd+mysql for this 
> >>rather than something like Solaris + Oracle? :)
> >
> >Moderately...it kinda depends on the budget available.  I regard 
> >Solaris + Oracle as one of the most reliable combinations for moderate 
> >to extreme load, for a system that might well be in operation for five 
> >to ten years.  If I was going to do FreeBSD, I might look into 
> >Postgres instead of MySQL; well, I might look into something else than 
> >MySQL under many circumstances.  I've gotten some pretty good use out 
> >of OpenBase, for another choice.
> >
> 
> I believe the front-end application is MySQL dependent, but what is so 
> much better about PostgreSQL? I understand that it has some more 
> advanced features, but if they are not used, then what is the advantage? 
> (I really like the InnooDB storage in MySQL)

The argument for pgsql over mysql given freebsd is based on freebsd being
fairly competitive for process-based concurrency whereas the more refined
1:1 thread implementation in linux often gives mysql an edge on that platform.

pgsql vs. mysql performance comparisons are usually run on Linux and do not
necessarily predict performance under freebsd for the testload.

** Find a testload similar in structure to your workload before deciding;
   make sure that the testload uses hardware with similar bottlenecks to
   your production setup **