Author: jstephens
Date: 2006-06-19 16:55:25 +0200 (Mon, 19 Jun 2006)
New Revision: 2418
Log:
mysqldump --single-transaction doesnt work for Cluster tables. (Hartmut/Tomas)
Modified:
trunk/refman-4.1/client-utility-programs.xml
trunk/refman-5.0/client-utility-programs.xml
trunk/refman-5.1/client-utility-programs.xml
Modified: trunk/refman-4.1/client-utility-programs.xml
===================================================================
--- trunk/refman-4.1/client-utility-programs.xml 2006-06-19 14:34:41 UTC (rev 2417)
+++ trunk/refman-4.1/client-utility-programs.xml 2006-06-19 14:55:25 UTC (rev 2418)
@@ -10502,6 +10502,15 @@
<literal>LOCK TABLES</literal> causes any pending
transactions to be committed implicitly.
</para>
+
+ <para>
+ This option is not supported for MySQL Cluster tables;
+ the results cannot be guaranteed to be consistent due to
+ the fact that the <literal>NDBCluster</literal> storage
+ engine supports only the <literal>READ_COMMITTED</literal>
+ transaction isolation level. You should always use
+ <literal>NDB</literal> backup and restore instead.
+ </para>
<para>
To dump big tables, you should combine this option with
Modified: trunk/refman-5.0/client-utility-programs.xml
===================================================================
--- trunk/refman-5.0/client-utility-programs.xml 2006-06-19 14:34:41 UTC (rev 2417)
+++ trunk/refman-5.0/client-utility-programs.xml 2006-06-19 14:55:25 UTC (rev 2418)
@@ -10660,6 +10660,15 @@
exclusive, because <literal>LOCK TABLES</literal> causes
any pending transactions to be committed implicitly.
</para>
+
+ <para>
+ This option is not supported for MySQL Cluster tables;
+ the results cannot be guaranteed to be consistent due to
+ the fact that the <literal>NDBCluster</literal> storage
+ engine supports only the <literal>READ_COMMITTED</literal>
+ transaction isolation level. You should always use
+ <literal>NDB</literal> backup and restore instead.
+ </para>
<para>
To dump big tables, you should combine this option with
Modified: trunk/refman-5.1/client-utility-programs.xml
===================================================================
--- trunk/refman-5.1/client-utility-programs.xml 2006-06-19 14:34:41 UTC (rev 2417)
+++ trunk/refman-5.1/client-utility-programs.xml 2006-06-19 14:55:25 UTC (rev 2418)
@@ -10826,6 +10826,15 @@
tables dumped while using this option may still change
state.
</para>
+
+ <para>
+ This option is not supported for MySQL Cluster tables;
+ the results cannot be guaranteed to be consistent due to
+ the fact that the <literal>NDBCluster</literal> storage
+ engine supports only the <literal>READ_COMMITTED</literal>
+ transaction isolation level. You should always use
+ <literal>NDB</literal> backup and restore instead.
+ </para>
<para>
The <option>--single-transaction</option> option and the
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r2418 - in trunk: refman-4.1 refman-5.0 refman-5.1 | jon | 19 Jun |
