<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h2 class="title">
      <a name="sys-schema-progress-reporting">
      </a>
      30.3 sys Schema Progress Reporting
     </h2>
    </div>
   </div>
  </div>
  <p>
   The following
   <a class="link" href="sys-schema.html" title="Chapter 30 MySQL sys Schema">
    <code class="literal">
     sys
    </code>
   </a>
   schema views
      provide progress reporting for long-running transactions:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-none"><div class="docs-select-all right" id="sa16002598"><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-none">processlist
session
x$processlist
x$session</code></pre>
  </div>
  <p>
   Assuming that the required instruments and consumers are enabled,
      the
   <code class="literal">
    progress
   </code>
   column of these views shows the
      percentage of work completed for stages that support progress
      reporting.
  </p>
  <p>
   Stage progress reporting requires that the
   <code class="literal">
    events_stages_current
   </code>
   consumer be enabled, as
      well as the instruments for which progress information is desired.
      Instruments for these stages currently support progress reporting:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-none"><div class="docs-select-all right" id="sa94406627"><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-none">stage/sql/Copying to tmp table
stage/innodb/alter table (end)
stage/innodb/alter table (flush)
stage/innodb/alter table (insert)
stage/innodb/alter table (log apply index)
stage/innodb/alter table (log apply table)
stage/innodb/alter table (merge sort)
stage/innodb/alter table (read PK and internal sort)
stage/innodb/buffer pool load</code></pre>
  </div>
  <p>
   For stages that do not support estimated and completed work
      reporting, or if the required instruments or consumers are not
      enabled, the
   <code class="literal">
    progress
   </code>
   column is
   <code class="literal">
    NULL
   </code>
   .
  </p>
 </div>
 <br/>
</div>
