Author: jstephens
Date: 2008-07-25 08:45:43 +0200 (Fri, 25 Jul 2008)
New Revision: 11373
Log:
Clarification on INSERT DELAYED and replication slaves
(Thanks, JasonH!)
Modified:
trunk/refman-4.1/sql-syntax-data-manipulation.xml
trunk/refman-5.0/sql-syntax-data-manipulation.xml
trunk/refman-5.1/sql-syntax-data-manipulation.xml
trunk/refman-6.0/sql-syntax-data-manipulation.xml
Modified: trunk/refman-4.1/sql-syntax-data-manipulation.xml
===================================================================
--- trunk/refman-4.1/sql-syntax-data-manipulation.xml 2008-07-25 05:40:13 UTC (rev 11372)
+++ trunk/refman-4.1/sql-syntax-data-manipulation.xml 2008-07-25 06:45:43 UTC (rev 11373)
Changed blocks: 1, Lines Added: 4, Lines Deleted: 2; 841 bytes
@@ -1463,8 +1463,10 @@
<listitem>
<para>
<literal>DELAYED</literal> is ignored on slave replication
- servers because it could cause the slave to have different
- data than the master.
+ servers, so that <literal>INSERT DELAYED</literal> is
+ treated as a normal <literal>INSERT</literal> on slaves.
+ This is because <literal>DELAYED</literal> could cause the
+ slave to have different data than the master.
</para>
</listitem>
Modified: trunk/refman-5.0/sql-syntax-data-manipulation.xml
===================================================================
--- trunk/refman-5.0/sql-syntax-data-manipulation.xml 2008-07-25 05:40:13 UTC (rev 11372)
+++ trunk/refman-5.0/sql-syntax-data-manipulation.xml 2008-07-25 06:45:43 UTC (rev 11373)
Changed blocks: 1, Lines Added: 4, Lines Deleted: 2; 841 bytes
@@ -1412,8 +1412,10 @@
<listitem>
<para>
<literal>DELAYED</literal> is ignored on slave replication
- servers because it could cause the slave to have different
- data than the master.
+ servers, so that <literal>INSERT DELAYED</literal> is
+ treated as a normal <literal>INSERT</literal> on slaves.
+ This is because <literal>DELAYED</literal> could cause the
+ slave to have different data than the master.
</para>
</listitem>
Modified: trunk/refman-5.1/sql-syntax-data-manipulation.xml
===================================================================
--- trunk/refman-5.1/sql-syntax-data-manipulation.xml 2008-07-25 05:40:13 UTC (rev 11372)
+++ trunk/refman-5.1/sql-syntax-data-manipulation.xml 2008-07-25 06:45:43 UTC (rev 11373)
Changed blocks: 1, Lines Added: 4, Lines Deleted: 2; 841 bytes
@@ -1473,8 +1473,10 @@
<listitem>
<para>
<literal>DELAYED</literal> is ignored on slave replication
- servers because it could cause the slave to have different
- data than the master.
+ servers, so that <literal>INSERT DELAYED</literal> is
+ treated as a normal <literal>INSERT</literal> on slaves.
+ This is because <literal>DELAYED</literal> could cause the
+ slave to have different data than the master.
</para>
</listitem>
Modified: trunk/refman-6.0/sql-syntax-data-manipulation.xml
===================================================================
--- trunk/refman-6.0/sql-syntax-data-manipulation.xml 2008-07-25 05:40:13 UTC (rev 11372)
+++ trunk/refman-6.0/sql-syntax-data-manipulation.xml 2008-07-25 06:45:43 UTC (rev 11373)
Changed blocks: 1, Lines Added: 4, Lines Deleted: 2; 841 bytes
@@ -1471,8 +1471,10 @@
<listitem>
<para>
<literal>DELAYED</literal> is ignored on slave replication
- servers because it could cause the slave to have different
- data than the master.
+ servers, so that <literal>INSERT DELAYED</literal> is
+ treated as a normal <literal>INSERT</literal> on slaves.
+ This is because <literal>DELAYED</literal> could cause the
+ slave to have different data than the master.
</para>
</listitem>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r11373 - in trunk: refman-4.1 refman-5.0 refman-5.1 refman-6.0 | jon | 25 Jul |
