1、找到threadid
SELECT * FROM performance_schema.data_locks;
2、通过threadid查找到sessionid
SELECT THREAD_ID, CONNECTION_ID() AS CURRENT_SESSION_ID
FROM performance_schema.threads where THREAD_ID ='threadid';
3、kill sessionid
1、找到threadid
SELECT * FROM performance_schema.data_locks;
2、通过threadid查找到sessionid
SELECT THREAD_ID, CONNECTION_ID() AS CURRENT_SESSION_ID
FROM performance_schema.threads where THREAD_ID ='threadid';
3、kill sessionid