Author: paul
Date: 2007-01-10 22:00:24 +0100 (Wed, 10 Jan 2007)
New Revision: 4443
Log:
r17918@polar: paul | 2007-01-10 14:57:22 -0600
LOW_PRIORITY WRITE locks are like regular WRITE locks for
InnoDB if autocommit it disabled. (Per Ingo)
Modified:
trunk/refman-4.1/sql-syntax.xml
trunk/refman-5.0/sql-syntax.xml
trunk/refman-5.1/sql-syntax.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:17917
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:14371
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:13015
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:17918
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:14371
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:13015
Modified: trunk/refman-4.1/sql-syntax.xml
===================================================================
--- trunk/refman-4.1/sql-syntax.xml 2007-01-10 21:00:04 UTC (rev 4442)
+++ trunk/refman-4.1/sql-syntax.xml 2007-01-10 21:00:24 UTC (rev 4443)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 1; 894 bytes
@@ -10636,7 +10636,11 @@
while the thread is waiting for the <literal>WRITE</literal>
lock. You should use <literal>LOW_PRIORITY WRITE</literal> locks
only if you are sure that eventually there will be a time when
- no threads have a <literal>READ</literal> lock.
+ no threads have a <literal>READ</literal> lock. (Exception: For
+ <literal>InnoDB</literal> tables in transactional mode
+ (autocommit = 0), a <literal>LOW_PRIORITY WRITE</literal> lock
+ acts like a regular <literal>WRITE</literal> lock and precedes
+ waiting <literal>READ</literal> locks.)
</para>
<para>
Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml 2007-01-10 21:00:04 UTC (rev 4442)
+++ trunk/refman-5.0/sql-syntax.xml 2007-01-10 21:00:24 UTC (rev 4443)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 1; 894 bytes
@@ -11380,7 +11380,11 @@
while the thread is waiting for the <literal>WRITE</literal>
lock. You should use <literal>LOW_PRIORITY WRITE</literal> locks
only if you are sure that eventually there will be a time when
- no threads have a <literal>READ</literal> lock.
+ no threads have a <literal>READ</literal> lock. (Exception: For
+ <literal>InnoDB</literal> tables in transactional mode
+ (autocommit = 0), a <literal>LOW_PRIORITY WRITE</literal> lock
+ acts like a regular <literal>WRITE</literal> lock and precedes
+ waiting <literal>READ</literal> locks.)
</para>
<para>
Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml 2007-01-10 21:00:04 UTC (rev 4442)
+++ trunk/refman-5.1/sql-syntax.xml 2007-01-10 21:00:24 UTC (rev 4443)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 1; 894 bytes
@@ -12715,7 +12715,11 @@
while the thread is waiting for the <literal>WRITE</literal>
lock. You should use <literal>LOW_PRIORITY WRITE</literal> locks
only if you are sure that eventually there will be a time when
- no threads have a <literal>READ</literal> lock.
+ no threads have a <literal>READ</literal> lock. (Exception: For
+ <literal>InnoDB</literal> tables in transactional mode
+ (autocommit = 0), a <literal>LOW_PRIORITY WRITE</literal> lock
+ acts like a regular <literal>WRITE</literal> lock and precedes
+ waiting <literal>READ</literal> locks.)
</para>
<para>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r4443 - in trunk: . refman-4.1 refman-5.0 refman-5.1 | paul | 10 Jan |
