数据库如果出现了死锁,你怎么排查,怎么判断出现了死锁? SELECT FROM INFORMATION_SCHEMA.INNODB_TRX; SELECT FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
SHOW processlist; SHOW ENGINE INNODB STATUS;
站外导购