问题

软件 >> MySQL
Questions in category: MySQL (MySQL).

查看 mysql 中的 process

Posted by haifeng on 2020-10-13 11:17:14 last update 2020-10-13 11:17:14 | Answers (0) | 收藏


mysql> use information_schema;

mysql> select * from processlist;
+-----+------+-----------------+--------------------+---------+------+-----------+---------------------------+
| ID  | USER | HOST            | DB                 | COMMAND | TIME | STATE     | INFO                      |
+-----+------+-----------------+--------------------+---------+------+-----------+---------------------------+
| 116 | root | localhost:56779 | information_schema | Query   |    0 | executing | select * from processlist |
+-----+------+-----------------+--------------------+---------+------+-----------+---------------------------+
1 row in set (0.00 sec)