<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="performance-schema-replication-applier-configuration-table">
      </a>
      29.12.11.2 The replication_applier_configuration Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045071586032">
  </a>
  <a class="indexterm" name="idm46045071584528">
  </a>
  <p>
   This table shows the configuration parameters that affect
          transactions applied by the replica. Parameters stored in the
          table can be changed at runtime with the
   <a class="link" href="change-replication-source-to.html" title="15.4.2.2 CHANGE REPLICATION SOURCE TO Statement">
    <code class="literal">
     CHANGE REPLICATION SOURCE TO
    </code>
   </a>
   statement.
  </p>
  <p>
   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 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">
       DESIRED_DELAY
      </code>
     </p>
     <p>
      The number of seconds that the replica must lag the source
              (
      <code class="literal">
       CHANGE REPLICATION SOURCE TO
      </code>
      option:
      <code class="literal">
       SOURCE_DELAY
      </code>
      ). 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">
       PRIVILEGE_CHECKS_USER
      </code>
     </p>
     <p>
      The user account that provides the security context for
              the channel (
      <code class="literal">
       CHANGE REPLICATION SOURCE
              TO
      </code>
      option:
      <code class="literal">
       PRIVILEGE_CHECKS_USER
      </code>
      ). This is escaped
              so that it can be copied into an SQL statement to execute
              individual transactions. See
      <a class="xref" href="replication-privilege-checks.html" title="19.3.3 Replication Privilege Checks">
       Section 19.3.3, “Replication Privilege Checks”
      </a>
      for more
              information.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       REQUIRE_ROW_FORMAT
      </code>
     </p>
     <p>
      Whether the channel accepts only row-based events
              (
      <code class="literal">
       CHANGE REPLICATION SOURCE TO
      </code>
      option:
      <code class="literal">
       REQUIRE_ROW_FORMAT
      </code>
      ). See
      <a class="xref" href="replication-privilege-checks.html" title="19.3.3 Replication Privilege Checks">
       Section 19.3.3, “Replication Privilege Checks”
      </a>
      for more
              information.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       REQUIRE_TABLE_PRIMARY_KEY_CHECK
      </code>
     </p>
     <p>
      Whether the channel requires primary keys always, never,
              or according to the source's setting (
      <code class="literal">
       CHANGE
              REPLICATION SOURCE TO
      </code>
      option:
      <code class="literal">
       REQUIRE_TABLE_PRIMARY_KEY_CHECK
      </code>
      ). See
      <a class="xref" href="replication-privilege-checks.html" title="19.3.3 Replication Privilege Checks">
       Section 19.3.3, “Replication Privilege Checks”
      </a>
      for more
              information.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_TYPE
      </code>
     </p>
     <p>
      Whether the channel assigns a GTID to replicated
              transactions that do not already have one (
      <code class="literal">
       CHANGE
              REPLICATION SOURCE TO
      </code>
      option:
      <code class="literal">
       ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS
      </code>
      ).
      <code class="literal">
       OFF
      </code>
      means no GTIDs are assigned.
      <code class="literal">
       LOCAL
      </code>
      means a GTID is assigned that
              includes the replica's own UUID (the
      <a class="link" href="replication-options.html#sysvar_server_uuid">
       <code class="literal">
        server_uuid
       </code>
      </a>
      setting).
      <code class="literal">
       UUID
      </code>
      means a GTID is assigned that
              includes a manually set UUID. See
      <a class="xref" href="replication-gtids-assign-anon.html" title="19.1.3.6 Replication From a Source Without GTIDs to a Replica With GTIDs">
       Section 19.1.3.6, “Replication From a Source Without GTIDs to a Replica With GTIDs”
      </a>
      for more
              information.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_VALUE
      </code>
     </p>
     <p>
      The UUID that is used as part of the GTIDs assigned to
              anonymous transactions (
      <code class="literal">
       CHANGE REPLICATION SOURCE
              TO
      </code>
      option:
      <code class="literal">
       ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS
      </code>
      ).
              See
      <a class="xref" href="replication-gtids-assign-anon.html" title="19.1.3.6 Replication From a Source Without GTIDs to a Replica With GTIDs">
       Section 19.1.3.6, “Replication From a Source Without GTIDs to a Replica With GTIDs”
      </a>
      for
              more information.
     </p>
    </li>
   </ul>
  </div>
  <p>
   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 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-configuration-table.html" title="29.12.11.2 The replication_applier_configuration Table">
    <code class="literal">
     replication_applier_configuration
    </code>
   </a>
   table.
  </p>
  <p>
   The following table shows the correspondence between
   <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>
   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_configuration columns and SHOW REPLICA STATUS columns">
    <colgroup>
     <col style="width: 60%"/>
     <col style="width: 40%"/>
    </colgroup>
    <thead>
     <tr>
      <th>
       <code class="literal">
        replication_applier_configuration
       </code>
       Column
      </th>
      <th>
       <code class="literal">
        SHOW REPLICA STATUS
       </code>
       Column
      </th>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td>
       <code class="literal">
        DESIRED_DELAY
       </code>
      </td>
      <td>
       <code class="literal">
        SQL_Delay
       </code>
      </td>
     </tr>
    </tbody>
   </table>
  </div>
 </div>
 <br/>
</div>
