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