解决方法：将出现锁表的事务kill掉即可
例：更新表中的某个字段出现失败
mysql> set innodb_lock_wait_timeout=100mysql> show variables like 'innodb_lock_wait_timeout';
mysql> set innodb_lock_wait_timeout=100
mysql> show variables like 'innodb_lock_wait_timeout';
kill掉该进程，即可完成更新
select * from information_schema.innodb_trxkill 15758 #进程ID
select * from information_schema.innodb_trx
kill 15758 #进程ID
