Mysql:lock tables tb_nm 之后如何再得到tb_nm的状态? 我在一个程序中要lock table tb_nm, 在这之前我想要知道另外一个程序或者服务对没对这个表(tb_nm)进行lock,请问我如何得到该表的状态来决定我自己是否lock tb_nm? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Try to analyze the result of show processlist. mysql> use t_girlDatabase changedmysql> show open tables;+----------+---------------+--------+-------------+| Database | Table | In_use | Name_locked |+----------+---------------+--------+-------------+| t_girl | slave | 0 | 0 | | mysql | help_keyword | 0 | 0 | | mysql | help_category | 0 | 0 | | mysql | help_relation | 0 | 0 | | t_girl | t1 | 0 | 0 | | mysql | help_topic | 0 | 0 | | mysql | user | 0 | 0 | +----------+---------------+--------+-------------+7 rows in set (0.00 sec)mysql> lock tables t1 as a read;Query OK, 0 rows affected (0.00 sec)mysql> show open tables;+----------+---------------+--------+-------------+| Database | Table | In_use | Name_locked |+----------+---------------+--------+-------------+| t_girl | slave | 0 | 0 | | mysql | help_keyword | 0 | 0 | | mysql | help_category | 0 | 0 | | mysql | help_relation | 0 | 0 | | t_girl | t1 | 1 | 0 | | mysql | help_topic | 0 | 0 | | mysql | user | 0 | 0 | +----------+---------------+--------+-------------+7 rows in set (0.00 sec)mysql> unlock tables;Query OK, 0 rows affected (0.00 sec)mysql> show open tables;+----------+---------------+--------+-------------+| Database | Table | In_use | Name_locked |+----------+---------------+--------+-------------+| t_girl | slave | 0 | 0 | | mysql | help_keyword | 0 | 0 | | mysql | help_category | 0 | 0 | | mysql | help_relation | 0 | 0 | | t_girl | t1 | 0 | 0 | | mysql | help_topic | 0 | 0 | | mysql | user | 0 | 0 | +----------+---------------+--------+-------------+7 rows in set (0.00 sec) 关于Mysql DBA的疑惑 请教关于MYSQL中order by的效率优化 求一SQL的写法 谢谢 mysql怎么获得他下一个自动增长列的值是什么 源码安装mysql5.1发现不支持innodb ,如何配置才能让他支持 启动mysql服务器失败?? Myodbc是否安装正确? 请教一下如何用.sql文件在mysql里创建数据库啊 安装postgresql,help~~~~~~ 本地数据怎么可以插入到远程的infobright中 头疼的查询语句,请各位帮忙看下 pgadmin III应该属于postgresql的服务器界面程序还是客户端应用程序?
mysql> use t_girl
Database changed
mysql> show open tables;
+----------+---------------+--------+-------------+
| Database | Table | In_use | Name_locked |
+----------+---------------+--------+-------------+
| t_girl | slave | 0 | 0 |
| mysql | help_keyword | 0 | 0 |
| mysql | help_category | 0 | 0 |
| mysql | help_relation | 0 | 0 |
| t_girl | t1 | 0 | 0 |
| mysql | help_topic | 0 | 0 |
| mysql | user | 0 | 0 |
+----------+---------------+--------+-------------+
7 rows in set (0.00 sec)mysql> lock tables t1 as a read;
Query OK, 0 rows affected (0.00 sec)mysql> show open tables;
+----------+---------------+--------+-------------+
| Database | Table | In_use | Name_locked |
+----------+---------------+--------+-------------+
| t_girl | slave | 0 | 0 |
| mysql | help_keyword | 0 | 0 |
| mysql | help_category | 0 | 0 |
| mysql | help_relation | 0 | 0 |
| t_girl | t1 | 1 | 0 |
| mysql | help_topic | 0 | 0 |
| mysql | user | 0 | 0 |
+----------+---------------+--------+-------------+
7 rows in set (0.00 sec)mysql> unlock tables;
Query OK, 0 rows affected (0.00 sec)mysql> show open tables;
+----------+---------------+--------+-------------+
| Database | Table | In_use | Name_locked |
+----------+---------------+--------+-------------+
| t_girl | slave | 0 | 0 |
| mysql | help_keyword | 0 | 0 |
| mysql | help_category | 0 | 0 |
| mysql | help_relation | 0 | 0 |
| t_girl | t1 | 0 | 0 |
| mysql | help_topic | 0 | 0 |
| mysql | user | 0 | 0 |
+----------+---------------+--------+-------------+
7 rows in set (0.00 sec)