mysql锁表

mysql 报错

　　err=1205 - Lock wait timeout exceeded; try restarting transaction

解决方案：

select * from information_schema.innodb_trx

 

kill 掉 trx_mysql_thread_id