<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="performance-schema-replication-group-member-stats-table">
      </a>
      29.12.11.15 The replication_group_member_stats Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045070748880">
  </a>
  <a class="indexterm" name="idm46045070747376">
  </a>
  <p>
   This table shows statistical information for replication group
          members. It is populated only when Group Replication is
          running.
  </p>
  <p>
   The
   <code class="literal">
    replication_group_member_stats
   </code>
   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>
      Name of the Group Replication channel
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       VIEW_ID
      </code>
     </p>
     <p>
      Current view identifier for this group.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       MEMBER_ID
      </code>
     </p>
     <p>
      The member server UUID. This has a different value for
              each member in the group. This also serves as a key
              because it is unique to each member.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       COUNT_TRANSACTIONS_IN_QUEUE
      </code>
     </p>
     <p>
      The number of transactions in the queue pending conflict
              detection checks. Once the transactions have been checked
              for conflicts, if they pass the check, they are queued to
              be applied as well.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       COUNT_TRANSACTIONS_CHECKED
      </code>
     </p>
     <p>
      The number of transactions that have been checked for
              conflicts.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       COUNT_CONFLICTS_DETECTED
      </code>
     </p>
     <p>
      The number of transactions that have not passed the
              conflict detection check.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       COUNT_TRANSACTIONS_ROWS_VALIDATING
      </code>
     </p>
     <p>
      Number of transaction rows which can be used for
              certification, but have not been garbage collected. Can be
              thought of as the current size of the conflict detection
              database against which each transaction is certified.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       TRANSACTIONS_COMMITTED_ALL_MEMBERS
      </code>
     </p>
     <p>
      The transactions that have been successfully committed on
              all members of the replication group, shown as
      <a class="xref" href="replication-gtids-concepts.html#replication-gtids-concepts-gtid-sets" title="GTID Sets">
       GTID Sets
      </a>
      .
              This is updated at a fixed time interval.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       LAST_CONFLICT_FREE_TRANSACTION
      </code>
     </p>
     <p>
      The transaction identifier of the last conflict free
              transaction which was checked.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE
      </code>
     </p>
     <p>
      The number of transactions that this member has received
              from the replication group which are waiting to be
              applied.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       COUNT_TRANSACTIONS_REMOTE_APPLIED
      </code>
     </p>
     <p>
      Number of transactions this member has received from the
              group and applied.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       COUNT_TRANSACTIONS_LOCAL_PROPOSED
      </code>
     </p>
     <p>
      Number of transactions which originated on this member and
              were sent to the group.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       COUNT_TRANSACTIONS_LOCAL_ROLLBACK
      </code>
     </p>
     <p>
      Number of transactions which originated on this member and
              were rolled back by the group.
     </p>
    </li>
   </ul>
  </div>
  <p>
   The
   <a class="link" href="performance-schema-replication-group-member-stats-table.html" title="29.12.11.15 The replication_group_member_stats Table">
    <code class="literal">
     replication_group_member_stats
    </code>
   </a>
   table has no indexes.
  </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-replication-group-member-stats-table.html" title="29.12.11.15 The replication_group_member_stats Table">
    <code class="literal">
     replication_group_member_stats
    </code>
   </a>
   table.
  </p>
 </div>
 <br/>
</div>
