Author: jstephens
Date: 2008-03-07 14:24:27 +0100 (Fri, 07 Mar 2008)
New Revision: 10154
Log:
Temporary tables and the binlog (Thanks, Sven!)
Modified:
trunk/refman-5.1/dba-core.xml
trunk/refman-6.0/dba-core.xml
Modified: trunk/refman-5.1/dba-core.xml
===================================================================
--- trunk/refman-5.1/dba-core.xml 2008-03-07 12:56:20 UTC (rev 10153)
+++ trunk/refman-5.1/dba-core.xml 2008-03-07 13:24:27 UTC (rev 10154)
Changed blocks: 1, Lines Added: 24, Lines Deleted: 0; 1362 bytes
@@ -13031,6 +13031,30 @@
<listitem>
<para>
+ If a statement is logged by row and the client that
+ executed the statement has any temporary tables, then
+ logging by row is used for all subsequent statements
+ (except for those accessing temporary tables) until all
+ temporary tables in use by that client are dropped
+ </para>
+
+ <para>
+ This is true whether or not any temporary tables are
+ actually logged
+ </para>
+
+ <para>
+ Temporary tables cannot be logged using the row-based
+ format; thus, once row-based logging is used, all
+ subsequent statements using that table are unsafe, and we
+ approximate this condition by treating all statements made
+ by that client as unsafe until the client no longer holds
+ any temporary tables
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
Beginning with MySQL 5.1.23:
<itemizedlist>
Modified: trunk/refman-6.0/dba-core.xml
===================================================================
--- trunk/refman-6.0/dba-core.xml 2008-03-07 12:56:20 UTC (rev 10153)
+++ trunk/refman-6.0/dba-core.xml 2008-03-07 13:24:27 UTC (rev 10154)
Changed blocks: 1, Lines Added: 24, Lines Deleted: 0; 1361 bytes
@@ -12816,6 +12816,30 @@
<listitem>
<para>
+ If a statement is logged by row and the client that
+ executed the statement has any temporary tables, then
+ logging by row is used for all subsequent statements
+ (except for those accessing temporary tables) until all
+ temporary tables in use by that client are dropped
+ </para>
+
+ <para>
+ This is true whether or not any temporary tables are
+ actually logged
+ </para>
+
+ <para>
+ Temporary tables cannot be logged using the row-based
+ format; thus, once row-based logging is used, all
+ subsequent statements using that table are unsafe, and we
+ approximate this condition by treating all statements made
+ by that client as unsafe until the client no longer holds
+ any temporary tables
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
Beginning with MySQL 6.0.4:
<itemizedlist>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r10154 - in trunk: refman-5.1 refman-6.0 | jon | 7 Mar |
