1,查看數據庫的隔離級別:mysql
mysql> select @@tx_isolation;
+-----------------+
| @@tx_isolation |
+-----------------+
| REPEATABLE-READ |
+-----------------+
1 row in set (0.00 sec)
sql
2,去查看先當前庫的線程狀況:數據庫
mysql> show full processlist; spa
mysql> SELECT * FROM information_schema.INNODB_TRX;.net
mysql> kill 156665;線程
mysql> SELECT * FROM INNODB_TRX;orm
Empty set (0.00 sec)ssl