SELECT p.param_name AS Name, v.node_id AS Node, p.param_type AS Type, p.param_default AS ’Default’, p.param_min AS Minimum, p.param_max AS Maximum, CASE p.param_mandatory WHEN 1 THEN ’Y’ ELSE ’N’ END AS ’Required’, v.config_value AS Current FROM config_params p JOIN config_values v ON p.param_number = v.config_param WHERE p. param_name IN (’NodeId’, ’NoOfReplicas’, ’HostName’, ’DataMemory’, ’IndexMemory’, ’TotalSendBufferMemory’)\G 

The output from this query when run on a small NDB Cluster with 2 data nodes used for simple testing is shown here (NDB 8.0.18 and later): 

*************************** 1. row *************************** Name: NodeId Node: 2 Type: unsigned  Default:  Minimum: 1  Maximum: 144 Required: Y  Current: 2 *************************** 2. row *************************** Name: HostName Node: 2 Type: string  Default: localhost  Minimum:  Maximum: Required: N  Current: 127.0.0.1 *************************** 3. row *************************** Name: TotalSendBufferMemory Node: 2 Type: unsigned  Default: 0  Minimum: 262144  Maximum: 4294967039 Required: N  Current: 0 *************************** 4. row *************************** Name: NoOfReplicas Node: 2 Type: unsigned  Default: 2  Minimum: 1  Maximum: 4 Required: N  Current: 2 *************************** 5. row *************************** Name: DataMemory Node: 2 Type: unsigned  Default: 102760448  Minimum: 1048576  Maximum: 1099511627776 Required: N  Current: 524288000 *************************** 6. row *************************** Name: NodeId Node: 3 Type: unsigned 

