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) |