From: jon
Date: April 7 2006 10:08am
Subject: svn commit - mysqldoc@docsrva: r1753 - in trunk: refman-4.1 refman-5.0 refman-5.1 refman-common
List-Archive: http://lists.mysql.com/commits/4614
Message-Id: <200604071008.k37A8DTb016290@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Author: jstephens
Date: 2006-04-07 12:08:10 +0200 (Fri, 07 Apr 2006)
New Revision: 1753
Log:
New section: Cluster Log Statistics
Fixes Docs Bug #16145
Modified:
trunk/refman-4.1/ndbcluster.xml
trunk/refman-5.0/ndbcluster.xml
trunk/refman-5.1/ndbcluster.xml
trunk/refman-common/titles.en.ent
Modified: trunk/refman-4.1/ndbcluster.xml
===================================================================
--- trunk/refman-4.1/ndbcluster.xml 2006-04-07 08:02:33 UTC (rev 1752)
+++ trunk/refman-4.1/ndbcluster.xml 2006-04-07 10:08:10 UTC (rev 1753)
@@ -7850,6 +7850,144 @@
+
+
+
+
+ &title-mysql-cluster-log-statistics;
+
+
+ The NDB management client's
+ CLUSTERLOG STATISTICS command can provide a
+ number of useful statistics in its output. The following
+ statistics are reported by the transaction coordinator:
+
+
+
+
+
+
+
+
+ Statistic
+ Description (Number of...)
+
+
+ Trans. Count
+ Transactions attempted with this node as coordinator
+
+
+ Commit Count
+ Transactions committed with this node as coordinator
+
+
+ Read Count
+ Primary key reads (all)
+
+
+ Simple Read Count
+ Primary key reads reading the latest committed value
+
+
+ Write Count
+ Primary key writes (includes all
+ INSERT, UPDATE,
+ and DELETE operations)
+
+
+ AttrInfoCount
+ Data words used to describe all reads and writes received
+
+
+ Concurrent Operations
+ All concurrent operations ongoing at the moment
+ the report is taken
+
+
+ Abort Count
+ Transactions with this node as coordinator that
+ were aborted
+
+
+ Scans
+ Scans (all)
+
+
+ Range Scans
+ Index scans
+
+
+
+
+
+
+
+ The ndbd process has a scheduler that runs
+ in an infinite loop. During each loop scheduler performs the
+ following tasks:
+
+
+
+
+
+ Read any incoming messages from sockets into a job buffer.
+
+
+
+
+
+ Check whether there are any timed messages to be executed;
+ if so, put these into the job buffer as well.
+
+
+
+
+
+ Execute (in a loop) any messages in the job buffer.
+
+
+
+
+
+ Send any distributed messages that were generated by
+ executing the messages in the job buffer.
+
+
+
+
+
+ Wait for any new incoming messages.
+
+
+
+
+
+ The number of loops executed in the third step is reported as
+ the Mean Loop Counter. This statistic
+ increases in size as the utilisation of the TCP/IP buffer
+ improves. You can use this to monitor performance as you add
+ new processes to the cluster.
+
+
+
+ The Mean send size and Mean
+ receive size statistics allow you to gauge the
+ efficiency of writes and reads (respectively) between nodes.
+ These values are given in bytes. Higher values mean a lower
+ cost per byte sent or received; the maximum is 64k.
+
+
+
+ To generate a report of all cluster log statistics, you can
+ use the following command in the NDB
+ management client:
+
+
+
+ndb_mgm> ALL CLUSTERLOG STATISTICS=15
+
+
+
Modified: trunk/refman-5.0/ndbcluster.xml
===================================================================
--- trunk/refman-5.0/ndbcluster.xml 2006-04-07 08:02:33 UTC (rev 1752)
+++ trunk/refman-5.0/ndbcluster.xml 2006-04-07 10:08:10 UTC (rev 1753)
@@ -6386,6 +6386,144 @@
+
+
+
+
+ &title-mysql-cluster-log-statistics;
+
+
+ The NDB management client's
+ CLUSTERLOG STATISTICS command can provide a
+ number of useful statistics in its output. The following
+ statistics are reported by the transaction coordinator:
+
+
+
+
+
+
+
+
+ Statistic
+ Description (Number of...)
+
+
+ Trans. Count
+ Transactions attempted with this node as coordinator
+
+
+ Commit Count
+ Transactions committed with this node as coordinator
+
+
+ Read Count
+ Primary key reads (all)
+
+
+ Simple Read Count
+ Primary key reads reading the latest committed value
+
+
+ Write Count
+ Primary key writes (includes all
+ INSERT, UPDATE,
+ and DELETE operations)
+
+
+ AttrInfoCount
+ Data words used to describe all reads and writes received
+
+
+ Concurrent Operations
+ All concurrent operations ongoing at the moment
+ the report is taken
+
+
+ Abort Count
+ Transactions with this node as coordinator that
+ were aborted
+
+
+ Scans
+ Scans (all)
+
+
+ Range Scans
+ Index scans
+
+
+
+
+
+
+
+ The ndbd process has a scheduler that runs
+ in an infinite loop. During each loop scheduler performs the
+ following tasks:
+
+
+
+
+
+ Read any incoming messages from sockets into a job buffer.
+
+
+
+
+
+ Check whether there are any timed messages to be executed;
+ if so, put these into the job buffer as well.
+
+
+
+
+
+ Execute (in a loop) any messages in the job buffer.
+
+
+
+
+
+ Send any distributed messages that were generated by
+ executing the messages in the job buffer.
+
+
+
+
+
+ Wait for any new incoming messages.
+
+
+
+
+
+ The number of loops executed in the third step is reported as
+ the Mean Loop Counter. This statistic
+ increases in size as the utilisation of the TCP/IP buffer
+ improves. You can use this to monitor performance as you add
+ new processes to the cluster.
+
+
+
+ The Mean send size and Mean
+ receive size statistics allow you to gauge the
+ efficiency of writes and reads (respectively) between nodes.
+ These values are given in bytes. Higher values mean a lower
+ cost per byte sent or received; the maximum is 64k.
+
+
+
+ To generate a report of all cluster log statistics, you can
+ use the following command in the NDB
+ management client:
+
+
+
+ndb_mgm> ALL CLUSTERLOG STATISTICS=15
+
+
+
Modified: trunk/refman-5.1/ndbcluster.xml
===================================================================
--- trunk/refman-5.1/ndbcluster.xml 2006-04-07 08:02:33 UTC (rev 1752)
+++ trunk/refman-5.1/ndbcluster.xml 2006-04-07 10:08:10 UTC (rev 1753)
@@ -7817,7 +7817,144 @@
-
+
+
+ &title-mysql-cluster-log-statistics;
+
+
+ The NDB management client's
+ CLUSTERLOG STATISTICS command can provide a
+ number of useful statistics in its output. The following
+ statistics are reported by the transaction coordinator:
+
+
+
+
+
+
+
+
+ Statistic
+ Description (Number of...)
+
+
+ Trans. Count
+ Transactions attempted with this node as coordinator
+
+
+ Commit Count
+ Transactions committed with this node as coordinator
+
+
+ Read Count
+ Primary key reads (all)
+
+
+ Simple Read Count
+ Primary key reads reading the latest committed value
+
+
+ Write Count
+ Primary key writes (includes all
+ INSERT, UPDATE,
+ and DELETE operations)
+
+
+ AttrInfoCount
+ Data words used to describe all reads and writes received
+
+
+ Concurrent Operations
+ All concurrent operations ongoing at the moment
+ the report is taken
+
+
+ Abort Count
+ Transactions with this node as coordinator that
+ were aborted
+
+
+ Scans
+ Scans (all)
+
+
+ Range Scans
+ Index scans
+
+
+
+
+
+
+
+ The ndbd process has a scheduler that runs
+ in an infinite loop. During each loop scheduler performs the
+ following tasks:
+
+
+
+
+
+ Read any incoming messages from sockets into a job buffer.
+
+
+
+
+
+ Check whether there are any timed messages to be executed;
+ if so, put these into the job buffer as well.
+
+
+
+
+
+ Execute (in a loop) any messages in the job buffer.
+
+
+
+
+
+ Send any distributed messages that were generated by
+ executing the messages in the job buffer.
+
+
+
+
+
+ Wait for any new incoming messages.
+
+
+
+
+
+ The number of loops executed in the third step is reported as
+ the Mean Loop Counter. This statistic
+ increases in size as the utilisation of the TCP/IP buffer
+ improves. You can use this to monitor performance as you add
+ new processes to the cluster.
+
+
+
+ The Mean send size and Mean
+ receive size statistics allow you to gauge the
+ efficiency of writes and reads (respectively) between nodes.
+ These values are given in bytes. Higher values mean a lower
+ cost per byte sent or received; the maximum is 64k.
+
+
+
+ To generate a report of all cluster log statistics, you can
+ use the following command in the NDB
+ management client:
+
+
+
+ndb_mgm> ALL CLUSTERLOG STATISTICS=15
+
+
+
+
+
Modified: trunk/refman-common/titles.en.ent
===================================================================
--- trunk/refman-common/titles.en.ent 2006-04-07 08:02:33 UTC (rev 1752)
+++ trunk/refman-common/titles.en.ent 2006-04-07 10:08:10 UTC (rev 1753)
@@ -889,6 +889,7 @@
+