MySQL Cluster :: 5 Management of MySQL Cluster :: 5.8 The ndbinfo MySQL Cluster Information Database :: 5.8.9 The ndbinfo resources Table
Section Navigation [Toggle]
- 5.8 The ndbinfo MySQL Cluster Information Database
- 5.8.1 The ndbinfo blocks Table
- 5.8.2 The ndbinfo config_params Table
- 5.8.3 The ndbinfo counters Table
- 5.8.4 The ndbinfo logbuffers Table
- 5.8.5 The ndbinfo logspaces Table
- 5.8.6 The ndbinfo memoryusage Table
- 5.8.7 The ndbinfo nodes Table
- 5.8.8 The ndbinfo pools Table
- 5.8.9 The ndbinfo resources Table
- 5.8.10 The ndbinfo transporters Table
This table provides information about data node resource availability and usage.
These resources are sometimes known as super-pools.
The following table provides information about the columns in
the resources table. For each column, the
table shows the name, data type, and a brief description.
Additional information can be found in the notes following the
table.
| Column Name | Type | Remarks |
|---|---|---|
node_id |
integer | The unique node ID of this data node. |
resource_name |
string | Name of the resource; see text. |
reserved |
integer | The amount reserved for this resource. |
used |
integer | The amount actually used by this resource. |
max |
integer | The maximum amount of this resource used, since the node was last started. |
The resource_name can be one of
RESERVED, DISK_OPERATIONS,
DISK_RECORDS, DATA_MEMORY,
JOBBUFFER, FILE_BUFFERS,
or TRANSPORTER_BUFFERS.
