<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="mysql-cluster-ndbinfo-table-fragments">
      </a>
      25.6.17.58 The ndbinfo table_fragments Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045087730832">
  </a>
  <p>
   The
   <code class="literal">
    table_fragments
   </code>
   table provides
        information about the fragmentation, partitioning, distribution,
        and (internal) replication of
   <code class="literal">
    NDB
   </code>
   tables.
  </p>
  <p>
   The
   <code class="literal">
    table_fragments
   </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 (
      <a class="ulink" href="/doc/ndb-internals/en/ndb-internals-kernel-blocks-dbdih.html" target="_top">
       <code class="literal">
        DIH
       </code>
      </a>
      master)
     </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">
       partition_id
      </code>
     </p>
     <p>
      Partition ID
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       fragment_id
      </code>
     </p>
     <p>
      Fragment ID (same as partition ID unless table is fully
            replicated)
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       partition_order
      </code>
     </p>
     <p>
      Order of fragment in partition
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       log_part_id
      </code>
     </p>
     <p>
      Log part ID of fragment
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       no_of_replicas
      </code>
     </p>
     <p>
      Number of fragment replicas
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       current_primary
      </code>
     </p>
     <p>
      Current primary node ID
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       preferred_primary
      </code>
     </p>
     <p>
      Preferred primary node ID
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       current_first_backup
      </code>
     </p>
     <p>
      Current first backup node ID
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       current_second_backup
      </code>
     </p>
     <p>
      Current second backup node ID
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       current_third_backup
      </code>
     </p>
     <p>
      Current third backup node ID
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       num_alive_replicas
      </code>
     </p>
     <p>
      Current number of live fragment replicas
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       num_dead_replicas
      </code>
     </p>
     <p>
      Current number of dead fragment replicas
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       num_lcp_replicas
      </code>
     </p>
     <p>
      Number of fragment replicas remaining to be checkpointed
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
