From owner-freebsd-stable@FreeBSD.ORG  Mon Oct 23 23:47:37 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 E8AF116A407
	for <stable@freebsd.org>; Mon, 23 Oct 2006 23:47:37 +0000 (UTC)
	(envelope-from mikej@rogers.com)
Received: from smtp106.rog.mail.re2.yahoo.com (smtp106.rog.mail.re2.yahoo.com
	[68.142.225.204])
	by mx1.FreeBSD.org (Postfix) with SMTP id 51BB043D49
	for <stable@freebsd.org>; Mon, 23 Oct 2006 23:47:37 +0000 (GMT)
	(envelope-from mikej@rogers.com)
Received: (qmail 20723 invoked from network); 23 Oct 2006 23:47:36 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=rogers.com;
	h=Received:Message-ID:Date:From:User-Agent:MIME-Version:To:CC:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding;
	b=ua5vVJSO+zk6CJv3/cLllPYFHg0J9YgkiRc5SqLvk5Wu75M9BPAHUVT1xB/3/rGnNq/6M0wibAgNzpSidZFjnUtKSmNsBzmKLhFoRizCxncnDhTCZU66u+VXH3Ah9/xUYrqFrM40W0G1VmrYGeBeawyZgea13tDdsxJ2nd9wgUg=
	; 
Received: from unknown (HELO ?172.16.0.200?) (mikej@rogers.com@74.111.253.239
	with plain)
	by smtp106.rog.mail.re2.yahoo.com with SMTP; 23 Oct 2006 23:47:36 -0000
Message-ID: <453D54A7.4080303@rogers.com>
Date: Mon, 23 Oct 2006 19:47:51 -0400
From: Mike Jakubik <mikej@rogers.com>
User-Agent: Thunderbird 1.5.0.7 (Windows/20060909)
MIME-Version: 1.0
To: Ronald Klop <ronald-freebsd8@klop.yi.org>
References: <453D49D2.1010705@rogers.com> <op.thwehzrs8527sy@guido.klop.ws>
In-Reply-To: <op.thwehzrs8527sy@guido.klop.ws>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
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 <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: Mon, 23 Oct 2006 23:47:38 -0000

Ronald Klop wrote:
> I'm running MySQL 5 on Linux at my work (4 disk RAID 10/32G 
> RAM/4xsingle-core). It has a DB of > 100 GB and much more than 
> millions of rows and the preformance is very good with quite a lot of 
> users via the webserver. But I do not have any comparisons with Oracle 
> or other systems. Unforunately we don't run FreeBSD at work except for 
> my workstation.
>

Well, i guess i can always fall back on Linux if there are any major 
problems on FreeBSD.

> The size of the db is not the problem. The load is more important. Are 
> there a lot of sequential queries or simultanious? Do you do a lot of 
> locking/selects/updates/insert? Are there thousands of tables or just 1?
> I do recommend a 64 bit OS if your hardware supports it, because it 
> makes allocating memory for MySQL a lot easier.

Thats the information i do not have yet. My guess is mostly selects and 
possibly more than one table. I also believe they will make use of 
stored procedures. I will have to use AMD64 anyways, as it will be using 
16GB of ram.