MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
The table_distribution_status table provides
information about the progress of table distribution for
NDB tables.
The following table provides information about the columns in
table_distribution_status. For each column,
the table shows the name, data type, and a brief description.
Table 22.399 Columns of the table_distribution_status table
| Column Name | Type | Description |
|---|---|---|
node_id |
integer | Node id |
table_id |
integer | Table ID |
tab_copy_status |
string | Status of copying of table distribution data to disk; one of
IDLE,
SR_PHASE1_READ_PAGES,
SR_PHASE2_READ_TABLE,
SR_PHASE3_COPY_TABLE,
REMOVE_NODE,
LCP_READ_TABLE,
COPY_TAB_REQ,
COPY_NODE_STATE,
ADD_TABLE_MASTER,
ADD_TABLE_SLAVE,
INVALIDATE_NODE_LCP,
ALTER_TABLE,
COPY_TO_SAVE, or
GET_TABINFO |
tab_update_status |
string | Status of updating of table distribution data; one of
IDLE,
LOCAL_CHECKPOINT,
LOCAL_CHECKPOINT_QUEUED,
REMOVE_NODE,
COPY_TAB_REQ,
ADD_TABLE_MASTER,
ADD_TABLE_SLAVE,
INVALIDATE_NODE_LCP, or
CALLBACK |
tab_lcp_status |
string | Status of table LCP; one of ACTIVE (waiting for local
checkpoint to be performed),
WRITING_TO_FILE (checkpoint performed
but not yet written to disk), or
COMPLETED (checkpoint performed and
persisted to disk) |
tab_status |
string | Table internal status; one of ACTIVE (table exists),
CREATING (table is being created), or
DROPPING (table is being dropped) |
tab_storage |
string | Table recoverability; one of NORMAL (fully
recoverable with redo logging and checkpointing),
NOLOGGING (recoverable from node crash,
empty following cluster crash), or
TEMPORARY (not recoverable) |
tab_partitions |
integer | Number of partitions in table |
tab_fragments |
integer | Number of fragments in table; normally same as
tab_partitions; for fully replicated
tables equal to tab_partitions * [number of node
groups] |
current_scan_count |
integer | Current number of active scans |
scan_count_wait |
integer | Current number of scans waiting to be performed before ALTER
TABLE can complete. |
is_reorg_ongoing |
integer | Whether table is currently being reorganized (1 if true) |