Author: jstephens
Date: 2006-07-04 06:27:35 +0200 (Tue, 04 Jul 2006)
New Revision: 2615
Log:
Documenting fix for Cluster Bug #11459
Documenting Cluster server status variables
Modified:
trunk/refman-5.0/database-administration.xml
trunk/refman-5.0/ndbcluster.xml
trunk/refman-5.1/database-administration.xml
trunk/refman-5.1/ndbcluster.xml
trunk/refman-common/news-5.0.xml
trunk/refman-common/news-5.1.xml
Modified: trunk/refman-5.0/database-administration.xml
===================================================================
--- trunk/refman-5.0/database-administration.xml 2006-07-04 00:44:52 UTC (rev 2614)
+++ trunk/refman-5.0/database-administration.xml 2006-07-04 04:27:35 UTC (rev 2615)
@@ -9248,6 +9248,84 @@
simultaneously since the server started.
</para>
</listitem>
+
+ <listitem>
+ <para>
+ <literal>Ndb_cluster_node_id</literal>
+ </para>
+
+ <para>
+ If the server is acting as a MySQL Cluster node, then the
+ value of this variable its node ID in the cluster.
+ </para>
+
+ <para>
+ If the server is not part of of a MySQL Cluster, then the
+ value of this variable is 0.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>Ndb_config_from_host</literal>
+ </para>
+
+ <para>
+ If the server is part of a MySQL Cluster, the value of
+ this variable is the hostname or IP address of the
+ Cluster management server from which it gets its
+ configuration data.
+ </para>
+
+ <para>
+ If the server is not part of of a MySQL Cluster, then the
+ value of this variable is an empty string.
+ </para>
+
+ <para>
+ Prior to MySQL 5.0.23, this variable was named
+ <literal>Ndb_connected_host</literal>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>Ndb_config_from_port</literal>
+ </para>
+
+ <para>
+ If the server is part of a MySQL Cluster, the value of
+ this variable is the number of the port through which it
+ is connected to the CLuster management server from which
+ it gets its configuration data.
+ </para>
+
+ <para>
+ If the server is not part of of a MySQL Cluster, then the
+ value of this variable is 0.
+ </para>
+
+ <para>
+ Prior to MySQL 5.0.23, this variable was named
+ <literal>Ndb_connected_port</literal>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>Ndb_number_of_storage_nodes</literal>
+ </para>
+
+ <para>
+ If the server is part of a MySQL Cluster, the value of
+ this variable is the number of data nodes in the cluster.
+ </para>
+
+ <para>
+ If the server is not part of of a MySQL Cluster, then the
+ value of this variable is 0.
+ </para>
+ </listitem>
<listitem>
<para>
Modified: trunk/refman-5.0/ndbcluster.xml
===================================================================
--- trunk/refman-5.0/ndbcluster.xml 2006-07-04 00:44:52 UTC (rev 2614)
+++ trunk/refman-5.0/ndbcluster.xml 2006-07-04 04:27:35 UTC (rev 2615)
@@ -5837,6 +5837,30 @@
</listitem>
</itemizedlist>
+
+ <para>
+ You can obtain some information from a MySQL server running as
+ a Cluster SQL node using <literal>SHOW STATUS</literal> in the
+ <literal>mysql</literal> client, as shown here:
+ </para>
+
+<programlisting>
+mysql> <userinput>SHOW STATUS LIKE 'ndb%';</userinput>
++-----------------------------+---------------+
+| Variable_name | Value |
++-----------------------------+---------------+
+| Ndb_cluster_node_id | 5 |
+| Ndb_config_from_host | 192.168.0.112 |
+| Ndb_config_from_port | 1186 |
+| Ndb_number_of_storage_nodes | 4 |
++-----------------------------+---------------+
+4 rows in set (0.02 sec)
+</programlisting>
+
+ <para>
+ For information about these Cluster system status variables,
+ see <xref linkend="server-status-variables"/>.
+ </para>
</section>
Modified: trunk/refman-5.1/database-administration.xml
===================================================================
--- trunk/refman-5.1/database-administration.xml 2006-07-04 00:44:52 UTC (rev 2614)
+++ trunk/refman-5.1/database-administration.xml 2006-07-04 04:27:35 UTC (rev 2615)
@@ -9656,6 +9656,84 @@
simultaneously since the server started.
</para>
</listitem>
+
+ <listitem>
+ <para>
+ <literal>Ndb_cluster_node_id</literal>
+ </para>
+
+ <para>
+ If the server is acting as a MySQL Cluster node, then the
+ value of this variable its node ID in the cluster.
+ </para>
+
+ <para>
+ If the server is not part of of a MySQL Cluster, then the
+ value of this variable is 0.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>Ndb_config_from_host</literal>
+ </para>
+
+ <para>
+ If the server is part of a MySQL Cluster, the value of
+ this variable is the hostname or IP address of the
+ Cluster management server from which it gets its
+ configuration data.
+ </para>
+
+ <para>
+ If the server is not part of of a MySQL Cluster, then the
+ value of this variable is an empty string.
+ </para>
+
+ <para>
+ Prior to MySQL 5.1.12, this variable was named
+ <literal>Ndb_connected_host</literal>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>Ndb_config_from_port</literal>
+ </para>
+
+ <para>
+ If the server is part of a MySQL Cluster, the value of
+ this variable is the number of the port through which it
+ is connected to the CLuster management server from which
+ it gets its configuration data.
+ </para>
+
+ <para>
+ If the server is not part of of a MySQL Cluster, then the
+ value of this variable is 0.
+ </para>
+
+ <para>
+ Prior to MySQL 5.1.12, this variable was named
+ <literal>Ndb_connected_port</literal>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>Ndb_number_of_storage_nodes</literal>
+ </para>
+
+ <para>
+ If the server is part of a MySQL Cluster, the value of
+ this variable is the number of data nodes in the cluster.
+ </para>
+
+ <para>
+ If the server is not part of of a MySQL Cluster, then the
+ value of this variable is 0.
+ </para>
+ </listitem>
<listitem>
<para>
Modified: trunk/refman-5.1/ndbcluster.xml
===================================================================
--- trunk/refman-5.1/ndbcluster.xml 2006-07-04 00:44:52 UTC (rev 2614)
+++ trunk/refman-5.1/ndbcluster.xml 2006-07-04 04:27:35 UTC (rev 2615)
@@ -5838,6 +5838,30 @@
</listitem>
</itemizedlist>
+
+ <para>
+ You can obtain some information from a MySQL server running as
+ a Cluster SQL node using <literal>SHOW STATUS</literal> in the
+ <literal>mysql</literal> client, as shown here:
+ </para>
+
+<programlisting>
+mysql> <userinput>SHOW STATUS LIKE 'ndb%';</userinput>
++-----------------------------+---------------+
+| Variable_name | Value |
++-----------------------------+---------------+
+| Ndb_cluster_node_id | 5 |
+| Ndb_config_from_host | 192.168.0.112 |
+| Ndb_config_from_port | 1186 |
+| Ndb_number_of_storage_nodes | 4 |
++-----------------------------+---------------+
+4 rows in set (0.02 sec)
+</programlisting>
+
+ <para>
+ For information about these Cluster system status variables,
+ see <xref linkend="server-status-variables"/>.
+ </para>
</section>
Modified: trunk/refman-common/news-5.0.xml
===================================================================
--- trunk/refman-common/news-5.0.xml 2006-07-04 00:44:52 UTC (rev 2614)
+++ trunk/refman-common/news-5.0.xml 2006-07-04 04:27:35 UTC (rev 2615)
@@ -263,6 +263,16 @@
(Bug #14509)
</para>
</listitem>
+
+ <listitem>
+ <para>
+ <literal>NDB Cluster</literal>: The status variables
+ <literal>Ndb_connected_host</literal> and
+ <literal>Ndb_connected_port</literal> were renamed to
+ <literal>Ndb_config_from_host</literal> and
+ <literal>Ndb_config_from_port</literal>, respectively.
+ </para>
+ </listitem>
<listitem>
<para>
@@ -404,6 +414,13 @@
</para>
<itemizedlist>
+
+ <listitem>
+ <para>
+ <literal>NDB Cluster</literal>: Cluster system status
+ variables were not updated. (Bug #11459)
+ </para>
+ </listitem>
<listitem>
<para>
Modified: trunk/refman-common/news-5.1.xml
===================================================================
--- trunk/refman-common/news-5.1.xml 2006-07-04 00:44:52 UTC (rev 2614)
+++ trunk/refman-common/news-5.1.xml 2006-07-04 04:27:35 UTC (rev 2615)
@@ -183,6 +183,16 @@
the <literal>CSV</literal> storage engine.
</para>
</listitem>
+
+ <listitem>
+ <para>
+ <literal>NDB Cluster</literal>: The status variables
+ <literal>Ndb_connected_host</literal> and
+ <literal>Ndb_connected_port</literal> were renamed to
+ <literal>Ndb_config_from_host</literal> and
+ <literal>Ndb_config_from_port</literal>, respectively.
+ </para>
+ </listitem>
<listitem>
<para>
@@ -285,6 +295,13 @@
REPAIR TABLE <replaceable>tbl_name</replaceable> QUICK;
</programlisting>
</listitem>
+
+ <listitem>
+ <para>
+ <literal>NDB Cluster</literal>: Cluster system status
+ variables were not updated. (Bug #11459)
+ </para>
+ </listitem>
<listitem>
<para>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r2615 - in trunk: refman-5.0 refman-5.1 refman-common | jon | 4 Jul |
