MySQL数据库执行Update卡死问题的解决方法

show variables like 'autocommit';

-- on为开启，off为关闭
set autocommit=off;
-- 或者1为开启，0为关闭
set autocommit=0;

update car set color ='银色' where id = 1;
update car set color ='红色' where id = 1;

SELECT * FROM infORMation_schema.INNODB_TRX;

kill 1089;

-- 查看正在锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS; 

-- 查看等待锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WaiTS;
-- 查询mysql数据库中存在的进程
select * from information_schema.`PROCESSLIST`(show processlist;)  

SELECT s.sid, s.serial# FROM v$locked_object lo, dba_objects ao, v$session s WHERE ao.object_id = lo.object_id AND lo.session_id = s.sid; 

ALTER system KILL session 'SID,serial#';