<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="performance-schema-log-status-table">
      </a>
      29.12.22.5 The log_status Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045067454416">
  </a>
  <a class="indexterm" name="idm46045067452928">
  </a>
  <p>
   The
   <a class="link" href="performance-schema-log-status-table.html" title="29.12.22.5 The log_status Table">
    <code class="literal">
     log_status
    </code>
   </a>
   table provides
          information that enables an online backup tool to copy the
          required log files without locking those resources for the
          duration of the copy process.
  </p>
  <p>
   When the
   <a class="link" href="performance-schema-log-status-table.html" title="29.12.22.5 The log_status Table">
    <code class="literal">
     log_status
    </code>
   </a>
   table is
          queried, the server blocks logging and related administrative
          changes for just long enough to populate the table, then
          releases the resources. The
   <a class="link" href="performance-schema-log-status-table.html" title="29.12.22.5 The log_status Table">
    <code class="literal">
     log_status
    </code>
   </a>
   table informs the
          online backup which point it should copy up to in the source's
          binary log and
   <code class="literal">
    gtid_executed
   </code>
   record, and
          the relay log for each replication channel. It also provides
          relevant information for individual storage engines, such as
          the last log sequence number (LSN) and the LSN of the last
          checkpoint taken for the
   <code class="literal">
    InnoDB
   </code>
   storage
          engine.
  </p>
  <p>
   The
   <code class="literal">
    log_status
   </code>
   table has these columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       SERVER_UUID
      </code>
     </p>
     <p>
      The server UUID for this server instance. This is the
              generated unique value of the read-only system variable
      <a class="link" href="replication-options.html#sysvar_server_uuid">
       <code class="literal">
        server_uuid
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       LOCAL
      </code>
     </p>
     <p>
      The log position state information from the source,
              provided as a single JSON object with the following keys:
     </p>
     <div class="variablelist">
      <dl class="variablelist">
       <dt>
        <span class="term">
         <code class="literal">
          binary_log_file
         </code>
        </span>
       </dt>
       <dd>
        <p>
         The name of the current binary log file.
        </p>
       </dd>
       <dt>
        <span class="term">
         <code class="literal">
          binary_log_position
         </code>
        </span>
       </dt>
       <dd>
        <p>
         The current binary log position at the time the
         <code class="literal">
          log_status
         </code>
         table was accessed.
        </p>
       </dd>
       <dt>
        <span class="term">
         <code class="literal">
          gtid_executed
         </code>
        </span>
       </dt>
       <dd>
        <p>
         The current value of the global server variable
         <a class="link" href="replication-options-gtids.html#sysvar_gtid_executed">
          <code class="literal">
           gtid_executed
          </code>
         </a>
         at
                      the time the
         <code class="literal">
          log_status
         </code>
         table
                      was accessed. This information is consistent with
                      the
         <code class="literal">
          binary_log_file
         </code>
         and
         <code class="literal">
          binary_log_position
         </code>
         keys.
        </p>
       </dd>
      </dl>
     </div>
     <p>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       REPLICATION
      </code>
     </p>
     <p>
      A JSON array of channels, each with the following
              information:
     </p>
     <div class="variablelist">
      <dl class="variablelist">
       <dt>
        <span class="term">
         <code class="literal">
          channel_name
         </code>
        </span>
       </dt>
       <dd>
        <p>
         The name of the replication channel. The default
                      replication channel's name is the empty string
                      (
         <span class="quote">
          “
          <span class="quote">
          </span>
          ”
         </span>
         ).
        </p>
       </dd>
       <dt>
        <span class="term">
         <code class="literal">
          relay_log_file
         </code>
        </span>
       </dt>
       <dd>
        <p>
         The name of the current relay log file for the
                      replication channel.
        </p>
       </dd>
       <dt>
        <span class="term">
         <code class="literal">
          relay_log_pos
         </code>
        </span>
       </dt>
       <dd>
        <p>
         The current relay log position at the time the
         <code class="literal">
          log_status
         </code>
         table was accessed.
        </p>
       </dd>
      </dl>
     </div>
     <p>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       STORAGE_ENGINES
      </code>
     </p>
     <p>
      Relevant information from individual storage engines,
              provided as a JSON object with one key for each applicable
              storage engine.
     </p>
    </li>
   </ul>
  </div>
  <p>
   The
   <a class="link" href="performance-schema-log-status-table.html" title="29.12.22.5 The log_status Table">
    <code class="literal">
     log_status
    </code>
   </a>
   table has no
          indexes.
  </p>
  <p>
   The
   <code class="literal">
    BACKUP_ADMIN
   </code>
   privilege, as well as the
   <code class="literal">
    SELECT
   </code>
   privilege, is required for access to
          the
   <a class="link" href="performance-schema-log-status-table.html" title="29.12.22.5 The log_status Table">
    <code class="literal">
     log_status
    </code>
   </a>
   table.
  </p>
  <p>
   <a class="link" href="truncate-table.html" title="15.1.37 TRUNCATE TABLE Statement">
    <code class="literal">
     TRUNCATE TABLE
    </code>
   </a>
   is not permitted
          for the
   <a class="link" href="performance-schema-log-status-table.html" title="29.12.22.5 The log_status Table">
    <code class="literal">
     log_status
    </code>
   </a>
   table.
  </p>
 </div>
 <br/>
</div>
