<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="mysql-cluster-ndbinfo-table-replicas">
      </a>
      25.6.17.60 The ndbinfo table_replicas Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045087665184">
  </a>
  <p>
   The
   <code class="literal">
    table_replicas
   </code>
   table provides information
        about the copying, distribution, and checkpointing of
   <code class="literal">
    NDB
   </code>
   table fragments and fragment replicas.
  </p>
  <p>
   The
   <code class="literal">
    table_replicas
   </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>
      ID of the node from which data is fetched
            (
      <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">
       fragment_id
      </code>
     </p>
     <p>
      Fragment ID
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       initial_gci
      </code>
     </p>
     <p>
      Initial GCI for table
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       replica_node_id
      </code>
     </p>
     <p>
      ID of node where fragment replica is stored
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       is_lcp_ongoing
      </code>
     </p>
     <p>
      Is 1 if LCP is ongoing on this fragment, 0 otherwise
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       num_crashed_replicas
      </code>
     </p>
     <p>
      Number of crashed fragment replica instances
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       last_max_gci_started
      </code>
     </p>
     <p>
      Highest GCI started in most recent LCP
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       last_max_gci_completed
      </code>
     </p>
     <p>
      Highest GCI completed in most recent LCP
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       last_lcp_id
      </code>
     </p>
     <p>
      ID of most recent LCP
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       prev_lcp_id
      </code>
     </p>
     <p>
      ID of previous LCP
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       prev_max_gci_started
      </code>
     </p>
     <p>
      Highest GCI started in previous LCP
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       prev_max_gci_completed
      </code>
     </p>
     <p>
      Highest GCI completed in previous LCP
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       last_create_gci
      </code>
     </p>
     <p>
      Last Create GCI of last crashed fragment replica instance
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       last_replica_gci
      </code>
     </p>
     <p>
      Last GCI of last crashed fragment replica instance
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       is_replica_alive
      </code>
     </p>
     <p>
      1 if this fragment replica is alive, 0 otherwise
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
