<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="mysql-cluster-ndbinfo-logbuffers">
      </a>
      25.6.17.43 The ndbinfo logbuffers Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045089006976">
  </a>
  <p>
   The
   <code class="literal">
    logbuffer
   </code>
   table provides information on
        NDB Cluster log buffer usage.
  </p>
  <p>
   The
   <code class="literal">
    logbuffers
   </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>
      The ID of this data node.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       log_type
      </code>
     </p>
     <p>
      Type of log. One of:
      <code class="literal">
       REDO
      </code>
      ,
      <code class="literal">
       DD-UNDO
      </code>
      ,
      <code class="literal">
       BACKUP-DATA
      </code>
      ,
            or
      <code class="literal">
       BACKUP-LOG
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       log_id
      </code>
     </p>
     <p>
      The log ID; for Disk Data undo log files, this is the same
            as the value shown in the
      <code class="literal">
       LOGFILE_GROUP_NUMBER
      </code>
      column of the
            Information Schema
      <a class="link" href="information-schema-files-table.html" title="28.3.15 The INFORMATION_SCHEMA FILES Table">
       <code class="literal">
        FILES
       </code>
      </a>
      table
            as well as the value shown for the
      <code class="literal">
       log_id
      </code>
      column of the
      <code class="literal">
       ndbinfo
      </code>
      <a class="link" href="mysql-cluster-ndbinfo-logspaces.html" title="25.6.17.44 The ndbinfo logspaces Table">
       <code class="literal">
        logspaces
       </code>
      </a>
      table
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       log_part
      </code>
     </p>
     <p>
      The log part number
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       total
      </code>
     </p>
     <p>
      Total space available for this log
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       used
      </code>
     </p>
     <p>
      Space used by this log
     </p>
    </li>
   </ul>
  </div>
  <h5>
   <a name="idm46045088983600">
   </a>
   Notes
  </h5>
  <p>
   <code class="literal">
    logbuffers
   </code>
   table rows reflecting two
        additional log types are available when performing an NDB
        backup. One of these rows has the log type
   <code class="literal">
    BACKUP-DATA
   </code>
   , which shows the amount of data
        buffer used during backup to copy fragments to backup files. The
        other row has the log type
   <code class="literal">
    BACKUP-LOG
   </code>
   , which
        displays the amount of log buffer used during the backup to
        record changes made after the backup has started. One each of
        these
   <code class="literal">
    log_type
   </code>
   rows is shown in the
   <code class="literal">
    logbuffers
   </code>
   table for each data node in the
        cluster. These rows are not present unless an NDB backup is
        currently being performed.
  </p>
 </div>
 <br/>
</div>
