ndbinfo: The NDB Cluster Information Database •Foreign key definition •Foreign key parent trigger •Foreign key child trigger •Schema transaction You can also obtain this list by executing  SELECT * FROM ndbinfo.dict_obj_types  in the  mysql client. The  block_instance  column provides the NDB kernel block instance number. You can use this to obtain information about specific threads from the  threadblocks  table. This table contains information on the status of data nodes. For each data node that is running in the cluster, a corresponding row in this table provides the node’s node ID, status, and uptime. For nodes that are starting, it also shows the current start phase. The  uptime  column shows the time in seconds that this node has been running since it was last started or restarted. This is a  BIGINT  value. This figure includes the time actually needed to start the node; in other words, this counter starts running the moment that  ndbd  or  ndbmtd  is first invoked; thus, even for a node that has not yet finished starting,  uptime  may show a nonzero value. The  status  column shows the node’s current status. This is one of:  NOTHING ,  CMVMI ,  STARTING , STARTED ,  SINGLEUSER ,  STOPPING_1 ,  STOPPING_2 ,  STOPPING_3 , or  STOPPING_4 . When the status is  STARTING , you can see the current start phase in the  start_phase  column (see later in this section). SINGLEUSER  is displayed in the  status  column for all data nodes when the cluster is in single user mode (see Section 23.5.6, “NDB Cluster Single User Mode” ). Seeing one of the  STOPPING  states does not necessarily mean that the node is shutting down but can mean rather that it is entering a new state. For example, if you put the cluster in single user mode, you can sometimes see data nodes report their state briefly as  STOPPING_2  before the status changes to  SINGLEUSER . The version of the cluster configuration file in use on this data node. If the data node is starting, the current start phase. Current status of the data node; see text for possible values. Time since the node was last started, in seconds. The data node’s unique node ID in the cluster. The  nodes  table contains the following columns: Notes • config_generation • start_phase • status • uptime • node_id 23.5.14.38 The ndbinfo nodes Table 4566