25.6.16.56 The ndbinfo table_distribution_status Table (original) (raw)

25.6.16.56 The ndbinfo table_distribution_status Table

The table_distribution_status table provides information about the progress of table distribution forNDB 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 ofIDLE,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, orGET_TABINFO
• tab_update_status
  Status of updating of table distribution data; one ofIDLE,LOCAL_CHECKPOINT,LOCAL_CHECKPOINT_QUEUED,REMOVE_NODE,COPY_TAB_REQ,ADD_TABLE_MASTER,ADD_TABLE_SLAVE,INVALIDATE_NODE_LCP, orCALLBACK
• 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), orTEMPORARY (not recoverable)
• tab_partitions
  Number of partitions in table
• tab_fragments
  Number of fragments in table; normally same astab_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 beforeALTER TABLE can complete.
• is_reorg_ongoing
  Whether the table is currently being reorganized (1 if true)