mysql怎么知道哪个表被谁,或者IP ,进程锁着?
解决方案 »
- mysql 查询经常出现 Lost connection to MySQL server during query
- MySQL 表别名难道还有缓存功能?
- 这MYSQL错误提示是什么意思啊
- 关于sysbench测试结果的一些疑问
- mysql如何动态生成交叉表?
- c# sql语句条件里有汉字,选出来的结果为空
- mysql 1089错误如何解决?
- 请问integer与integer[]之间如何对应?
- 请问:使用phpMyAdmin 2.5.0怎么批量上传数据!
- 求救啊 关于mysql的问题,in和not exists返回的结果不一样啊
- 查看本机的sql数据库中的表的内容
- mysql高版本数据库表名在低版本乱码
mysql> show status like "%Com_unlock_tables%";
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| Com_unlock_tables | 1 |
+-------------------+-------+
1 row in set (0.00 sec)
+----+-------+----------------+------+---------+------+---------------------------------+--------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+----------------+------+---------+------+---------------------------------+--------------------+
| 2 | root | localhost:2969 | test | Sleep | 2799 | | NULL |
| 3 | root | localhost:2970 | NULL | Sleep | 2807 | | NULL |
| 6 | root | localhost:3277 | NULL | Sleep | 815 | | NULL |
| 7 | root | localhost:3341 | test | Query | 25 | Waiting for release of readlock | delete from t |
| 8 | root | localhost:3342 | test | Query | 0 | NULL | show processlist |
| 9 | model | localhost:3425 | NULL | Query | 12 | Waiting for release of readlock | delete from test.t |
+----+-------+----------------+------+---------+------+---------------------------------+--------------------+
6 rows in set (0.00 sec)
这个只能看状态究竟哪个用户所表了
你看日志
general-log
那个用户用lock了就是他所表了