Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 37.4Mb
PDF (A4) - 37.4Mb
PDF (RPM) - 37.0Mb
EPUB - 10.6Mb
HTML Download (TGZ) - 10.3Mb
HTML Download (Zip) - 10.4Mb
HTML Download (RPM) - 9.0Mb
Eclipse Doc Plugin (TGZ) - 11.2Mb
Eclipse Doc Plugin (Zip) - 13.4Mb
Man Pages (TGZ) - 204.7Kb
Man Pages (Zip) - 311.8Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  /  ...  /  The ndbinfo table_distribution_status Table

20.5.10.33 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.

Column NameTypeDescription
node_idintegerNode id
table_idintegerTable ID
tab_copy_statusstringStatus 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_statusstringStatus 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_statusstringStatus 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_statusstringTable internal status; one of ACTIVE (table exists), CREATING (table is being created), or DROPPING (table is being dropped)
tab_storagestringTable 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_partitionsintegerNumber of partitions in table
tab_fragmentsintegerNumber of fragments in table; normally same as tab_partitions; for fully replicated tables equal to tab_partitions * [number of node groups]
current_scan_countintegerCurrent number of active scans
scan_count_waitintegerCurrent number of scans waiting to be performed before ALTER TABLE can complete.
is_reorg_ongoingintegerWhether table is currently being reorganized (1 if true)

The table_distribution_status table was added in NDB 7.5.4.


User Comments
Sign Up Login You must be logged in to post a comment.