- 17.5.8 The ndbinfo MySQL Cluster Information Database
- 17.5.8.1 The ndbinfo blocks Table
- 17.5.8.2 The ndbinfo config_params Table
- 17.5.8.3 The ndbinfo counters Table
- 17.5.8.4 The ndbinfo logbuffers Table
- 17.5.8.5 The ndbinfo logspaces Table
- 17.5.8.6 The ndbinfo memoryusage Table
- 17.5.8.7 The ndbinfo nodes Table
- 17.5.8.8 The ndbinfo pools Table
- 17.5.8.9 The ndbinfo resources Table
- 17.5.8.10 The ndbinfo transporters Table
The counters table provides running totals of
events such as reads and writes for specific kernel blocks and
data nodes. Counts are kept from the most recent node start or
restart; a node start or restart resets all counters on that
node. Not all kernel blocks have all types of counters.
The following table provides information about the columns in
the counters 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 data node ID |
block_name |
string | Name of the associated NDB kernel block (see
NDB Kernel Blocks). |
block_instance |
integer | _REMARK_ |
counter_id |
integer | The counter's internal ID number; normally an integer between 1 and 10, inclusive. |
counter_name |
string | The name (type) of the counter. See text for possible values. |
val |
integer | The counter's value |
counter_name can be any one of the following:
ATTRINFO, TRANSACTIONS,
COMMITS, READS,
SIMPLE_READS, WRITES,
ABORTS, TABLE_SCANS,
RANGE_SCANS, or
OPERATIONS.
User Comments
Add your own comment.