The table_distribution_status  table provides information about the progress of table distribution for NDB  tables. 

The table_distribution_status  table contains the following columns: 

• node_id 

Node id 

• table_id 

Table ID 

• tab_copy_status 

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_COORDINATOR  ( prior to NDB 8.0.23 : ADD_TABLE_MASTER ), ADD_TABLE_PARTICIPANT  ( prior to NDB 8.0.23 : ADD_TABLE_SLAVE ), INVALIDATE_NODE_LCP , ALTER_TABLE , COPY_TO_SAVE , or GET_TABINFO 

• tab_update_status 

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 

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 

Table internal status; one of ACTIVE  (table exists), CREATING  (table is being created), or DROPPING (table is being dropped) 

• tab_storage 

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 

Number of partitions in table 

• tab_fragments 

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 

Current number of active scans 

• scan_count_wait 

Current number of scans waiting to be performed before ALTER TABLE  can complete. 

