mysql 查询 长事务

-- MySQL 8.0 之前
　　SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
　　SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;

-- MySQL 8.0+
　　SELECT * FROM performance_schema.data_locks;
　　SELECT * FROM performance_schema.data_lock_waits;

-- 
　　SELECT trx_id, trx_state, trx_started, trx_mysql_thread_id, trx_query
　　FROM INFORMATION_SCHEMA.INNODB_TRX;

--
　　KILL 1234; -- 替换成实际的线程 ID