22.5.10.39 The ndbinfo table_distribution_status Table

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