hookover/php-engineer-interview-questions: PHP工程师面试题目

1223 人参与 | 时间:2021年05月13日 16:28:50
github网站搜“hookover/php-engineer-interview-questions”

数据库如果出现了死锁,你怎么排查,怎么判断出现了死锁? 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;

.