mysql 数据库

查看锁，及解锁


mysql> show processlist;
+----+------+----------------+----------+---------+-------+-------+------------------+
| Id | User | Host           | db       | Command | Time  | State | Info             |
+----+------+----------------+----------+---------+-------+-------+------------------+
| 10 | root | localhost:1572 | wireless | Sleep   | 11108 |       | NULL             |
| 11 | root | localhost:1573 | wireless | Sleep   | 11581 |       | NULL             |
| 14 | root | localhost:1587 | wireless | Sleep   |  1670 |       | NULL             |
| 16 | root | localhost:1589 | wireless | Sleep   |  1682 |       | NULL             |
| 50 | root | localhost:2379 | wireless | Sleep   |   651 |       | NULL             |
| 51 | root | localhost:2380 | wireless | Sleep   |   449 |       | NULL             |
| 52 | root | localhost:2382 | wireless | Sleep   |   417 |       | NULL             |
| 53 | root | localhost:2387 | NULL     | Query   |     0 | NULL  | show processlist |
+----+------+----------------+----------+---------+-------+-------+------------------+
8 rows in set (0.00 sec)

mysql> kill 10;
Query OK, 0 rows affected (0.00 sec)

mysql> show processlist;
+----+------+----------------+----------+---------+-------+-------+------------------+
| Id | User | Host           | db       | Command | Time  | State | Info             |
+----+------+----------------+----------+---------+-------+-------+------------------+
| 11 | root | localhost:1573 | wireless | Sleep   | 11595 |       | NULL             |
| 14 | root | localhost:1587 | wireless | Sleep   |  1684 |       | NULL             |
| 16 | root | localhost:1589 | wireless | Sleep   |  1696 |       | NULL             |
| 50 | root | localhost:2379 | wireless | Sleep   |   665 |       | NULL             |
| 51 | root | localhost:2380 | wireless | Sleep   |   463 |       | NULL             |
| 52 | root | localhost:2382 | wireless | Sleep   |   431 |       | NULL             |
| 53 | root | localhost:2387 | NULL     | Query   |     0 | NULL  | show processlist |
+----+------+----------------+----------+---------+-------+-------+------------------+
7 rows in set (0.00 sec)

mysql>