<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="performance-schema-setup-meters-table">
      </a>
      29.12.21.1 The setup_meters Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045067845808">
  </a>
  <a class="indexterm" name="idm46045067844320">
  </a>
  <p>
   The
   <a class="link" href="performance-schema-setup-meters-table.html" title="29.12.21.1 The setup_meters Table">
    <code class="literal">
     setup_meters
    </code>
   </a>
   table lists the
          registered meters:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa22851095"><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 prompt">mysql&gt;</span> <span class="token keyword">select</span> <span class="token operator">*</span> <span class="token keyword">from</span> performance_schema<span class="token punctuation">.</span>setup_meters<span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> NAME                   <span class="token punctuation">|</span> FREQUENCY <span class="token punctuation">|</span> ENABLED <span class="token punctuation">|</span> DESCRIPTION                               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> mysql.inno             <span class="token punctuation">|</span>        10 <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span> MySql InnoDB metrics                      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> mysql.inno.buffer_pool <span class="token punctuation">|</span>        10 <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span> MySql InnoDB buffer pool metrics          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> mysql.inno.data        <span class="token punctuation">|</span>        10 <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span> MySql InnoDB data metrics                 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> mysql.x                <span class="token punctuation">|</span>        10 <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span> MySql X plugin metrics                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> mysql.x.stmt           <span class="token punctuation">|</span>        10 <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span> MySql X plugin statement statistics       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> mysql.stats            <span class="token punctuation">|</span>        10 <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span> MySql core metrics                        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> mysql.stats.com        <span class="token punctuation">|</span>        10 <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span> MySql command stats                       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> mysql.stats.connection <span class="token punctuation">|</span>        10 <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span> MySql connection stats                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> mysql.stats.handler    <span class="token punctuation">|</span>        10 <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span> MySql handler stats                       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> mysql.stats.ssl        <span class="token punctuation">|</span>        10 <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span> MySql TLS related stats                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> mysql.myisam           <span class="token punctuation">|</span>        10 <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span> MySql MyISAM storage engine stats         <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> mysql.perf_schema      <span class="token punctuation">|</span>        10 <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span> MySql performance_schema lost instruments <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span></code></pre>
  </div>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       NAME
      </code>
      : Name of the meter.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       FREQUENCY
      </code>
      : Frequency in seconds of
              metric export. Default is every 10 seconds. This value can
              be edited for registered meters.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       ENABLED
      </code>
      : Whether the meter is enabled.
              The value is YES or NO. A disabled meter exports no
              metrics. This column can be modified
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       DESCRIPTION
      </code>
      : A string describing the
              meter.
     </p>
    </li>
   </ul>
  </div>
  <p>
   <code class="literal">
    FREQUENCY
   </code>
   and
   <code class="literal">
    ENABLED
   </code>
   can be edited.
  </p>
 </div>
 <br/>
</div>
