•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. 

## 23.5.14.38 The ndbinfo nodes 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. 

## Notes 

The nodes  table contains the following columns: 

## • node_id 

The data node’s unique node ID in the cluster. 

## • uptime 

Time since the node was last started, in seconds. 

## • status 

Current status of the data node; see text for possible values. 

## • start_phase 

If the data node is starting, the current start phase. 

## • config_generation 

The version of the cluster configuration file in use on this data node. 

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 . 

