svn commit - mysqldoc@docsrva: r5446 - trunk/refman-5.1

[jon]

Author: jstephens
Date: 2007-03-19 10:14:27 +0100 (Mon, 19 Mar 2007)
New Revision: 5446

Log:

Testing reveals that INITIAL_SIZE clause is optional for CREATE | ALTER 
TABLESPACE | LOGFILE GROUP and defaults to 128M in all cases.

(Thanks to Roland for pointing me in this direction.)



Modified:
   trunk/refman-5.1/sql-syntax.xml


Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml	2007-03-19 08:00:31 UTC (rev 5445)
+++ trunk/refman-5.1/sql-syntax.xml	2007-03-19 09:14:27 UTC (rev 5446)
Changed blocks: 8, Lines Added: 25, Lines Deleted: 22; 5491 bytes

@@ -1362,7 +1362,7 @@
 <programlisting>
 ALTER LOGFILE GROUP <replaceable>logfile_group</replaceable>
     ADD UNDOFILE '<replaceable>file</replaceable>'
-    INITIAL_SIZE [=] <replaceable>size</replaceable>
+    [INITIAL_SIZE [=] <replaceable>size</replaceable>]
     ENGINE [=] <replaceable>engine</replaceable>
 </programlisting>
 

@@ -1376,12 +1376,14 @@
       </para>
 
       <para>
-        The <literal>INITIAL_SIZE</literal> parameter sets the
-        <literal>UNDO</literal> file's initial size in bytes. You may
-        optionally follow <replaceable>size</replaceable> with a
-        one-letter abbreviation for an order of magnitude, similar to
-        those used in <filename>my.cnf</filename>. Generally, this is
-        one of the letters <literal>M</literal> (for megabytes) or
+        The optional <literal>INITIAL_SIZE</literal> parameter sets the
+        <literal>UNDO</literal> file's initial size in bytes; if not
+        specified, the initial size default to <literal>128M</literal>
+        (128 megabytes). You may optionally follow
+        <replaceable>size</replaceable> with a one-letter abbreviation
+        for an order of magnitude, similar to those used in
+        <filename>my.cnf</filename>. Generally, this is one of the
+        letters <literal>M</literal> (for megabytes) or
         <literal>G</literal> (for gigabytes).
       </para>
 

@@ -1456,7 +1458,7 @@
 <programlisting>
 ALTER TABLESPACE <replaceable>tablespace</replaceable>
     ADD DATAFILE '<replaceable>file</replaceable>'
-    INITIAL_SIZE [=] <replaceable>size</replaceable>
+    [INITIAL_SIZE [=] <replaceable>size</replaceable>]
     ENGINE [=] <replaceable>engine</replaceable>
 
 ALTER TABLESPACE <replaceable>tablespace</replaceable>

@@ -1470,10 +1472,11 @@
       </para>
 
       <para>
-        The <literal>ADD DATAFILE</literal> variant requires that you
+        The <literal>ADD DATAFILE</literal> variant allows you to
         specify an initial size using an <literal>INITIAL_SIZE</literal>
         clause, where <replaceable>size</replaceable> is measured in
-        bytes. You may optionally follow an integer value with a
+        bytes; the default value is <literal>128M</literal> (128
+        megabytes). You may optionally follow this integer value with a
         one-letter abbreviation for an order of magnitude, similar to
         those used in <filename>my.cnf</filename>. Generally, this is
         one of the letters <literal>M</literal> (for megabytes) or

@@ -1489,7 +1492,7 @@
 
       <para>
         Using <literal>DROP DATAFILE</literal> with <literal>ALTER
-        TABLESPACE</literal> drops a data file
+        TABLESPACE</literal> drops the data file
         '<replaceable>file</replaceable>' from the tablespace. This file
         must already have been added to the tablespace using
         <literal>CREATE TABLESPACE</literal> or <literal>ALTER

@@ -4131,7 +4134,7 @@
 <programlisting>
 CREATE LOGFILE GROUP <replaceable>logfile_group</replaceable>
     ADD UNDOFILE '<replaceable>undo_file</replaceable>'
-    INITIAL_SIZE [=] <replaceable>initial_size</replaceable>
+    [INITIAL_SIZE [=] <replaceable>initial_size</replaceable>]
     [UNDO_BUFFER_SIZE [=] <replaceable>undo_buffer_size</replaceable>]
     ENGINE [=] <replaceable>engine_name</replaceable>
 </programlisting>

@@ -4151,19 +4154,19 @@
       </para>
 
       <para>
-        The <literal>INITIAL_SIZE</literal> parameter sets the
-        <literal>UNDO</literal> file's initial size. The optional
+        The optional <literal>INITIAL_SIZE</literal> parameter sets the
+        <literal>UNDO</literal> file's initial size; if not specified,
+        it defaults to <literal>128M</literal> (128 megabytes). The optional
         <literal>UNDO_BUFFFER_SIZE</literal> parameter sets the size
         used by the <literal>UNDO</literal> buffer for the log file
         group; The default value for <literal>UNDO_BUFFER_SIZE</literal>
         is <literal>8M</literal> (eight megabytes); this value cannot
-        exceed the amount of system memory avilable. Both
-        <replaceable>initial_size</replaceable> and
-        <replaceable>undo_buffer_size</replaceable> are specified in
-        bytes. You may optionally follow either or both of these with a
-        one-letter abbreviation for an order of magnitude, similar to
-        those used in <filename>my.cnf</filename>. Generally, this
-        is one of the letters <literal>M</literal> (for megabytes) or
+        exceed the amount of system memory available. Both
+        of these parameters are specified in bytes. You may optionally
+        follow either or both of these with a one-letter abbreviation
+        for an order of magnitude, similar to those used in
+        <filename>my.cnf</filename>. Generally, this is one of the
+        letters <literal>M</literal> (for megabytes) or
         <literal>G</literal> (for gigabytes).
       </para>
 

@@ -4177,7 +4180,7 @@
       </para>
 
       <para>
-        When used with <literal>ENGINE = NDB</literal>, a log file group
+        When used with <literal>ENGINE [=] NDB</literal>, a log file group
         and associated <literal>UNDO</literal> log file are created on
         each Cluster data node. You can verify that the
         <literal>UNDO</literal> files were created and obtain