MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:paul Date:December 21 2007 4:26pm
Subject:svn commit - mysqldoc@docsrva: r9435 - in trunk: . refman-6.0
View as plain text  
Author: paul
Date: 2007-12-21 17:26:40 +0100 (Fri, 21 Dec 2007)
New Revision: 9435

 r28364@frost:  paul | 2007-12-21 10:20:29 -0600
 Update locking notes.


Property changes on: trunk
Name: svk:merge
   - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:34416
   + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:34416

Modified: trunk/refman-6.0/lock-tables-tmp.xml
--- trunk/refman-6.0/lock-tables-tmp.xml	2007-12-21 16:26:27 UTC (rev 9434)
+++ trunk/refman-6.0/lock-tables-tmp.xml	2007-12-21 16:26:40 UTC (rev 9435)
Changed blocks: 3, Lines Added: 18, Lines Deleted: 1; 1736 bytes

@@ -45,7 +45,8 @@
     It's not true that you cannot access any non-locked table while you
     hold locks: You can access TEMPORARY tables. LOCK TABLES appears to
     lock TEMPORARY tables, but should you even bother, given the
-    preceding sentence? ]
+    preceding sentence? How do transactional lock requests and requests
+    to enable read_only interact? ]
   <remark role="help-description-begin"/>

@@ -145,6 +146,15 @@
+    [VERIFY] Transactional locks can be acquired only while autocommit
+    is disabled. If autocommit is enabled, requests are converted to
+    READ/WRITE requests, or an error occurs if strict SQL mode is
+    enabled (strict mode prevents request conversion). [If conversion
+    occurs, is NOWAIT ignored if present, given that it doesn't apply to
+  </para>
+  <para>
     The following general rules apply to acquisition and release of
     locks by a given thread:

@@ -269,6 +279,13 @@
   <remark role="help-description-end"/>
+    [ You can lock multiple tables at the same time. You can lock a
+    table multiple times, as long as you refer to it by a different name
+    for each lock. Each locked name can be referred to a single time in
+    a statement.
+  </para>
+  <para>
     When you use <literal>LOCK TABLES</literal>, you must lock all
     tables that you are going to use in your statements. While the locks
     obtained with a <literal>LOCK TABLES</literal> statement are in

svn commit - mysqldoc@docsrva: r9435 - in trunk: . refman-6.0paul21 Dec