bk commit - mysqldoc tree (1.742)

[lenz]

Below is the list of changes that have just been committed into a local
mysqldoc repository of lenz. When lenz does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html

ChangeSet
  1.742 03/08/21 21:33:11 lenz@stripped +1 -0
   - Updated section about Large File Support on Linux a bit.

  Docs/manual.texi
    1.699 03/08/21 21:33:10 lenz@stripped +18 -10
     - Updated section about Large File Support on Linux a bit.

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	lenz
# Host:	kallisto.local
# Root:	/space/my/mysqldoc

--- 1.698/Docs/manual.texi	Thu Aug 21 18:48:29 2003
+++ 1.699/Docs/manual.texi	Thu Aug 21 21:33:10 2003
@@ -838,12 +838,15 @@
 @code{MyISAM} table type in @code{MySQL} Version 3.23, the maximum table
 size was pushed up to 8 million terabytes (2 ^ 63 bytes).
 
+In effect, then, the table size for @code{MySQL} databases is normally
+limited by the operating system.
+
 Note, however, that operating systems have their own file-size
 limits. Here are some examples:
 
 @multitable @columnfractions .30 .50
 @item @strong{Operating System} @tab @strong{File-Size Limit}
-@item Linux-Intel 32 bit        @tab 2 GB, 4GB or more, depends on Linux version
+@item Linux-Intel 32 bit        @tab 2 GB, much more when using LFS
 @item Linux-Alpha               @tab 8 TB (?)
 @item Solaris 2.5.1             @tab 2 GB (possible 4GB with patch)
 @item Solaris 2.6               @tab 4 GB (can be changed with flag)
@@ -851,22 +854,27 @@
 @item Solaris 2.7 UltraSPARC    @tab 512 GB
 @end multitable
 
-On Linux 2.2 you can get tables larger than 2 GB in size by using the LFS patch for
-the ext2 filesystem.  On Linux 2.4 patches also exist for ReiserFS
-to get support for big files.
+On Linux 2.2 you can get tables larger than 2 GB in size by using the LFS
+patch for the ext2 filesystem. On Linux 2.4 patches also exist for ReiserFS
+to get support for big files. Most current distributions are based on 
+kernel 2.4 and already include all the required Large File Support (LFS)
+patches. However, the maximum available file size still depends on several
+factors, one of them being the file system used to store MySQL tables.
 
-In effect, then, the table size for @code{MySQL} databases is normally
-limited by the operating system.
+For a very detailed overview about LFS in Linux, have a look at Andreas
+Jaeger's "Large File Support in Linux" page at
+@url{http://www.suse.de/~aj/linux_lfs.html}.
 
 By default, @code{MySQL} tables have a maximum size of about 4 GB.  You can
 check the maximum table size for a table with the @code{SHOW TABLE STATUS}
 command or with the @code{myisamchk -dv table_name}.
 @xref{SHOW}.
 
-If you need a table that will be larger than 4 GB in size (and your operating system supports
-this), set the @code{AVG_ROW_LENGTH} and @code{MAX_ROWS}
-parameters accordingly when you create your table.  @xref{CREATE TABLE}.  You can
-also set these parameters later, with @code{ALTER TABLE}. @xref{ALTER TABLE}.
+If you need a table that will be larger than 4 GB in size (and your
+operating system supports it), set the @code{AVG_ROW_LENGTH} and
+@code{MAX_ROWS} parameters accordingly when you create your table.
+@xref{CREATE TABLE}.  You can also set these parameters later, with
+@code{ALTER TABLE}. @xref{ALTER TABLE}.
 
 If your big table is a read-only table, you could use
 @code{myisampack} to merge and compress many tables into one.