Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 36.3Mb
PDF (A4) - 36.3Mb
PDF (RPM) - 36.2Mb
HTML Download (TGZ) - 10.4Mb
HTML Download (Zip) - 10.4Mb
HTML Download (RPM) - 9.2Mb
Man Pages (TGZ) - 224.6Kb
Man Pages (Zip) - 332.7Kb
Info (Gzip) - 3.3Mb
Info (Zip) - 3.3Mb
Excerpts from this Manual

20.5.14.36 The ndbinfo table_distribution_status Table

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_MASTER, 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.

  • is_reorg_ongoing

    Whether table is currently being reorganized (1 if true)

Notes

The table_distribution_status table was added in NDB 7.5.4.