<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="mysql-gr-memory-monitoring-ps-instruments-enable">
      </a>
      20.7.9.1 Enabling or Disabling Group Replication Instrumentation
     </h4>
    </div>
   </div>
  </div>
  <p>
   To enable all the Group Replication instrumentation from the
        command line, run the following in the SQL client of your
        choice:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa54256874"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql">        <span class="token keyword">UPDATE</span> performance_schema<span class="token punctuation">.</span>setup_instruments <span class="token keyword">SET</span> ENABLED <span class="token operator">=</span> <span class="token string">'YES'</span> 
        <span class="token keyword">WHERE</span> <span class="token keyword">NAME</span> <span class="token operator">LIKE</span> <span class="token string">'memory/group_rpl/%'</span><span class="token punctuation">;</span></code></pre>
  </div>
  <p>
   To disable all the Group Replication instrumentation from the
        command line, run the following in the SQL client of your
        choice:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa60819223"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql">        <span class="token keyword">UPDATE</span> performance_schema<span class="token punctuation">.</span>setup_instruments <span class="token keyword">SET</span> ENABLED <span class="token operator">=</span> <span class="token string">'NO'</span> 
        <span class="token keyword">WHERE</span> <span class="token keyword">NAME</span> <span class="token operator">LIKE</span> <span class="token string">'memory/group_rpl/%'</span><span class="token punctuation">;</span></code></pre>
  </div>
  <p>
   To enable all the Group Replication instrumentation at server
        startup, add the following to your option file:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-ini"><div class="docs-select-all right" id="sa33015791"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-ini"><span class="token selector">        [mysqld]</span>
<span class="token constant">        performance-schema-instrument</span><span class="token attr-value"><span class="token punctuation">=</span>'memory/group_rpl/%=ON'</span></code></pre>
  </div>
  <p>
   To disable all the Group Replication instrumentation at server
        startup, add the following to your option file:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-ini"><div class="docs-select-all right" id="sa92544653"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-ini"><span class="token selector">        [mysqld]</span>
<span class="token constant">        performance-schema-instrument</span><span class="token attr-value"><span class="token punctuation">=</span>'memory/group_rpl/%=OFF'</span></code></pre>
  </div>
  <p>
   To enable or disable individual instruments in that group,
        replace the wildcard (%) with the full name of the instrument.
  </p>
  <p>
   For more information, see
   <a class="xref" href="performance-schema-startup-configuration.html" title="29.3 Performance Schema Startup Configuration">
    Section 29.3, “Performance Schema Startup Configuration”
   </a>
   and
   <a class="xref" href="performance-schema-runtime-configuration.html" title="29.4 Performance Schema Runtime Configuration">
    Section 29.4, “Performance Schema Runtime Configuration”
   </a>
   .
  </p>
 </div>
 <br/>
</div>
