svn commit - mysqldoc@docsrva: r9234 - in trunk: . refman-6.0

[paul]

Author: paul
Date: 2007-12-10 19:34:26 +0100 (Mon, 10 Dec 2007)
New Revision: 9234

Log:
 r34132@arctic:  paul | 2007-12-10 12:33:41 -0600
 Update lock tables notes.


Modified:
   trunk/refman-6.0/lock-tables-tmp.xml

Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:34128
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:27855
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:22582
   + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:34132
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:27855
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:22582


Modified: trunk/refman-6.0/lock-tables-tmp.xml
===================================================================
--- trunk/refman-6.0/lock-tables-tmp.xml	2007-12-10 18:25:21 UTC (rev 9233)
+++ trunk/refman-6.0/lock-tables-tmp.xml	2007-12-10 18:34:26 UTC (rev 9234)
Changed blocks: 5, Lines Added: 60, Lines Deleted: 1; 3095 bytes

@@ -48,6 +48,50 @@
   </para>
 
   <para>
+    [List types of locks here]
+  </para>
+
+  <itemizedlist>
+
+    <listitem>
+      <para>
+        <literal>READ [LOCAL]</literal>: Lock a table for reading. A
+        <literal>READ</literal> lock for a table can be acquired by
+        multiple clients simultaneously. The lock is non-transactional
+        and interacts with transactions as described later.
+      </para>
+    </listitem>
+
+    <listitem>
+      <para>
+        <literal>[LOW_PRIORITY] WRITE</literal>: Lock a table for write.
+        A <literal>WRITE</literal> lock for a table can be acquired by
+        only one client at a time. The lock is non-transactional and
+        interacts with transactions as described later.
+      </para>
+    </listitem>
+
+    <listitem>
+      <para>
+        <literal>IN SHARE MODE [NOWAIT]</literal>: Lock a table for
+        shared access. An <literal>IN SHARE MODE</literal> lock for a
+        table can be acquired by multiple clients simultaneously. The
+        lock is transactional.
+      </para>
+    </listitem>
+
+    <listitem>
+      <para>
+        <literal>IN EXCLUSIVE MODE [NOWAIT]</literal>: Lock a table for
+        exclusiv access (typically for writing. An <literal>IN EXCLUSIVE
+        MODE</literal> lock for a table can be acquired by only one
+        client at a time. The lock is transactional.
+      </para>
+    </listitem>
+
+  </itemizedlist>
+
+  <para>
     <literal>UNLOCK TABLES</literal> explicitly releases any table locks
     held by the current thread. Another use for <literal>UNLOCK
     TABLES</literal> is to release the global read lock acquired with

@@ -76,7 +120,10 @@
       <para>
         If the <literal>LOCK TABLES</literal> statement must wait due to
         locks held by other threads on any of the tables, it blocks
-        until all locks can be acquired.
+        until all locks can be acquired, unless a waited-for lock was
+        requested with the <literal>NOWAIT</literal> option. If a
+        <literal>NOWAIT</literal> lock must be waited for, the statement
+        fails with an error.
       </para>
     </listitem>
 

@@ -85,6 +132,10 @@
         Table locks are released explicitly with <literal>UNLOCK
         TABLES</literal>.
       </para>
+
+      <para>
+        [NOW MORE COMPLICATED]
+      </para>
     </listitem>
 
     <listitem>

@@ -99,6 +150,10 @@
             <literal>LOCK TABLES</literal> releases any table locks
             currently held by the thread before acquiring new locks.
           </para>
+
+          <para>
+            [NOW MORE COMPLICATED]
+          </para>
         </listitem>
 
         <listitem>

@@ -330,6 +385,10 @@
         transaction, but only if any tables have been locked with
         <literal>LOCK TABLES</literal>.
       </para>
+
+      <para>
+        [Does it release xact locks?]
+      </para>
     </listitem>
 
     <listitem>