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
> 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.
2Gb files is only a limit on 32bit Linux hardware. Linux on
Alpha/UltraSparc has 64bit file offsets (with a 17TB file size limit).