List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:December 12 2001 11:31pm
Subject:Re: 4 G table limit?
View as plain text  
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
4 G table limit?Tim Wood13 Dec
  • Re: 4 G table limit?Dan Nelson13 Dec
    • Re: 4 G table limit?Tim Wood13 Dec
  • RE: 4 G table limit?Matthew Smith13 Dec