svn commit - mysqldoc@oter02: r26476 - in trunk: . refman-5.1

[paul.dubois]

Author: pd221994
Date: 2011-06-09 19:16:08 +0200 (Thu, 09 Jun 2011)
New Revision: 26476

Log:
 r48787@dhcp-adc-twvpn-1-vpnpool-10-154-24-148:  paul | 2011-06-09 11:12:38 -0500
 Tie online add/drop index to NDB


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-09 17:15:57 UTC (rev 26475)
+++ trunk/refman-5.1/sql-syntax-data-definition.xml	2011-06-09 17:16:08 UTC (rev 26476)
Changed blocks: 3, Lines Added: 12, Lines Deleted: 11; 2563 bytes

@@ -2168,9 +2168,10 @@
         <literal>OFFLINE</literal> Operations</title>
 
       <para>
-        Beginning with MySQL 5.1.7, <literal>ADD INDEX</literal> and
-        <literal>DROP INDEX</literal> operations are performed online
-        when the indexes are on variable-width columns only.
+        Beginning with MySQL 5.1.17, indexes on variable-width columns
+        of <literal role="se">NDBCLUSTER</literal> tables are added and
+        dropped online; that is, adding and dropping the indexes does
+        not require any copying of the table.
       </para>
 
       <para>

@@ -3957,10 +3958,10 @@
     </note>
 
     <para>
-      Beginning with MySQL 5.1.7, indexes on variable-width columns are
-      created online; that is, creating the indexes does not require any
-      copying of the table. For <literal role="se">NDBCLUSTER</literal>
-      tables, the table is not locked against access from other MySQL
+      Beginning with MySQL 5.1.17, indexes on variable-width columns of
+      <literal role="se">NDBCLUSTER</literal> tables are created online;
+      that is, creating the indexes does not require any copying of the
+      table. The table is not locked against access from other MySQL
       Cluster API nodes, although it is locked against other operations
       on the <emphasis>same</emphasis> API node for the duration of the
       online operation. This is done automatically by the server

@@ -9639,10 +9640,10 @@
     <remark role="help-description-end"/>
 
     <para>
-      Beginning with MySQL 5.1.7, indexes on variable-width columns are
-      dropped online; that is, dropping the indexes does not require any
-      copying of the table. For <literal role="se">NDBCLUSTER</literal>
-      tables, the table is not locked against access from other MySQL
+      Beginning with MySQL 5.1.17, indexes on variable-width columns of
+      <literal role="se">NDBCLUSTER</literal> tables are dropped online;
+      that is, dropping the indexes does not require any copying of the
+      table. The table is not locked against access from other MySQL
       Cluster API nodes, although it is locked against other operations
       on the <emphasis>same</emphasis> API node for the duration of the
       online operation. This is done automatically by the server