<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="performance-schema-replication-applier-status-by-coordinator-table">
      </a>
      29.12.11.6 The replication_applier_status_by_coordinator Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045071427904">
  </a>
  <a class="indexterm" name="idm46045071426384">
  </a>
  <p>
   For a multithreaded replica, the replica uses multiple worker
          threads and a coordinator thread to manage them, and this
          table shows the status of the coordinator thread. For a
          single-threaded replica, this table is empty. For a
          multithreaded replica, 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 the status of the worker threads. This table
          provides information about the last transaction which was
          buffered by the coordinator thread to a worker’s queue, as
          well as the transaction it is currently buffering. The start
          timestamp refers to when this thread read the first event of
          the transaction from the relay log to buffer it to a
          worker’s queue, while the end timestamp refers to when the
          last event finished buffering to the worker’s queue.
  </p>
  <p>
   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 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">
       THREAD_ID
      </code>
     </p>
     <p>
      The SQL/coordinator thread ID.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       SERVICE_STATE
      </code>
     </p>
     <p>
      <code class="literal">
       ON
      </code>
      (thread exists and is active or
              idle) or
      <code class="literal">
       OFF
      </code>
      (thread no longer exists).
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       LAST_ERROR_NUMBER
      </code>
      ,
      <code class="literal">
       LAST_ERROR_MESSAGE
      </code>
     </p>
     <p>
      The error number and error message of the most recent
              error that caused the SQL/coordinator thread to stop. An
              error number of 0 and message which is an empty string
              means
      <span class="quote">
       “
       <span class="quote">
        no error
       </span>
       ”
      </span>
      . If the
      <code class="literal">
       LAST_ERROR_MESSAGE
      </code>
      value is not empty,
              the error values also appear in the replica's error
              log.
     </p>
     <p>
      Issuing
      <a class="link" href="reset-binary-logs-and-gtids.html" title="15.4.1.2 RESET BINARY LOGS AND GTIDS Statement">
       <code class="literal">
        RESET BINARY LOGS AND
              GTIDS
       </code>
      </a>
      or
      <a class="link" href="reset-replica.html" title="15.4.2.3 RESET REPLICA Statement">
       <code class="literal">
        RESET
              REPLICA
       </code>
      </a>
      resets the values shown in these
              columns.
     </p>
     <p>
      All error codes and messages displayed in the
      <code class="literal">
       LAST_ERROR_NUMBER
      </code>
      and
      <code class="literal">
       LAST_ERROR_MESSAGE
      </code>
      columns correspond
              to error values listed in
      <a class="ulink" href="/doc/mysql-errors/8.4/en/server-error-reference.html" target="_top">
       Server Error Message Reference
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       LAST_ERROR_TIMESTAMP
      </code>
     </p>
     <p>
      A timestamp in
      <code class="literal">
       '
       <em class="replaceable">
        <code>
         YYYY-MM-DD
              hh:mm:ss
        </code>
       </em>
       [.
       <em class="replaceable">
        <code>
         fraction
        </code>
       </em>
       ]'
      </code>
      format that shows when the most recent SQL/coordinator
              error occurred.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       LAST_PROCESSED_TRANSACTION
      </code>
     </p>
     <p>
      The global transaction ID (GTID) of the last transaction
              processed by this coordinator.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       LAST_PROCESSED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP
      </code>
     </p>
     <p>
      A timestamp in
      <code class="literal">
       '
       <em class="replaceable">
        <code>
         YYYY-MM-DD
              hh:mm:ss
        </code>
       </em>
       [.
       <em class="replaceable">
        <code>
         fraction
        </code>
       </em>
       ]'
      </code>
      format that shows when the last transaction processed by
              this coordinator was committed on the original source.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       LAST_PROCESSED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP
      </code>
     </p>
     <p>
      A timestamp in
      <code class="literal">
       '
       <em class="replaceable">
        <code>
         YYYY-MM-DD
              hh:mm:ss
        </code>
       </em>
       [.
       <em class="replaceable">
        <code>
         fraction
        </code>
       </em>
       ]'
      </code>
      format that shows when the last transaction processed by
              this coordinator was committed on the immediate source.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       LAST_PROCESSED_TRANSACTION_START_BUFFER_TIMESTAMP
      </code>
     </p>
     <p>
      A timestamp in
      <code class="literal">
       '
       <em class="replaceable">
        <code>
         YYYY-MM-DD
              hh:mm:ss
        </code>
       </em>
       [.
       <em class="replaceable">
        <code>
         fraction
        </code>
       </em>
       ]'
      </code>
      format that shows when this coordinator thread started
              writing the last transaction to the buffer of a worker
              thread.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       LAST_PROCESSED_TRANSACTION_END_BUFFER_TIMESTAMP
      </code>
     </p>
     <p>
      A timestamp in
      <code class="literal">
       '
       <em class="replaceable">
        <code>
         YYYY-MM-DD
              hh:mm:ss
        </code>
       </em>
       [.
       <em class="replaceable">
        <code>
         fraction
        </code>
       </em>
       ]'
      </code>
      format that shows when the last transaction was written to
              the buffer of a worker thread by this coordinator thread.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       PROCESSING_TRANSACTION
      </code>
     </p>
     <p>
      The global transaction ID (GTID) of the transaction that
              this coordinator thread is currently processing.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       PROCESSING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP
      </code>
     </p>
     <p>
      A timestamp in
      <code class="literal">
       '
       <em class="replaceable">
        <code>
         YYYY-MM-DD
              hh:mm:ss
        </code>
       </em>
       [.
       <em class="replaceable">
        <code>
         fraction
        </code>
       </em>
       ]'
      </code>
      format that shows when the currently processing
              transaction was committed on the original source.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       PROCESSING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP
      </code>
     </p>
     <p>
      A timestamp in
      <code class="literal">
       '
       <em class="replaceable">
        <code>
         YYYY-MM-DD
              hh:mm:ss
        </code>
       </em>
       [.
       <em class="replaceable">
        <code>
         fraction
        </code>
       </em>
       ]'
      </code>
      format that shows when the currently processing
              transaction was committed on the immediate source.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       PROCESSING_TRANSACTION_START_BUFFER_TIMESTAMP
      </code>
     </p>
     <p>
      A timestamp in
      <code class="literal">
       '
       <em class="replaceable">
        <code>
         YYYY-MM-DD
              hh:mm:ss
        </code>
       </em>
       [.
       <em class="replaceable">
        <code>
         fraction
        </code>
       </em>
       ]'
      </code>
      format that shows when this coordinator thread started
              writing the currently processing transaction to the buffer
              of a worker thread.
     </p>
    </li>
   </ul>
  </div>
  <p>
   When the Performance Schema is disabled, local timing
          information is not collected, so the fields showing the start
          and end timestamps for buffered transactions are zero.
  </p>
  <p>
   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 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>
    <li class="listitem">
     <p>
      Index on (
      <code class="literal">
       THREAD_ID
      </code>
      )
     </p>
    </li>
   </ul>
  </div>
  <p>
   The following table shows the correspondence between
   <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>
   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_by_coordinator 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_by_coordinator
       </code>
       Column
      </th>
      <th>
       <code class="literal">
        SHOW REPLICA STATUS
       </code>
       Column
      </th>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td>
       <code class="literal">
        THREAD_ID
       </code>
      </td>
      <td>
       None
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        SERVICE_STATE
       </code>
      </td>
      <td>
       <code class="literal">
        Replica_SQL_Running
       </code>
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        LAST_ERROR_NUMBER
       </code>
      </td>
      <td>
       <code class="literal">
        Last_SQL_Errno
       </code>
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        LAST_ERROR_MESSAGE
       </code>
      </td>
      <td>
       <code class="literal">
        Last_SQL_Error
       </code>
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        LAST_ERROR_TIMESTAMP
       </code>
      </td>
      <td>
       <code class="literal">
        Last_SQL_Error_Timestamp
       </code>
      </td>
     </tr>
    </tbody>
   </table>
  </div>
 </div>
 <br/>
</div>
