content_image/823456.jpg content_image/823450.jpg
## Notes 

The config_values  table contains the following columns: 

• node_id 

ID of the node in the cluster 

• config_param 

The parameter’s internal ID number 

• config_value 

Current value of the parameter 

This table’s config_param  column and the config_params  table’s param_number  column use the same parameter identifiers. By joining the two tables on these columns, you can obtain detailed information about desired node configuration parameters. The query shown here provides the current values for all parameters on each data node in the cluster, ordered by node ID and parameter name: 

<img src='content_image/823456.jpg'>

Partial output from the previous query when run on a small example cluster used for simple testing: 

<img src='content_image/823450.jpg'>

248 rows in set (0.02 sec) 

The WHERE  clause filters out parameters whose names begin with a double underscore ( __ ); these parameters are reserved for testing and other internal uses by the NDB developers, and are not intended for use in a production NDB Cluster. 

You can obtain output that is more specific, more detailed, or both by issuing the proper queries. This example provides all types of available information about the NodeId , NoOfReplicas , HostName , DataMemory , IndexMemory , and TotalSendBufferMemory  parameters as currently set for all data nodes in the cluster: 

