Yee Chuan Loh <[EMAIL PROTECTED]> writes:
> 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).
You are - it's the bits used by kernel (through glibc) which are the
important ones, ext2 doesn't have problems in that area.
> 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.
But you're running 2.4.2-2 (which looks like Red Hat Linux 7.1, which
also has a LFS-enabled glibc).
> Are you saying that we could compile the mysql package on a LFS
> partition,
No, on a LFS-capable system. LFS is not a special property of the ext2
partition (if you're using ReiserFS, it's a little different - v2
doesn't support large files, v3 does).
>
--
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
