<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="group-replication-status-variables">
      </a>
      20.9.2 Group Replication Status Variables
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045128446736">
  </a>
  <a class="indexterm" name="idm46045128445248">
  </a>
  <p>
   This section describes the status variables providing information
      about Group Replication.
  </p>
  <p>
   The status variables and their meanings are listed here:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a name="statvar_Gr_all_consensus_proposals_count">
      </a>
      <a class="link" href="group-replication-status-variables.html#statvar_Gr_all_consensus_proposals_count">
       <code class="literal">
        Gr_all_consensus_proposals_count
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045128440048">
     </a>
     <a class="indexterm" name="idm46045128439008">
     </a>
     <p>
      Sum of all proposals that were initiated and terminated on
          this node.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Gr_all_consensus_time_sum">
      </a>
      <a class="link" href="group-replication-status-variables.html#statvar_Gr_all_consensus_time_sum">
       <code class="literal">
        Gr_all_consensus_time_sum
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045128434592">
     </a>
     <a class="indexterm" name="idm46045128433488">
     </a>
     <p>
      The total elapsed time for all consensus rounds started and
          finished on this node. By comparing this value with
      <a class="link" href="group-replication-status-variables.html#statvar_Gr_all_consensus_proposals_count">
       <code class="literal">
        Gr_all_consensus_proposals_count
       </code>
      </a>
      ,
          we can determine whether a given consensus time has an upward
          trend, which may signal a problem.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Gr_certification_garbage_collector_count">
      </a>
      <a class="link" href="group-replication-status-variables.html#statvar_Gr_certification_garbage_collector_count">
       <code class="literal">
        Gr_certification_garbage_collector_count
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045128427520">
     </a>
     <a class="indexterm" name="idm46045128426400">
     </a>
     <p>
      The number of times certification garbage collection has been
          run.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Gr_certification_garbage_collector_time_sum">
      </a>
      <a class="link" href="group-replication-status-variables.html#statvar_Gr_certification_garbage_collector_time_sum">
       <code class="literal">
        Gr_certification_garbage_collector_time_sum
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045128421888">
     </a>
     <a class="indexterm" name="idm46045128420768">
     </a>
     <p>
      Sum of the times in microseconds taken by certification
          garbage collection.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Gr_consensus_bytes_received_sum">
      </a>
      <a class="link" href="group-replication-status-variables.html#statvar_Gr_consensus_bytes_received_sum">
       <code class="literal">
        Gr_consensus_bytes_received_sum
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045128416256">
     </a>
     <a class="indexterm" name="idm46045128415152">
     </a>
     <p>
      The sum of all socket-level bytes received from group nodes
          having this node as a destination.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Gr_consensus_bytes_sent_sum">
      </a>
      <a class="link" href="group-replication-status-variables.html#statvar_Gr_consensus_bytes_sent_sum">
       <code class="literal">
        Gr_consensus_bytes_sent_sum
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045128410704">
     </a>
     <a class="indexterm" name="idm46045128409600">
     </a>
     <p>
      Sum of all socket-level bytes originating on this node that
          were sent to all (other) group nodes. More data is reported
          here than for sent messages, since they are multiplexed and
          sent to each member.
     </p>
     <p>
      For example, if we have a group with three members and we send
          a 100-byte message, this value accounts for 300 bytes, since
          we send 100 bytes to each node.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Gr_control_messages_sent_count">
      </a>
      <a class="link" href="group-replication-status-variables.html#statvar_Gr_control_messages_sent_count">
       <code class="literal">
        Gr_control_messages_sent_count
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045128404368">
     </a>
     <a class="indexterm" name="idm46045128403264">
     </a>
     <p>
      Number of control messages sent by this member.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Gr_control_messages_sent_bytes_sum">
      </a>
      <a class="link" href="group-replication-status-variables.html#statvar_Gr_control_messages_sent_bytes_sum">
       <code class="literal">
        Gr_control_messages_sent_bytes_sum
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045128398688">
     </a>
     <a class="indexterm" name="idm46045128397648">
     </a>
     <p>
      Sum of the number of bytes used in control messages sent by
          this member; this is the on-the-wire size.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Gr_control_messages_sent_roundtrip_time_sum">
      </a>
      <a class="link" href="group-replication-status-variables.html#statvar_Gr_control_messages_sent_roundtrip_time_sum">
       <code class="literal">
        Gr_control_messages_sent_roundtrip_time_sum
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045128393120">
     </a>
     <a class="indexterm" name="idm46045128392000">
     </a>
     <p>
      Sum of the round-trip times in microseconds for control
          messages sent by this member; a round trip is measured between
          the sending and the delivery of the message on the sender.
          This should provide the time between sending and delivery of
          control messages for the majority of the members of the group,
          including the sender.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Gr_data_messages_sent_bytes_sum">
      </a>
      <a class="link" href="group-replication-status-variables.html#statvar_Gr_data_messages_sent_bytes_sum">
       <code class="literal">
        Gr_data_messages_sent_bytes_sum
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045128387200">
     </a>
     <a class="indexterm" name="idm46045128386096">
     </a>
     <p>
      Sum in bytes used by data messages sent by this member; this
          is the on-the-wire size.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Gr_data_messages_sent_count">
      </a>
      <a class="link" href="group-replication-status-variables.html#statvar_Gr_data_messages_sent_count">
       <code class="literal">
        Gr_data_messages_sent_count
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045128381600">
     </a>
     <a class="indexterm" name="idm46045128380496">
     </a>
     <p>
      This is the nmber of transaction data messages sent by this
          member.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Gr_data_messages_sent_roundtrip_time_sum">
      </a>
      <a class="link" href="group-replication-status-variables.html#statvar_Gr_data_messages_sent_roundtrip_time_sum">
       <code class="literal">
        Gr_data_messages_sent_roundtrip_time_sum
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045128376000">
     </a>
     <a class="indexterm" name="idm46045128374880">
     </a>
     <p>
      Sum of the round-trip times in microseconds for data messages
          sent by this member; a round trip is measured between the
          sending and the delivery of the message on the sender. This
          should provide the time between sending and delivery of data
          messages for the majority of the members of the group,
          including the sender.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Gr_empty_consensus_proposals_count">
      </a>
      <a class="link" href="group-replication-status-variables.html#statvar_Gr_empty_consensus_proposals_count">
       <code class="literal">
        Gr_empty_consensus_proposals_count
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045128369968">
     </a>
     <a class="indexterm" name="idm46045128368928">
     </a>
     <p>
      Sum of all empty proposal rounds that were initiated and
          terminated on this node.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Gr_extended_consensus_count">
      </a>
      <a class="link" href="group-replication-status-variables.html#statvar_Gr_extended_consensus_count">
       <code class="literal">
        Gr_extended_consensus_count
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045128364496">
     </a>
     <a class="indexterm" name="idm46045128363392">
     </a>
     <p>
      The number of full 3-phase rounds that this node has
          initiated. If this number grows over time, it means that at
          least one node is having problems answering to proposals,
          either due to something it to run slowly, or to network
          issues. Use this value together with the
      <code class="literal">
       count_member_failure_suspicions
      </code>
      column of
          the Performance Schema
      <a class="link" href="performance-schema-replication-group-communication-information-table.html" title="29.12.11.10 The replication_group_communication_information Table">
       <code class="literal">
        replication_group_communication_information
       </code>
      </a>
      table when diagnosing such issues.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Gr_last_consensus_end_timestamp">
      </a>
      <a class="link" href="group-replication-status-variables.html#statvar_Gr_last_consensus_end_timestamp">
       <code class="literal">
        Gr_last_consensus_end_timestamp
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045128356496">
     </a>
     <a class="indexterm" name="idm46045128355392">
     </a>
     <p>
      The time when the last consensus proposal was approved, in a
          timestamp format. This can be an indicator whether the group
          is making slow progress, or has halted.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Gr_total_messages_sent_count">
      </a>
      <a class="link" href="group-replication-status-variables.html#statvar_Gr_total_messages_sent_count">
       <code class="literal">
        Gr_total_messages_sent_count
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045128350864">
     </a>
     <a class="indexterm" name="idm46045128349760">
     </a>
     <p>
      The number of high-level messages sent by this node to the
          group. These are the messages received from the API for
          proposing to the group. The XCom batching mechanism batches
          these messages and proposes them all together. The value shown
          for this variable reflects the number of messages prior to
          batching.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Gr_transactions_consistency_after_sync_count">
      </a>
      <a class="link" href="group-replication-status-variables.html#statvar_Gr_transactions_consistency_after_sync_count">
       <code class="literal">
        Gr_transactions_consistency_after_sync_count
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045128344976">
     </a>
     <a class="indexterm" name="idm46045128343936">
     </a>
     <p>
      Number of transactions on secondaries that waited to start,
          while waiting for transactions from the primary with
      <a class="link" href="group-replication-system-variables.html#sysvar_group_replication_consistency">
       <code class="literal">
        group_replication_consistency
       </code>
      </a>
      equal to
      <code class="literal">
       AFTER
      </code>
      or
      <code class="literal">
       BEFORE_AND_AFTER
      </code>
      to be committed.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Gr_transactions_consistency_after_sync_time_sum">
      </a>
      <a class="link" href="group-replication-status-variables.html#statvar_Gr_transactions_consistency_after_sync_time_sum">
       <code class="literal">
        Gr_transactions_consistency_after_sync_time_sum
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045128336576">
     </a>
     <a class="indexterm" name="idm46045128335456">
     </a>
     <p>
      Sum of the times in microseconds that transactions on
          secondaries waited on transactions from the primary with
      <a class="link" href="group-replication-system-variables.html#sysvar_group_replication_consistency">
       <code class="literal">
        group_replication_consistency
       </code>
      </a>
      equal to
      <code class="literal">
       AFTER
      </code>
      or
      <code class="literal">
       BEFORE_AND_AFTER
      </code>
      to be committed, before
          starting.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Gr_transactions_consistency_after_termination_count">
      </a>
      <a class="link" href="group-replication-status-variables.html#statvar_Gr_transactions_consistency_after_termination_count">
       <code class="literal">
        Gr_transactions_consistency_after_termination_count
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045128328000">
     </a>
     <a class="indexterm" name="idm46045128326960">
     </a>
     <p>
      The number of transactions executed with
      <a class="link" href="group-replication-system-variables.html#sysvar_group_replication_consistency">
       <code class="literal">
        group_replication_consistency
       </code>
      </a>
      equal to
      <code class="literal">
       AFTER
      </code>
      or
      <code class="literal">
       BEFORE_AND_AFTER
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Gr_transactions_consistency_after_termination_time_sum">
      </a>
      <a class="link" href="group-replication-status-variables.html#statvar_Gr_transactions_consistency_after_termination_time_sum">
       <code class="literal">
        Gr_transactions_consistency_after_termination_time_sum
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045128319616">
     </a>
     <a class="indexterm" name="idm46045128318576">
     </a>
     <p>
      Sum of the time in microseconds between delivery of the
          transaction executed with
      <a class="link" href="group-replication-system-variables.html#sysvar_group_replication_consistency">
       <code class="literal">
        group_replication_consistency
       </code>
      </a>
      equal to
      <code class="literal">
       AFTER
      </code>
      or
      <code class="literal">
       BEFORE_AND_AFTER
      </code>
      , and acknowledgement by
          the other group members that the transaction is prepared.
     </p>
     <p>
      This value does not include transaction send roundtrip time.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Gr_transactions_consistency_before_begin_count">
      </a>
      <a class="link" href="group-replication-status-variables.html#statvar_Gr_transactions_consistency_before_begin_count">
       <code class="literal">
        Gr_transactions_consistency_before_begin_count
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045128310704">
     </a>
     <a class="indexterm" name="idm46045128309584">
     </a>
     <p>
      Number of transactions executed with
      <a class="link" href="group-replication-system-variables.html#sysvar_group_replication_consistency">
       <code class="literal">
        group_replication_consistency
       </code>
      </a>
      equal to
      <code class="literal">
       BEFORE
      </code>
      or
      <code class="literal">
       BEFORE_AND_AFTER
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Gr_transactions_consistency_before_begin_time_sum">
      </a>
      <a class="link" href="group-replication-status-variables.html#statvar_Gr_transactions_consistency_before_begin_time_sum">
       <code class="literal">
        Gr_transactions_consistency_before_begin_time_sum
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045128302240">
     </a>
     <a class="indexterm" name="idm46045128301200">
     </a>
     <p>
      Sum of the time in microseconds that the member waited until
          its group replication applier channel was consumed before
          executing the transaction with
      <a class="link" href="group-replication-system-variables.html#sysvar_group_replication_consistency">
       <code class="literal">
        group_replication_consistency
       </code>
      </a>
      equal to
      <code class="literal">
       BEFORE
      </code>
      or
      <code class="literal">
       BEFORE_AND_AFTER
      </code>
      .
     </p>
    </li>
   </ul>
  </div>
  <p>
   These status variables all have member scope since they reflect
      what the local member observes. They are reset on group bootstrap,
      joining of a new member, automatic rejoin of an existing member,
      and server restart.
  </p>
 </div>
 <br/>
</div>
