<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="performance-schema-innodb-redo-log-files-table">
      </a>
      29.12.22.4 The innodb_redo_log_files Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045067477552">
  </a>
  <a class="indexterm" name="idm46045067476048">
  </a>
  <p>
   The
   <code class="literal">
    innodb_redo_log_files
   </code>
   table contains a
          row for each active
   <code class="literal">
    InnoDB
   </code>
   redo log file.
  </p>
  <p>
   The
   <code class="literal">
    innodb_redo_log_files
   </code>
   table has the
          following columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       FILE_ID
      </code>
     </p>
     <p>
      The ID of the redo log file. The value corresponds to the
              redo log file number.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       FILE_NAME
      </code>
     </p>
     <p>
      The path and file name of the redo log file.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       START_LSN
      </code>
     </p>
     <p>
      The log sequence number of the first block in the redo log
              file.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       END_LSN
      </code>
     </p>
     <p>
      The log sequence number after the last block in the redo
              log file.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       SIZE_IN_BYTES
      </code>
     </p>
     <p>
      The size of the redo log data in the file, in bytes. Data
              size is measured from the
      <code class="literal">
       END_LSN
      </code>
      to
              the start
      <code class="literal">
       &gt;START_LSN
      </code>
      . The redo log file
              size on disk is slightly larger due to the file header
              (2048 bytes), which is not included in the value reported
              by this column.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       IS_FULL
      </code>
     </p>
     <p>
      Whether the redo log file is full. A value of 0 indicates
              that free space in the file. A value of 1 indicates that
              the file is full.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       CONSUMER_LEVEL
      </code>
     </p>
     <p>
      Reserved for future use.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
