<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="performance-schema-clone-progress-table">
      </a>
      29.12.19.2 The clone_progress Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045069417264">
  </a>
  <a class="indexterm" name="idm46045069415776">
  </a>
  <p>
   The
   <code class="literal">
    clone_progress
   </code>
   table shows progress
          information for the current or last executed cloning operation
          only.
  </p>
  <p>
   The stages of a cloning operation include
   <code class="literal">
    DROP
          DATA
   </code>
   ,
   <code class="literal">
    FILE COPY
   </code>
   ,
   <code class="literal">
    PAGE_COPY
   </code>
   ,
   <code class="literal">
    REDO_COPY
   </code>
   ,
   <code class="literal">
    FILE_SYNC
   </code>
   ,
   <code class="literal">
    RESTART
   </code>
   , and
   <code class="literal">
    RECOVERY
   </code>
   . A cloning operation produces a
          record for each stage. The table therefore only ever contains
          seven rows of data, or is empty.
  </p>
  <p>
   The
   <code class="literal">
    clone_progress
   </code>
   table has these columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       ID
      </code>
     </p>
     <p>
      A unique cloning operation identifier in the current MySQL
              server instance.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       STAGE
      </code>
     </p>
     <p>
      The name of the current cloning stage. Stages include
      <code class="literal">
       DROP DATA
      </code>
      ,
      <code class="literal">
       FILE
              COPY
      </code>
      ,
      <code class="literal">
       PAGE_COPY
      </code>
      ,
      <code class="literal">
       REDO_COPY
      </code>
      ,
      <code class="literal">
       FILE_SYNC
      </code>
      ,
      <code class="literal">
       RESTART
      </code>
      ,
              and
      <code class="literal">
       RECOVERY
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       STATE
      </code>
     </p>
     <p>
      The current state of the cloning stage. States include
      <code class="literal">
       Not Started
      </code>
      ,
      <code class="literal">
       In
              Progress
      </code>
      , and
      <code class="literal">
       Completed
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       BEGIN_TIME
      </code>
     </p>
     <p>
      A timestamp in
      <code class="literal">
       '
       <em class="replaceable">
        <code>
         YYYY-MM-DD
              hh:mm:ss
        </code>
       </em>
       [.
       <em class="replaceable">
        <code>
         fraction
        </code>
       </em>
       ]'
      </code>
      format that shows when the cloning stage started. Reports
              NULL if the stage has not started.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       END_TIME
      </code>
     </p>
     <p>
      A timestamp in
      <code class="literal">
       '
       <em class="replaceable">
        <code>
         YYYY-MM-DD
              hh:mm:ss
        </code>
       </em>
       [.
       <em class="replaceable">
        <code>
         fraction
        </code>
       </em>
       ]'
      </code>
      format that shows when the cloning stage finished. Reports
              NULL if the stage has not ended.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       THREADS
      </code>
     </p>
     <p>
      The number of concurrent threads used in the stage.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       ESTIMATE
      </code>
     </p>
     <p>
      The estimated amount of data for the current stage, in
              bytes.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       DATA
      </code>
     </p>
     <p>
      The amount of data transferred in current state, in bytes.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       NETWORK
      </code>
     </p>
     <p>
      The amount of network data transferred in the current
              state, in bytes.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       DATA_SPEED
      </code>
     </p>
     <p>
      The current actual speed of data transfer, in bytes per
              second. This value may differ from the requested maximum
              data transfer rate defined by
      <a class="link" href="clone-plugin-options-variables.html#sysvar_clone_max_data_bandwidth">
       <code class="literal">
        clone_max_data_bandwidth
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       NETWORK_SPEED
      </code>
     </p>
     <p>
      The current speed of network transfer in bytes per second.
     </p>
    </li>
   </ul>
  </div>
  <p>
   The
   <code class="literal">
    clone_progress
   </code>
   table is read-only. DDL,
          including
   <a class="link" href="truncate-table.html" title="15.1.37 TRUNCATE TABLE Statement">
    <code class="literal">
     TRUNCATE TABLE
    </code>
   </a>
   , is
          not permitted.
  </p>
 </div>
 <br/>
</div>
