List:General Discussion« Previous MessageNext Message »
From:Roman D. Sinyuk Date:March 30 1999 10:20pm
Subject:Re: table size
View as plain text  
> 
> 
> On Wed, 17 Mar 1999 sinisa@stripped wrote:
> 
> > Brett Error writes:
> >  > I have not been able to find this information in the manual.  How large
> of
> >  > tables can MySQL handle?  Linux puts the limit on file size at 2 GB (yes
> >  > there are work around for this, but I haven't seen any that aren't ugly
> >  > hacks).  Can MySQL work around this?  For example, PostgreSQL
> automatically
> >  > creates additional files when the table size nears 2GB.
> >  > 
> >  > Just curious if MySQL will take care of very large tables, or if I need
> to
> >  > make sure a table never exceeds the OS limit.
> >  > 
> >  > Thanks much!
> >  > 
> >  > Brett
> >  > 
> >  > 
> > 
> > Hi!
> > 
> > Yes, on Linux 2Gb is a present limit.
> > 
> > Future improvements  (3.23) will include workarounds, especielly with
> > Reiser FS, which is a replacement for ext2.
> > 
> > Sinisa
> 
> 2Gb files is only a limit on 32bit Linux hardware.  Linux on
> Alpha/UltraSparc has 64bit file offsets (with a 17TB file size limit).
> 
> Dax
> 
>
What is about FreeBSD? Does anybody have tables more than 2 Gb ?
Thread
table sizeBrett Error16 Mar
  • table sizesinisa17 Mar
    • Re: table sizeDax Kelson30 Mar
      • Re: table sizeRoman D. Sinyuk31 Mar