搜索结果: "deadlock"
共找到 4 个页面
MySQL 性能调优 — 慢查询 / 锁分析 / 死锁排查 / 索引失效 / 深度分页 / 缓冲池 / 配置模板
tags: [mysql, database, performance, monitoring, production, deadlock, lock]
- raw/articles/mysql-deadlock-troubleshooting.md
SHOW VARIABLES LIKE 'innodb_print_all_deadlocks';
SET GLOBAL innodb_print_all_deadlocks = ON;
-- 查看 deadlock 统计
MySQL / Redis 常见故障排查速查清单
**现象**：`Deadlock found when trying to get lock; try restarting transaction`
-- 找到 LATEST DETECTED DEADLOCK 部分
SET GLOBAL innodb_print_all_deadlocks = ON;
Wiki Schema
- deadlock: 死锁分析
Wiki Log
- Created raw: raw/articles/mysql-deadlock-troubleshooting.md