title: MySQL query not going away after being killed
body: <p>I have a MySQL query that is copying data from one table to another for processing. For some reason, this query that normally takes a few seconds locked up overnight and ran for several hours. When I logged in this morning, I tried to kill the query, but it is still listed in the process list.</p>
  
  <pre><code>| Id      | User     | Host      | db   | Command | Time  | State        | Info                                                                                 |
  +---------+----------+-----------+------+---------+-------+--------------+--------------------------------------------------------------------------------------+
  | 1061763 | tb_admin | localhost | dw   | Killed  | 45299 | Sending data | INSERT INTO email_data_inno_stage SELECT * FROM email_data_test LIMIT 4480000, 10000 |
  | 1062614 | tb_admin | localhost | dw   | Killed  |   863 | Sending data | INSERT INTO email_data_inno_stage SELECT * FROM email_data_test LIMIT 4480000, 10000 |
  </code></pre>
  
  <p>What could have caused this, and how can I kill this process so I can get on with my work?</p>