1.查询对应进程ID
SHOW FULL PROCESSLIST
2.查询“1”对应进程ID是否存在TRX_MYSQL_THREAD_ID
SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX
3.杀死对应进程TRX_MYSQL_THREAD_ID
KILL XXX
1.查询对应进程ID
SHOW FULL PROCESSLIST
2.查询“1”对应进程ID是否存在TRX_MYSQL_THREAD_ID
SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX
3.杀死对应进程TRX_MYSQL_THREAD_ID
KILL XXX