Mysql Update Error

Today at work when found oneself update a table of a word Duan, think for a long time, the first thought is to extend the operating hours:

Mysql> set innodb_lock_wait_timeout=100mysql> show variables like ' innodb_lock_wait_timeout ';

However, although the time has been extended, the problem has not been resolved, in the Internet to find a lap, found that the MySQL transaction may not be submitted, resulting in the lock table, the solution is as follows:

1 Select *  from Information_schema.innodb_trx 2 3 Kill 15758

Where 15758 is the thread ID