From: Date: July 4 2006 6:27am
Subject: svn commit - mysqldoc@docsrva: r2615 - in trunk: refman-5.0 refman-5.1 refman-common
List-Archive: http://lists.mysql.com/commits/8672
Message-Id: <200607040427.k644RhkU029943@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
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.
+
+
+
+ Ndb_cluster_node_id
+
+
+
+ If the server is acting as a MySQL Cluster node, then the
+ value of this variable its node ID in the cluster.
+
+
+
+ If the server is not part of of a MySQL Cluster, then the
+ value of this variable is 0.
+
+
+
+
+
+ Ndb_config_from_host
+
+
+
+ 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.
+
+
+
+ If the server is not part of of a MySQL Cluster, then the
+ value of this variable is an empty string.
+
+
+
+ Prior to MySQL 5.0.23, this variable was named
+ Ndb_connected_host.
+
+
+
+
+
+ Ndb_config_from_port
+
+
+
+ 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.
+
+
+
+ If the server is not part of of a MySQL Cluster, then the
+ value of this variable is 0.
+
+
+
+ Prior to MySQL 5.0.23, this variable was named
+ Ndb_connected_port.
+
+
+
+
+
+ Ndb_number_of_storage_nodes
+
+
+
+ If the server is part of a MySQL Cluster, the value of
+ this variable is the number of data nodes in the cluster.
+
+
+
+ If the server is not part of of a MySQL Cluster, then the
+ value of this variable is 0.
+
+
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 @@
+
+
+ You can obtain some information from a MySQL server running as
+ a Cluster SQL node using SHOW STATUS in the
+ mysql client, as shown here:
+
+
+
+mysql> SHOW STATUS LIKE 'ndb%';
++-----------------------------+---------------+
+| 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)
+
+
+
+ For information about these Cluster system status variables,
+ see .
+
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.
+
+
+
+ Ndb_cluster_node_id
+
+
+
+ If the server is acting as a MySQL Cluster node, then the
+ value of this variable its node ID in the cluster.
+
+
+
+ If the server is not part of of a MySQL Cluster, then the
+ value of this variable is 0.
+
+
+
+
+
+ Ndb_config_from_host
+
+
+
+ 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.
+
+
+
+ If the server is not part of of a MySQL Cluster, then the
+ value of this variable is an empty string.
+
+
+
+ Prior to MySQL 5.1.12, this variable was named
+ Ndb_connected_host.
+
+
+
+
+
+ Ndb_config_from_port
+
+
+
+ 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.
+
+
+
+ If the server is not part of of a MySQL Cluster, then the
+ value of this variable is 0.
+
+
+
+ Prior to MySQL 5.1.12, this variable was named
+ Ndb_connected_port.
+
+
+
+
+
+ Ndb_number_of_storage_nodes
+
+
+
+ If the server is part of a MySQL Cluster, the value of
+ this variable is the number of data nodes in the cluster.
+
+
+
+ If the server is not part of of a MySQL Cluster, then the
+ value of this variable is 0.
+
+
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 @@
+
+
+ You can obtain some information from a MySQL server running as
+ a Cluster SQL node using SHOW STATUS in the
+ mysql client, as shown here:
+
+
+
+mysql> SHOW STATUS LIKE 'ndb%';
++-----------------------------+---------------+
+| 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)
+
+
+
+ For information about these Cluster system status variables,
+ see .
+
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)
+
+
+
+ NDB Cluster: The status variables
+ Ndb_connected_host and
+ Ndb_connected_port were renamed to
+ Ndb_config_from_host and
+ Ndb_config_from_port, respectively.
+
+
@@ -404,6 +414,13 @@
+
+
+
+ NDB Cluster: Cluster system status
+ variables were not updated. (Bug #11459)
+
+
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 CSV storage engine.
+
+
+
+ NDB Cluster: The status variables
+ Ndb_connected_host and
+ Ndb_connected_port were renamed to
+ Ndb_config_from_host and
+ Ndb_config_from_port, respectively.
+
+
@@ -285,6 +295,13 @@
REPAIR TABLE tbl_name QUICK;
+
+
+
+ NDB Cluster: Cluster system status
+ variables were not updated. (Bug #11459)
+
+