From: Roman D. Sinyuk
Date: March 30 1999 10:20pm
Subject: Re: table size
List-Archive: http://lists.mysql.com/mysql/1208
Message-Id: <199903302220.BAA03853@titanic.uninet.kiev.ua>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

> 
> 
> 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 ?