svn commit - mysqldoc@docsrva: r7949 - in trunk: refman-5.1 refman-5.2

[jon]

Author: jstephens
Date: 2007-10-03 10:06:08 +0200 (Wed, 03 Oct 2007)
New Revision: 7949

Log:

Clarification: for MyISAM and Falcon, only adding and dropping indexes
online is possible (but not online adding of columns).



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


Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml	2007-10-03 07:35:56 UTC (rev 7948)
+++ trunk/refman-5.1/sql-syntax.xml	2007-10-03 08:06:08 UTC (rev 7949)
Changed blocks: 1, Lines Added: 2, Lines Deleted: 2; 950 bytes

@@ -492,12 +492,12 @@
         <listitem>
           
           &mccge-warning-begin;
-          
           <para>
             The <literal>ONLINE</literal> keyword can be used to perform
             online <literal>ADD COLUMN</literal>, <literal>ADD
             INDEX</literal>, and <literal>DROP INDEX</literal>
-            operations on <literal>NDB</literal> and
+            operations on <literal>NDB</literal> tables. Online adding
+            and dropping of indexes is also supported for
             <literal>MyISAM</literal> tables. Online operations are
             non-copying; that is, they do not require that indexes be
             re-created. Such operations do not require single user mode


Modified: trunk/refman-5.2/sql-syntax.xml
===================================================================
--- trunk/refman-5.2/sql-syntax.xml	2007-10-03 07:35:56 UTC (rev 7948)
+++ trunk/refman-5.2/sql-syntax.xml	2007-10-03 08:06:08 UTC (rev 7949)
Changed blocks: 2, Lines Added: 18, Lines Deleted: 8; 2130 bytes

@@ -339,7 +339,7 @@
       <remark role="help-syntax"/>
 
 <programlisting>
-ALTER [ONLINE] [IGNORE] TABLE <replaceable>tbl_name</replaceable>
+ALTER [ONLINE | OFFLINE] [IGNORE] TABLE <replaceable>tbl_name</replaceable>
     <replaceable>alter_specification</replaceable> [,
<replaceable>alter_specification</replaceable>] ...
 
 <replaceable>alter_specification</replaceable>:

@@ -490,17 +490,27 @@
         </listitem>
 
         <listitem>
+          <remark role="TODO">
+            [js] Uncomment reference to Falcon when Falcon is merged
+            into mainline tree.
+          </remark>
+
           <para>
             The <literal>ONLINE</literal> keyword can be used to perform
             online <literal>ADD COLUMN</literal>, <literal>ADD
             INDEX</literal>, and <literal>DROP INDEX</literal>
-            operations on <literal>NDB</literal> and
-            <literal>MyISAM</literal> tables. Online operations are
-            non-copying; that is, they do not require that indexes be
-            re-created. Such operations do not require single user mode
-            for <literal>NDB</literal> table alterations made in a
-            cluster with multiple API nodes; transactions can continue
-            uninterrupted during online DDL operations.
+            operations on <literal>NDB</literal> tables. Online adding
+            and dropping of indexes is also supported for
+            <literal>MyISAM</literal>
+
+<!--and <literal>Falcon</literal>-->
+
+            tables. Online operations are non-copying; that is, they do
+            not require that indexes be re-created. Such operations do
+            not require single user mode for <literal>NDB</literal>
+            table alterations made in a cluster with multiple API nodes;
+            transactions can continue uninterrupted during online DDL
+            operations.
           </para>
 
           <formalpara>