title: Lock wait timeout exceeded in MySQL
body: <p>I get the following error:</p>
  
  <pre><code>ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
  </code></pre>
  
  <p>I did the </p>
  
  <pre><code>show processlist; 
  </code></pre>
  
  <p>command and killed all the processes and well run the command </p>
  
  <p>+------+------+-----------+-------------------+---------+------+-----------+---------------------------------------------------------------------------------+
  | Id   | User | Host      | db                | Command | Time | State     | Info                                                                            |
  +------+------+-----------+-------------------+---------+------+-----------+---------------------------------------------------------------------------------+
  | 1749 | cyee | localhost | CY_Test           | Killed  | 2308 | query end | INSERT INTO CY_Test.patient2010 SELECT * FROM <code>cmsdata-outpatient-2010</code>.patient |
  | 1755 | cyee | localhost | cmsdata-inpatient | Query   |    0 | NULL      | SHOW FULL PROCESSLIST                                                           |
  +------+------+-----------+-------------------+---------+------+-----------+---------------------------------------------------------------------------------+</p>
  
  <pre><code>set innodb_lock_wait_timeout=1000; 
  </code></pre>
  
  <p>that another site suggested, but i still get the same error.  Any help would be appreciated, thanks!</p>