hookover/php-engineer-interview-questions: PHP工程师面试题目
内容
数据库如果出现了死锁,你怎么排查,怎么判断出现了死锁?
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;
数据库如果出现了死锁,你怎么排查,怎么判断出现了死锁?
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;