mysql锁表解决

问题出现：在执行sql时报 Lock wait timeout exceeded; try restarting transaction

问题查看：SELECT * FROM information_schema.INNODB_TRX; 发现有一条记录

问题解决：从SELECT * FROM information_schema.INNODB_TRX;结果中获取 trx_mysql_thread_id，比如获取到1669693，然后执行sql：kill 1669693;