56,679
社区成员
发帖
与我相关
我的任务
分享
mysql> FLUSH TABLES WITH READ LOCK;
Query OK, 0 rows affected (0.01 sec)
mysql> show processlist;
+----+------+-----------------+------+---------+------+-------------------------
-----+----------------------+
| Id | User | Host | db | Command | Time | State
| Info |
+----+------+-----------------+------+---------+------+-------------------------
-----+----------------------+
| 1 | root | localhost:50424 | NULL | Query | 0 | NULL
| show processlist |
| 2 | root | localhost:50427 | NULL | Query | 6 | Waiting for global read
lock | create database dbdd |
+----+------+-----------------+------+---------+------+-------------------------
-----+----------------------+
2 rows in set (0.00 sec)
mysql> show processlist;
+----+------+-----------------+------+---------+------+-------+-----------------
-+
| Id | User | Host | db | Command | Time | State | Info
|
+----+------+-----------------+------+---------+------+-------+-----------------
-+
| 1 | root | localhost:50424 | NULL | Query | 0 | NULL | show processlist
|
| 2 | root | localhost:50427 | NULL | Sleep | 20 | | NULL
|
+----+------+-----------------+------+---------+------+-------+-----------------
-+
2 rows in set (0.00 sec)
mysql> show processlist;
+----+------+-----------------+------+---------+------+-------------------------
-----+------------------------------+
| Id | User | Host | db | Command | Time | State
| Info |
+----+------+-----------------+------+---------+------+-------------------------
-----+------------------------------+
| 1 | root | localhost:50424 | NULL | Query | 0 | NULL
| show processlist |
| 2 | root | localhost:50427 | test | Query | 3 | Waiting for global read
lock | insert into tage values(1,2) |
+----+------+-----------------+------+---------+------+-------------------------
-----+------------------------------+
2 rows in set (0.00 sec)
mysql>