Author: jstephens
Date: 2006-09-14 04:52:50 +0200 (Thu, 14 Sep 2006)
New Revision: 3348
Log:
Updated Cluster FAQ
- all versions: no temp tables
- 4.1: fixed typo
- 5.1:
- support for [LINEAR] KEY partitioning only
- removed item about charset/collation restrictions
Added note to "Problems with Temporary Tables" regarding Cluster
Modified:
trunk/refman-4.1/mysql-cluster.xml
trunk/refman-4.1/problems.xml
trunk/refman-5.0/mysql-cluster.xml
trunk/refman-5.0/problems.xml
trunk/refman-5.1/mysql-cluster.xml
trunk/refman-5.1/problems.xml
Modified: trunk/refman-4.1/mysql-cluster.xml
===================================================================
--- trunk/refman-4.1/mysql-cluster.xml 2006-09-13 21:58:16 UTC (rev 3347)
+++ trunk/refman-4.1/mysql-cluster.xml 2006-09-14 02:52:50 UTC (rev 3348)
Changed blocks: 4, Lines Added: 17, Lines Deleted: 5; 2256 bytes
@@ -16237,7 +16237,7 @@
We have implemented (asynchronous) replication for Cluster in
MySQL 5.1. This includes the capability to replicate both
between two clusters, and from a MySQL cluster to a
- non-Cluster MySQL server. Howecer, we do not plan to backport
+ non-Cluster MySQL server. However, we do not plan to backport
this functionality to MySQL 4.1.
</para>
</listitem>
@@ -16561,7 +16561,8 @@
This Perl script connects to a current MySQL (non-Cluster)
database and creates a report on how much space that database
would require if it used the <literal>NDBCluster</literal>
- storage engine.
+ storage engine. For more information, see
+ <xref linkend="mysql-cluster-utilities-ndb-size"/>.
</para>
<para>
@@ -16775,12 +16776,14 @@
</para>
<para>
- (It is possible to create tables using other storage engines
- such as <literal>MyISAM</literal> or <literal>InnoDB</literal>
+ It is possible to create tables using other storage engines
+ (such as <literal>MyISAM</literal> or
+ <literal>InnoDB</literal>)
on a MySQL server being used for clustering, but these
non-<literal>NDB</literal> tables will
<emphasis role="bold">not</emphasis> participate in the
- cluster.)
+ cluster; they are local to the individual MySQL server
+ instance on which they are created.
</para>
</listitem>
@@ -16963,6 +16966,15 @@
</para>
<itemizedlist>
+
+ <listitem>
+ <para>
+ Temporary tables are not supported; a <literal>CREATE TEMPORARY
+ TABLE</literal> statement using
+ <literal>ENGINE=NDB</literal> or
+ <literal>ENGINE=NDBCLUSTER</literal> fails with an error.
+ </para>
+ </listitem>
<listitem>
<para>
Modified: trunk/refman-4.1/problems.xml
===================================================================
--- trunk/refman-4.1/problems.xml 2006-09-13 21:58:16 UTC (rev 3347)
+++ trunk/refman-4.1/problems.xml 2006-09-14 02:52:50 UTC (rev 3348)
Changed blocks: 1, Lines Added: 4, Lines Deleted: 0; 541 bytes
@@ -4498,6 +4498,10 @@
<literal>MyISAM</literal>, <literal>MERGE</literal>, or
<literal>InnoDB</literal>.
</para>
+
+ <para>
+ Temporary tables are not supported for MySQL Cluster.
+ </para>
</listitem>
<listitem>
Modified: trunk/refman-5.0/mysql-cluster.xml
===================================================================
--- trunk/refman-5.0/mysql-cluster.xml 2006-09-13 21:58:16 UTC (rev 3347)
+++ trunk/refman-5.0/mysql-cluster.xml 2006-09-14 02:52:50 UTC (rev 3348)
Changed blocks: 3, Lines Added: 12, Lines Deleted: 6; 1839 bytes
@@ -16916,7 +16916,8 @@
This Perl script connects to a current MySQL (non-Cluster)
database and creates a report on how much space that database
would require if it used the <literal>NDBCluster</literal>
- storage engine.
+ storage engine. For more information, see
+ <xref linkend="mysql-cluster-utilities-ndb-size"/>.
</para>
<para>
@@ -17130,12 +17131,14 @@
</para>
<para>
- (It is possible to create tables using other storage engines
- such as <literal>MyISAM</literal> or <literal>InnoDB</literal>
+ It is possible to create tables using other storage engines
+ (such as <literal>MyISAM</literal> or
+ <literal>InnoDB</literal>)
on a MySQL server being used for clustering, but these
non-<literal>NDB</literal> tables will
<emphasis role="bold">not</emphasis> participate in the
- cluster.)
+ cluster; they are local to the individual MySQL server
+ instance on which they are created.
</para>
</listitem>
@@ -17323,10 +17326,13 @@
</para>
<itemizedlist>
-
+
<listitem>
<para>
- Not all character sets and collations are supported.
+ Temporary tables are not supported; a <literal>CREATE TEMPORARY
+ TABLE</literal> statement using
+ <literal>ENGINE=NDB</literal> or
+ <literal>ENGINE=NDBCLUSTER</literal> fails with an error.
</para>
</listitem>
Modified: trunk/refman-5.0/problems.xml
===================================================================
--- trunk/refman-5.0/problems.xml 2006-09-13 21:58:16 UTC (rev 3347)
+++ trunk/refman-5.0/problems.xml 2006-09-14 02:52:50 UTC (rev 3348)
Changed blocks: 1, Lines Added: 4, Lines Deleted: 0; 541 bytes
@@ -4461,6 +4461,10 @@
<literal>MyISAM</literal>, <literal>MERGE</literal>, or
<literal>InnoDB</literal>.
</para>
+
+ <para>
+ Temporary tables are not supported for MySQL Cluster.
+ </para>
</listitem>
<listitem>
Modified: trunk/refman-5.1/mysql-cluster.xml
===================================================================
--- trunk/refman-5.1/mysql-cluster.xml 2006-09-13 21:58:16 UTC (rev 3347)
+++ trunk/refman-5.1/mysql-cluster.xml 2006-09-14 02:52:50 UTC (rev 3348)
Changed blocks: 3, Lines Added: 23, Lines Deleted: 6; 2346 bytes
@@ -19324,7 +19324,8 @@
This Perl script connects to a current MySQL (non-Cluster)
database and creates a report on how much space that database
would require if it used the <literal>NDBCluster</literal>
- storage engine.
+ storage engine. For more information, see
+ <xref linkend="mysql-cluster-utilities-ndb-size"/>.
</para>
<para>
@@ -19539,12 +19540,14 @@
</para>
<para>
- (It is possible to create tables using other storage engines
- such as <literal>MyISAM</literal> or <literal>InnoDB</literal>
+ It is possible to create tables using other storage engines
+ (such as <literal>MyISAM</literal> or
+ <literal>InnoDB</literal>)
on a MySQL server being used for clustering, but these
non-<literal>NDB</literal> tables will
<emphasis role="bold">not</emphasis> participate in the
- cluster.)
+ cluster; they are local to the individual MySQL server
+ instance on which they are created.
</para>
</listitem>
@@ -19720,12 +19723,26 @@
</para>
<itemizedlist>
-
+
<listitem>
<para>
- Not all character sets and collations are supported.
+ Temporary tables are not supported; a <literal>CREATE TEMPORARY
+ TABLE</literal> statement using
+ <literal>ENGINE=NDB</literal> or
+ <literal>ENGINE=NDBCLUSTER</literal> fails with an error.
</para>
</listitem>
+
+ <listitem>
+ <para>
+ The only types of user-defined partitioning supported for
+ <literal>NDB</literal> tables are <literal>KEY</literal>
+ and <literal>LINEAR KEY</literal>. (Beginning with MySQL
+ 5.1.12, attempting to create an <literal>NDB</literal>
+ table using any other partitioning type fails with an
+ error.)
+ </para>
+ </listitem>
<listitem>
<para>
Modified: trunk/refman-5.1/problems.xml
===================================================================
--- trunk/refman-5.1/problems.xml 2006-09-13 21:58:16 UTC (rev 3347)
+++ trunk/refman-5.1/problems.xml 2006-09-14 02:52:50 UTC (rev 3348)
Changed blocks: 1, Lines Added: 4, Lines Deleted: 0; 566 bytes
@@ -4359,6 +4359,10 @@
<literal>HEAP</literal>, <literal>MyISAM</literal>,
<literal>MERGE</literal>, or <literal>InnoDB</literal>.
</para>
+
+ <para>
+ Temporary tables are not supported for MySQL Cluster.
+ </para>
</listitem>
<listitem>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r3348 - in trunk: refman-4.1 refman-5.0 refman-5.1 | jon | 14 Sep |
