List:Commits« Previous MessageNext Message »
From:paul.dubois Date:June 20 2011 6:16pm
Subject:svn commit - mysqldoc@oter02: r26560 - in trunk: . refman-5.1
View as plain text  
Author: pd221994
Date: 2011-06-20 20:16:43 +0200 (Mon, 20 Jun 2011)
New Revision: 26560

Log:
 r49106@dhcp-adc-twvpn-1-vpnpool-10-154-3-183:  paul | 2011-06-20 13:12:51 -0500
 Move para, some rewording re: online alter table


Modified:
   svk:merge
   trunk/refman-5.1/sql-syntax-data-definition.xml

Property changes on: trunk
___________________________________________________________________

Modified: svk:merge
===================================================================


Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 1277 bytes


Modified: trunk/refman-5.1/sql-syntax-data-definition.xml
===================================================================
--- trunk/refman-5.1/sql-syntax-data-definition.xml	2011-06-20 18:16:35 UTC (rev 26559)
+++ trunk/refman-5.1/sql-syntax-data-definition.xml	2011-06-20 18:16:43 UTC (rev 26560)
Changed blocks: 3, Lines Added: 14, Lines Deleted: 12; 1986 bytes

@@ -843,13 +843,6 @@
       <xref linkend="alter-table-partition-operations"/>.
     </para>
 
-    <para>
-      Indexes on variable-width columns of
-      <literal role="se">NDBCLUSTER</literal> tables can be added and
-      dropped without any table copying. For more information, see
-      <xref linkend="alter-table-online-operations"/>.
-    </para>
-
     <remark role="help-description-end"/>
 
     <para>

@@ -1012,6 +1005,14 @@
       to <literal>ON</literal>.
     </para>
 
+    <para>
+      Operations that add and drop indexes on variable-width columns of
+      <literal role="se">NDBCLUSTER</literal> tables occur online,
+      without any table copying and without blocking concurrent DML
+      actions for most of their duration. For more information, see
+      <xref linkend="alter-table-online-operations"/>.
+    </para>
+
     <itemizedlist>
 
       <listitem>

@@ -2182,13 +2183,14 @@
 
     <section id="alter-table-online-operations">
 
-      <title><literal role="stmt">ALTER TABLE</literal> <literal>ONLINE</literal> and
-        <literal>OFFLINE</literal> Operations</title>
+      <title><literal role="stmt">ALTER TABLE</literal> Online Operations</title>
 
       <para>
-        Beginning with MySQL 5.1.17, indexes on variable-width columns
-        of <literal role="se">NDBCLUSTER</literal> tables are added and
-        dropped online, without any table copying.
+        Beginning with MySQL 5.1.17, operations that add and drop
+        indexes on variable-width columns of
+        <literal role="se">NDBCLUSTER</literal> tables occur online,
+        without any table copying and without blocking concurrent DML
+        actions for most of their duration.
       </para>
 
       <para>


Thread
svn commit - mysqldoc@oter02: r26560 - in trunk: . refman-5.1paul.dubois20 Jun