<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="performance-schema-replication-applier-status-table">
      </a>
      29.12.11.5 The replication_applier_status Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045071476832">
  </a>
  <a class="indexterm" name="idm46045071475328">
  </a>
  <p>
   This table shows the current general transaction execution
          status on the replica. The table provides information about
          general aspects of transaction applier status that are not
          specific to any thread involved. Thread-specific status
          information is available in the
   <a class="link" href="performance-schema-replication-applier-status-by-coordinator-table.html" title="29.12.11.6 The replication_applier_status_by_coordinator Table">
    <code class="literal">
     replication_applier_status_by_coordinator
    </code>
   </a>
   table (and
   <a class="link" href="performance-schema-replication-applier-status-by-worker-table.html" title="29.12.11.7 The replication_applier_status_by_worker Table">
    <code class="literal">
     replication_applier_status_by_worker
    </code>
   </a>
   if the replica is multithreaded).
  </p>
  <p>
   The
   <a class="link" href="performance-schema-replication-applier-status-table.html" title="29.12.11.5 The replication_applier_status Table">
    <code class="literal">
     replication_applier_status
    </code>
   </a>
   table has these columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       CHANNEL_NAME
      </code>
     </p>
     <p>
      The replication channel which this row is displaying.
              There is always a default replication channel, and more
              replication channels can be added. See
      <a class="xref" href="replication-channels.html" title="19.2.2 Replication Channels">
       Section 19.2.2, “Replication Channels”
      </a>
      for more
              information.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       SERVICE_STATE
      </code>
     </p>
     <p>
      Shows
      <code class="literal">
       ON
      </code>
      when the replication
              channel's applier threads are active or idle,
      <code class="literal">
       OFF
      </code>
      means that the applier threads are
              not active.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       REMAINING_DELAY
      </code>
     </p>
     <p>
      If the replica is waiting for
      <code class="literal">
       DESIRED_DELAY
      </code>
      seconds to pass since the
              source applied a transaction, this field contains the
              number of delay seconds remaining. At other times, this
              field is
      <code class="literal">
       NULL
      </code>
      . (The
      <code class="literal">
       DESIRED_DELAY
      </code>
      value is stored in the
      <a class="link" href="performance-schema-replication-applier-configuration-table.html" title="29.12.11.2 The replication_applier_configuration Table">
       <code class="literal">
        replication_applier_configuration
       </code>
      </a>
      table.) See
      <a class="xref" href="replication-delayed.html" title="19.4.11 Delayed Replication">
       Section 19.4.11, “Delayed Replication”
      </a>
      for more
              information.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       COUNT_TRANSACTIONS_RETRIES
      </code>
     </p>
     <p>
      Shows the number of retries that were made because the
              replication SQL thread failed to apply a transaction. The
              maximum number of retries for a given transaction is set
              by the system variable
      <a class="link" href="replication-options-replica.html#sysvar_replica_transaction_retries">
       <code class="literal">
        replica_transaction_retries
       </code>
      </a>
      .
              The
      <a class="link" href="performance-schema-replication-applier-status-by-worker-table.html" title="29.12.11.7 The replication_applier_status_by_worker Table">
       <code class="literal">
        replication_applier_status_by_worker
       </code>
      </a>
      table shows detailed information on transaction retries
              for a single-threaded or multithreaded replica.
     </p>
    </li>
   </ul>
  </div>
  <p>
   The
   <a class="link" href="performance-schema-replication-applier-status-table.html" title="29.12.11.5 The replication_applier_status Table">
    <code class="literal">
     replication_applier_status
    </code>
   </a>
   table has these indexes:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      Primary key on (
      <code class="literal">
       CHANNEL_NAME
      </code>
      )
     </p>
    </li>
   </ul>
  </div>
  <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-replication-applier-status-table.html" title="29.12.11.5 The replication_applier_status Table">
    <code class="literal">
     replication_applier_status
    </code>
   </a>
   table.
  </p>
  <p>
   The following table shows the correspondence between
   <a class="link" href="performance-schema-replication-applier-status-table.html" title="29.12.11.5 The replication_applier_status Table">
    <code class="literal">
     replication_applier_status
    </code>
   </a>
   columns and
   <a class="link" href="show-replica-status.html" title="15.7.7.35 SHOW REPLICA STATUS Statement">
    <code class="literal">
     SHOW
          REPLICA STATUS
    </code>
   </a>
   columns.
  </p>
  <div class="informaltable">
   <table summary="Correspondence between replication_applier_status columns and SHOW REPLICA STATUS columns">
    <colgroup>
     <col style="width: 60%"/>
     <col style="width: 40%"/>
    </colgroup>
    <thead>
     <tr>
      <th>
       <code class="literal">
        replication_applier_status
       </code>
       Column
      </th>
      <th>
       <code class="literal">
        SHOW REPLICA STATUS
       </code>
       Column
      </th>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td>
       <code class="literal">
        SERVICE_STATE
       </code>
      </td>
      <td>
       None
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        REMAINING_DELAY
       </code>
      </td>
      <td>
       <code class="literal">
        SQL_Remaining_Delay
       </code>
      </td>
     </tr>
    </tbody>
   </table>
  </div>
 </div>
 <br/>
</div>
