List:General Discussion« Previous MessageNext Message »
From:Dax Kelson Date:March 30 1999 5: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

Thread
table sizeBrett Error16 Mar
  • table sizesinisa17 Mar
    • Re: table sizeDax Kelson30 Mar
      • Re: table sizeRoman D. Sinyuk31 Mar