mysql怎么知道哪个表被谁,或者IP锁着?

mysql怎么知道哪个表被谁,或者IP ,进程锁着?

---

show processlist;

---

查看日志

或者看
SQL code:
mysql> show status like "%Com_unlock_tables%";
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| Com_unlock_tables | 1 |
+-------------------+-------+
1 row in set (0.00 sec)

---

你们给的都没有真实的用处

想知道哪个Ip所，做什么SQL锁的?

---

show processlist;结果里有ip也有sql啊

---

如果你用的innodb引擎，你也可以使用show innodb status查看

---

明白了楼主的意思

楼主的意思是有多个用户同时访问服务器，现在服务器向知道谁锁的表？

SQL code:
mysql> show processlist;
+----+-------+----------------+------+---------+------+---------------------------------+--------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+----------------+------+---------+------+---------------------------------+--------------------+
| 2 | root | localhost:2969 | test | Sleep | 2799 | | NULL |
| 3 | root | localhost:2970 | NULL | Sleep | 2807 | | NULL