title: Query is locking tables, can't kill that process
body: <p>I have a query locking tables in MySQL (using InnoDB):</p>
  
  <pre><code>UPDATE table SET status = 2 WHERE status = 3
  </code></pre>
  
  <p>This query caused a deadlock on the table and can't bypass it.</p>
  
  <p>I tried to do:</p>
  
  <pre><code>show processlist
  </code></pre>
  
  <p>then kill the process id but i can't seems to kill it </p>
  
  <p>I tried:</p>
  
  <pre><code>kill 9588
  </code></pre>
  
  <p>9588 is the process id.</p>
  
  <p>Then I do <code>show processlist</code> I still see the same query on the list.</p>
  
  <p>How can I force killing this process and then why would this query cause a dead lock? how can I fix it?</p>