From owner-freebsd-questions@FreeBSD.ORG  Sun Aug 26 22:10:53 2007
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id B7DA616A46B
	for <freebsd-questions@freebsd.org>;
	Sun, 26 Aug 2007 22:10:53 +0000 (UTC)
	(envelope-from cyberleo@cyberleo.net)
Received: from pizzabox.cyberleo.net (alpha.cyberleo.net [198.145.45.10])
	by mx1.freebsd.org (Postfix) with ESMTP id 848B313C483
	for <freebsd-questions@freebsd.org>;
	Sun, 26 Aug 2007 22:10:53 +0000 (UTC)
	(envelope-from cyberleo@cyberleo.net)
Received: (qmail 93104 invoked from network); 26 Aug 2007 22:10:52 -0000
Received: from adsl-75-3-87-131.dsl.chcgil.sbcglobal.net (HELO ?172.16.44.14?)
	(cyberleo@cyberleo.net@75.3.87.131)
	by alpha.cyberleo.net with ESMTPA; 26 Aug 2007 22:10:52 -0000
Message-ID: <46D1FA62.3070405@cyberleo.net>
Date: Sun, 26 Aug 2007 17:10:42 -0500
From: CyberLeo Kitsana <cyberleo@cyberleo.net>
User-Agent: Thunderbird 2.0.0.6 (X11/20070819)
MIME-Version: 1.0
To: Jim Pazarena <fquest@ccstores.com>
References: <46D1AD3F.1020308@ccstores.com>
In-Reply-To: <46D1AD3F.1020308@ccstores.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Cc: FreeBSD Questions <freebsd-questions@freebsd.org>
Subject: Re: filesystem types
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sun, 26 Aug 2007 22:10:53 -0000

Jim Pazarena wrote:
> I installed an amd 64 bit 6.2 freebsd with the default filesystem (on 3
> drives)
> and my MySQL seems to have a 4Gb limit. Is there another filesystem I
> can select
> which bypasses this limit?
> 
> Where can I read about available filesystems on FreeBSD?

http://jeremy.zawodny.com/blog/archives/000796.html

The above blog entry indicates that MyISAM tables on x86 platforms have
a limit of 4GB or around 4.2 billion rows, depending on create options,
due to a limitation in MyISAM's index algorithms.

It does say that the limit is raised on 64-bit platforms, so are you
sure you compiled MySQL for amd64?

The InnoDB storage engine does not have this limitation.

-- 
Fuzzy love,
-CyberLeo
Technical Administrator
CyberLeo.Net Webhosting
http://www.CyberLeo.Net
<CyberLeo@CyberLeo.Net>

Furry Peace! - http://wwww.fur.com/peace/