From: Dan Nelson
Date: December 12 2001 11:31pm
Subject: Re: 4 G table limit?
List-Archive: http://lists.mysql.com/mysql/93828
Message-Id: <20011212233119.GC56211@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Dec 13), Tim Wood said:
> As mentioned above, I'm a lazy unit, so if possible would like to
> avoid restructuring the DB to spread the document body table across
> >1 table (thus enabling > 4 G of doc bodies), so am looking for some
> easier way to do it (eg upgrading mysql, or using a different fs type
> etc).
> 
> Does anyone out there know of any 
> - future plans by the mysql development crew to increase table size
> limits by eg using their own custom filesystem type?

You mean the MyISAM RAID table extension, or the Innodb tablespace
format?  Done.  Check the manual for details.

> - any kernel fs patches I might apply to get around the 4G limit imposed
> by the linux kernel
> - any alternative filesystems (JFS?) that might permit greater table
> sizes under mysql

2.4.2 should support 64-bit files just fine.

-- 
	Dan Nelson
	dnelson@stripped