MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:jon Date:December 1 2007 11:08am
Subject:svn commit - mysqldoc@docsrva: r9046 - in trunk: refman-4.1 refman-5.0 refman-5.1 refman-6.0
View as plain text  
Author: jstephens
Date: 2007-12-01 12:08:42 +0100 (Sat, 01 Dec 2007)
New Revision: 9046

Log:

What "no distributed table locks" means

Fixes Docs Bug #32706



Modified:
   trunk/refman-4.1/mysql-cluster-limitations.xml
   trunk/refman-5.0/mysql-cluster-limitations.xml
   trunk/refman-5.1/mysql-cluster-limitations.xml
   trunk/refman-6.0/mysql-cluster-limitations.xml


Modified: trunk/refman-4.1/mysql-cluster-limitations.xml
===================================================================
--- trunk/refman-4.1/mysql-cluster-limitations.xml	2007-12-01 10:57:14 UTC (rev 9045)
+++ trunk/refman-4.1/mysql-cluster-limitations.xml	2007-12-01 11:08:42 UTC (rev 9046)
Changed blocks: 1, Lines Added: 20, Lines Deleted: 2; 1432 bytes

@@ -1269,12 +1269,30 @@
           <listitem>
             <formalpara>
 
+              <title>No distributed table locks</title>
+
+              <para>
+                A <literal>LOCK TABLES</literal> works only for the SQL
+                node on which the lock is issued; no other SQL node in
+                the cluster <quote>sees</quote> this lock. This is also
+                true for a lock issued by any statement that locks
+                tables as part of its operations. (See next item for an
+                example.)
+              </para>
+
+            </formalpara>
+          </listitem>
+
+          <listitem>
+            <formalpara>
+
               <title><literal>ALTER TABLE</literal> operations</title>
 
               <para>
                 <literal>ALTER TABLE</literal> is not fully locking when
-                running multiple MySQL servers (no distributed table
-                lock).
+                running multiple MySQL servers (SQL nodes). (As
+                discussed in the previous item, MySQL Cluster does not
+                support distributed table locks.)
               </para>
 
             </formalpara>


Modified: trunk/refman-5.0/mysql-cluster-limitations.xml
===================================================================
--- trunk/refman-5.0/mysql-cluster-limitations.xml	2007-12-01 10:57:14 UTC (rev 9045)
+++ trunk/refman-5.0/mysql-cluster-limitations.xml	2007-12-01 11:08:42 UTC (rev 9046)
Changed blocks: 1, Lines Added: 20, Lines Deleted: 2; 1432 bytes

@@ -1187,12 +1187,30 @@
           <listitem>
             <formalpara>
 
+              <title>No distributed table locks</title>
+
+              <para>
+                A <literal>LOCK TABLES</literal> works only for the SQL
+                node on which the lock is issued; no other SQL node in
+                the cluster <quote>sees</quote> this lock. This is also
+                true for a lock issued by any statement that locks
+                tables as part of its operations. (See next item for an
+                example.)
+              </para>
+
+            </formalpara>
+          </listitem>
+
+          <listitem>
+            <formalpara>
+
               <title><literal>ALTER TABLE</literal> operations</title>
 
               <para>
                 <literal>ALTER TABLE</literal> is not fully locking when
-                running multiple MySQL servers (no distributed table
-                lock).
+                running multiple MySQL servers (SQL nodes). (As
+                discussed in the previous item, MySQL Cluster does not
+                support distributed table locks.)
               </para>
 
             </formalpara>


Modified: trunk/refman-5.1/mysql-cluster-limitations.xml
===================================================================
--- trunk/refman-5.1/mysql-cluster-limitations.xml	2007-12-01 10:57:14 UTC (rev 9045)
+++ trunk/refman-5.1/mysql-cluster-limitations.xml	2007-12-01 11:08:42 UTC (rev 9046)
Changed blocks: 1, Lines Added: 20, Lines Deleted: 2; 1432 bytes

@@ -1380,12 +1380,30 @@
           <listitem>
             <formalpara>
 
+              <title>No distributed table locks</title>
+
+              <para>
+                A <literal>LOCK TABLES</literal> works only for the SQL
+                node on which the lock is issued; no other SQL node in
+                the cluster <quote>sees</quote> this lock. This is also
+                true for a lock issued by any statement that locks
+                tables as part of its operations. (See next item for an
+                example.)
+              </para>
+
+            </formalpara>
+          </listitem>
+
+          <listitem>
+            <formalpara>
+
               <title><literal>ALTER TABLE</literal> operations</title>
 
               <para>
                 <literal>ALTER TABLE</literal> is not fully locking when
-                running multiple MySQL servers (no distributed table
-                lock).
+                running multiple MySQL servers (SQL nodes). (As
+                discussed in the previous item, MySQL Cluster does not
+                support distributed table locks.)
               </para>
 
             </formalpara>


Modified: trunk/refman-6.0/mysql-cluster-limitations.xml
===================================================================
--- trunk/refman-6.0/mysql-cluster-limitations.xml	2007-12-01 10:57:14 UTC (rev 9045)
+++ trunk/refman-6.0/mysql-cluster-limitations.xml	2007-12-01 11:08:42 UTC (rev 9046)
Changed blocks: 1, Lines Added: 20, Lines Deleted: 2; 1432 bytes

@@ -1372,12 +1372,30 @@
           <listitem>
             <formalpara>
 
+              <title>No distributed table locks</title>
+
+              <para>
+                A <literal>LOCK TABLES</literal> works only for the SQL
+                node on which the lock is issued; no other SQL node in
+                the cluster <quote>sees</quote> this lock. This is also
+                true for a lock issued by any statement that locks
+                tables as part of its operations. (See next item for an
+                example.)
+              </para>
+
+            </formalpara>
+          </listitem>
+
+          <listitem>
+            <formalpara>
+
               <title><literal>ALTER TABLE</literal> operations</title>
 
               <para>
                 <literal>ALTER TABLE</literal> is not fully locking when
-                running multiple MySQL servers (no distributed table
-                lock).
+                running multiple MySQL servers (SQL nodes). (As
+                discussed in the previous item, MySQL Cluster does not
+                support distributed table locks.)
               </para>
 
             </formalpara>


Thread
svn commit - mysqldoc@docsrva: r9046 - in trunk: refman-4.1 refman-5.0 refman-5.1 refman-6.0jon1 Dec