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

7693 人参与 | 时间:2024年03月29日 12:12:09
点击跳转 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;