<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="mysql-cluster-ndbinfo-table-distribution-status">
      </a>
      25.6.17.57 The ndbinfo table_distribution_status Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045087785536">
  </a>
  <p>
   The
   <code class="literal">
    table_distribution_status
   </code>
   table provides
        information about the progress of table distribution for
   <code class="literal">
    NDB
   </code>
   tables.
  </p>
  <p>
   The
   <code class="literal">
    table_distribution_status
   </code>
   table contains
        the following columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       node_id
      </code>
     </p>
     <p>
      Node id
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       table_id
      </code>
     </p>
     <p>
      Table ID
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       tab_copy_status
      </code>
     </p>
     <p>
      Status of copying of table distribution data to disk; one of
      <code class="literal">
       IDLE
      </code>
      ,
      <code class="literal">
       SR_PHASE1_READ_PAGES
      </code>
      ,
      <code class="literal">
       SR_PHASE2_READ_TABLE
      </code>
      ,
      <code class="literal">
       SR_PHASE3_COPY_TABLE
      </code>
      ,
      <code class="literal">
       REMOVE_NODE
      </code>
      ,
      <code class="literal">
       LCP_READ_TABLE
      </code>
      ,
      <code class="literal">
       COPY_TAB_REQ
      </code>
      ,
      <code class="literal">
       COPY_NODE_STATE
      </code>
      ,
      <code class="literal">
       ADD_TABLE_COORDINATOR
      </code>
      ,
      <code class="literal">
       ADD_TABLE_PARTICIPANT
      </code>
      ,
      <code class="literal">
       INVALIDATE_NODE_LCP
      </code>
      ,
      <code class="literal">
       ALTER_TABLE
      </code>
      ,
      <code class="literal">
       COPY_TO_SAVE
      </code>
      , or
      <code class="literal">
       GET_TABINFO
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       tab_update_status
      </code>
     </p>
     <p>
      Status of updating of table distribution data; one of
      <code class="literal">
       IDLE
      </code>
      ,
      <code class="literal">
       LOCAL_CHECKPOINT
      </code>
      ,
      <code class="literal">
       LOCAL_CHECKPOINT_QUEUED
      </code>
      ,
      <code class="literal">
       REMOVE_NODE
      </code>
      ,
      <code class="literal">
       COPY_TAB_REQ
      </code>
      ,
      <code class="literal">
       ADD_TABLE_MASTER
      </code>
      ,
      <code class="literal">
       ADD_TABLE_SLAVE
      </code>
      ,
      <code class="literal">
       INVALIDATE_NODE_LCP
      </code>
      , or
      <code class="literal">
       CALLBACK
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       tab_lcp_status
      </code>
     </p>
     <p>
      Status of table LCP; one of
      <code class="literal">
       ACTIVE
      </code>
      (waiting for local checkpoint to be performed),
      <code class="literal">
       WRITING_TO_FILE
      </code>
      (checkpoint performed but
            not yet written to disk), or
      <code class="literal">
       COMPLETED
      </code>
      (checkpoint performed and persisted to disk)
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       tab_status
      </code>
     </p>
     <p>
      Table internal status; one of
      <code class="literal">
       ACTIVE
      </code>
      (table exists),
      <code class="literal">
       CREATING
      </code>
      (table is being
            created), or
      <code class="literal">
       DROPPING
      </code>
      (table is being
            dropped)
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       tab_storage
      </code>
     </p>
     <p>
      Table recoverability; one of
      <code class="literal">
       NORMAL
      </code>
      (fully recoverable with redo logging and checkpointing),
      <code class="literal">
       NOLOGGING
      </code>
      (recoverable from node crash,
            empty following cluster crash), or
      <code class="literal">
       TEMPORARY
      </code>
      (not recoverable)
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       tab_partitions
      </code>
     </p>
     <p>
      Number of partitions in table
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       tab_fragments
      </code>
     </p>
     <p>
      Number of fragments in table; normally same as
      <code class="literal">
       tab_partitions
      </code>
      ; for fully replicated
            tables equal to
      <code class="literal">
       tab_partitions * [number of node
            groups]
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       current_scan_count
      </code>
     </p>
     <p>
      Current number of active scans
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       scan_count_wait
      </code>
     </p>
     <p>
      Current number of scans waiting to be performed before
      <code class="literal">
       ALTER TABLE
      </code>
      can complete.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       is_reorg_ongoing
      </code>
     </p>
     <p>
      Whether the table is currently being reorganized (1 if true)
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
