Bug #48414 Statistics on ndbmtd, ndbd
Submitted: 29 Oct 2009 16:57 Modified: 3 Nov 2009 15:41
Reporter: Kevin Benton Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S4 (Feature request)
Version:mysql-5.1-telco-6.2 OS:Any
Assigned to: CPU Architecture:Any
Tags: 6.2+

[29 Oct 2009 16:57] Kevin Benton
Description:
At this point, the only way to have any visibility into the health of the ndb data nodes is to interact with the management node and ask it to log things.  What I need is the ability to see counters from one of the MySQL servers or via snmp to the management node.  This would help me get a better picture of the overall health of the cluster and each of the data nodes as well as seeing the distribution of I/O among other things.  I would like to be able to see ndb_<nodeid>_io_reads, ndb_<nodeid>_io_writes, ndb_<nodeid>_uptime, ... all from show engine ndb status as well as via an SNMP monitoring system (traps?).  We get the same for the MySQL server from show global status currently.

How to repeat:
See Description

Suggested fix:
See Description
[2 Nov 2009 7:39] Bernd Ocklin
Hi Kevin,

thanks for your suggestions and your feature request. And you will be glad to hear that we are already working on a solution. Next release of cluster 7.1 will contain ndb$info which will allow you to exactly do this: query data node status from SQL level. The second solution is the MySQL Cluster Manager which we will soon release. It will help you with a lot of things when managing cluster.
[3 Nov 2009 15:41] Hartmut Holzgraefe
Duplicate of feature request bug #27983 (and probably others ...)