From: Dax Kelson Date: March 30 1999 5:20pm Subject: Re: table size List-Archive: http://lists.mysql.com/mysql/1193 Message-Id: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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