Blog Content

mysql死锁问题，查看锁进程

MySQL   2014-12-13 19:29:16

---

三条SQL语句

show processlist;

SELECT * FROM information_schema.INNODB_TRX\G；

SELECT * FROM information_schema.INNODB_LOCKS;

SELECT * FROM information_schema.INNODB_LOCK_waits;

---

上一篇：thinkphp框架，用if标签判断对象是否为空
下一篇：量化投资策略：常见的几种Python回测框架（库）