List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:August 15 2001 6:30pm
Subject:Re: Table size limitations...
View as plain text  
In the last episode (Aug 15), Nathanial Hendler said:
> I have a table that holds a lot of information.  I tried to INSERT
> something into it, and received...
> 
> DBD::mysql::st execute failed: The table 'fancy_big_table' is full at 
> ./tom_to_mutt.pl line 156.
> 
> The table is 4G is size.  The table's Max_data_length = 4294967295 (4G)
> 
> I'm running the MySQL server on a FreeBSD system, and this is not a
> file system limitation.  I am using MyISAM tables.

I wonder if there is still a 4gb limit on dynamic MYISAM tables?  Is
there a 4-byte offset used as the pointer in indexes for this table
type?  I checked some of my databases and all the dynamic tables have
4294967295 as their max length, where the fixed tables vary; one has
115964116991.

The docs do mention MAX_ROWS and AVG_ROW_LENGTH together; maybe you
need to specify both of them for mysql to bump your table limits above
4gb.

If that doesn't work, and you can spare the wasted space, try
converting your table to fixed-length rows (convert all varchars to
chars).


-- 
	Dan Nelson
	dnelson@stripped
Thread
NuSphere final speaks outDavid Price15 Aug
  • Table size limitations...Nathanial Hendler15 Aug
    • RE: Table size limitations...Trevor Linton15 Aug
      • enable log and updatel logShu Xiao15 Aug
    • Re: Table size limitations...Dan Nelson15 Aug
      • Re: Table size limitations...Nathanial Hendler15 Aug
  • Re: NuSphere final speaks outMichael T. Babcock15 Aug
    • RE: NuSphere final speaks outPhilippe Paravicini15 Aug
      • Re: NuSphere final speaks outMichael T. Babcock15 Aug
      • RE: NuSphere final speaks outPhilippe Paravicini15 Aug
        • How does MySQL generate it's web based documentationDavid Herring16 Aug
          • Re: How does MySQL generate it's web based documentationJeremy Zawodny17 Aug
        • MySQL.org's positionMichael Widenius16 Aug
        • RE: NuSphere final speaks outTonu Samuel17 Aug
          • naming feildsGlyndower17 Aug
            • Re: naming feildsWerner Stuerenburg17 Aug
      • RE: NuSphere final speaks outCarsten H. Pedersen16 Aug
    • Re: NuSphere final [sic] speaks outC. Bond15 Aug
      • Re: NuSphere final [sic] speaks outMichael Bacarella16 Aug
    • Re: NuSphere final speaks outJeremy Zawodny16 Aug
  • Re: Table size limitations...ryc15 Aug
  • Re: NuSphere final [sic] speaks outryc16 Aug
Re: NuSphere final speaks outMarten Mickos17 Aug
  • Re: NuSphere final speaks outMike Wexler17 Aug
  • RE: NuSphere final speaks outDavid Price17 Aug