<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="mysql-cluster-ndbinfo-files">
      </a>
      25.6.17.36 The ndbinfo files Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045089241312">
  </a>
  <p>
   The
   <code class="literal">
    files
   </code>
   tables provides information about
        files and other objects used by
   <code class="literal">
    NDB
   </code>
   disk data
        tables, and contains the columns listed here:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       id
      </code>
     </p>
     <p>
      Object ID
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       type
      </code>
     </p>
     <p>
      The type of object; one of
      <code class="literal">
       Log file
            group
      </code>
      ,
      <code class="literal">
       Tablespace
      </code>
      ,
      <code class="literal">
       Undo file
      </code>
      , or
      <code class="literal">
       Data
            file
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       name
      </code>
     </p>
     <p>
      The name of the object
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       parent
      </code>
     </p>
     <p>
      ID of the parent object
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       parent_name
      </code>
     </p>
     <p>
      Name of the parent object
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       free_extents
      </code>
     </p>
     <p>
      Number of free extents
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       total_extents
      </code>
     </p>
     <p>
      Total number of extents
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       extent_size
      </code>
     </p>
     <p>
      Extent size (MB)
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       initial_size
      </code>
     </p>
     <p>
      Initial size (bytes)
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       maximum_size
      </code>
     </p>
     <p>
      Maximum size (bytes)
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       autoextend_size
      </code>
     </p>
     <p>
      Autoextend size (bytes)
     </p>
    </li>
   </ul>
  </div>
  <p>
   For log file groups and tablespaces,
   <code class="literal">
    parent
   </code>
   is always
   <code class="literal">
    0
   </code>
   , and the
   <code class="literal">
    parent_name
   </code>
   ,
   <code class="literal">
    free_extents
   </code>
   ,
   <code class="literal">
    total_extents
   </code>
   ,
   <code class="literal">
    extent_size
   </code>
   ,
   <code class="literal">
    initial_size
   </code>
   ,
   <code class="literal">
    maximum_size
   </code>
   , and
   <code class="literal">
    autoentend_size
   </code>
   columns are all
   <code class="literal">
    NULL
   </code>
   .
  </p>
  <p>
   The
   <code class="literal">
    files
   </code>
   table is empty if no disk data
        objects have been created in
   <code class="literal">
    NDB
   </code>
   . See
   <a class="xref" href="mysql-cluster-disk-data-objects.html" title="25.6.11.1 NDB Cluster Disk Data Objects">
    Section 25.6.11.1, “NDB Cluster Disk Data Objects”
   </a>
   , for more
        information.
  </p>
  <p>
   See also
   <a class="xref" href="information-schema-files-table.html" title="28.3.15 The INFORMATION_SCHEMA FILES Table">
    Section 28.3.15, “The INFORMATION_SCHEMA FILES Table”
   </a>
   .
  </p>
 </div>
 <br/>
</div>
