The document at
http://www.mysql.com/doc/T/a/Table_size.html
seems to suggest that the reason why there's a limit to the table size is
because of the number of bytes used by the file system to store offsets,
so its more or less file system dependant (pls correct me if i'm wrong).
It also wrote that on Linux 2.2, the maximum size of a table on ext2 is
2GB, which can be increased if using LFS.
I get the impression that the file containing the table data must reside
on LFS so that offsets > 2GB can be accessed.
Are you saying that we could compile the mysql package on a LFS partition,
bring it over to ext2 partition and tables could be > 2GB?
On 26 Jun 2001, Trond Eivind [iso-8859-1] Glomsrød wrote:
> Guðmundur Ólafsson <[EMAIL PROTECTED]> writes:
>
> > Hi,
> >
> > I have a Linux machine (Linux cartman 2.4.2-2smp #1 SMP Sun Apr 8
> > 20:21:34 EDT 2001 i686 unknown) that is running MySQL 3.23.38-log and
> > now I have a table that is getting VERY near to the ext2 filesystem
> > limitation of 2gb.
>
> Ext2 doesn't have a 2 GB limit. You seem to be running Red Hat Linux
> 7.1, and both kernel and C library support large files on this system.
>
> For more information, I recommend a look at
> http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html
> --
> Trond Eivind Glomsrød
> Red Hat, Inc.
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
