Mysql 错误ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

1，查看数据库的隔离级别：

mysql> select @@tx_isolation; +-----------------+ | @@tx_isolation  | +-----------------+ | REPEATABLE-READ | +-----------------+ 1 row in set (0.00 sec)

2，去查看先当前库的线程情况：

mysql> show full processlist; 

mysql> SELECT * FROM information_schema.INNODB_TRX;

mysql> kill 156665;

mysql> SELECT * FROM INNODB_TRX;

Empty set (0.00 sec)