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)