<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="clone-plugin-stop">
      </a>
      7.6.7.11 Stopping a Cloning Operation
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045255144144">
  </a>
  <p>
   If necessary, you can stop a cloning operation with a
   <a class="link" href="kill.html" title="15.7.8.4 KILL Statement">
    <code class="literal">
     KILL QUERY
     <em class="replaceable">
      <code>
       processlist_id
      </code>
     </em>
    </code>
   </a>
   statement.
  </p>
  <p>
   On the recipient MySQL server instance, you can retrieve the
        processlist identifier (PID) for a cloning operation from the
   <code class="literal">
    PID
   </code>
   column of the
   <a class="link" href="performance-schema-clone-status-table.html" title="29.12.19.1 The clone_status Table">
    <code class="literal">
     clone_status
    </code>
   </a>
   table.
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa45633329"><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>clone_status\G
<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> 1. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
             ID<span class="token punctuation">:</span> 1
            PID<span class="token punctuation">:</span> 8
          STATE<span class="token punctuation">:</span> In Progress
     BEGIN_TIME<span class="token punctuation">:</span> 2019-07-15 11<span class="token punctuation">:</span>58<span class="token punctuation">:</span>36.767
       END_TIME<span class="token punctuation">:</span> NULL
         SOURCE<span class="token punctuation">:</span> LOCAL INSTANCE
    DESTINATION<span class="token punctuation">:</span> /<em class="replaceable">path/to/clone_dir</em>/
       ERROR_NO<span class="token punctuation">:</span> 0
  ERROR_MESSAGE<span class="token punctuation">:</span>
    BINLOG_FILE<span class="token punctuation">:</span>
BINLOG_POSITION<span class="token punctuation">:</span> 0
  GTID_EXECUTED<span class="token punctuation">:</span></span></code></pre>
  </div>
  <p>
   You can also retrieve the processlist identifier from the
   <code class="literal">
    ID
   </code>
   column of the
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   <a class="link" href="information-schema-processlist-table.html" title="28.3.23 The INFORMATION_SCHEMA PROCESSLIST Table">
    <code class="literal">
     PROCESSLIST
    </code>
   </a>
   table, the
   <code class="literal">
    Id
   </code>
   column of
   <a class="link" href="show-processlist.html" title="15.7.7.31 SHOW PROCESSLIST Statement">
    <code class="literal">
     SHOW
        PROCESSLIST
    </code>
   </a>
   output, or the
   <code class="literal">
    PROCESSLIST_ID
   </code>
   column of the Performance
        Schema
   <a class="link" href="performance-schema-threads-table.html" title="29.12.22.8 The threads Table">
    <code class="literal">
     threads
    </code>
   </a>
   table. These methods
        of obtaining the PID information can be used on the donor or
        recipient MySQL server instance.
  </p>
 </div>
 <br/>
</div>
