Mysql8.0 processlist查看当前用户连接信息

最新推荐文章于 2024-03-07 18:06:05 发布

xharvard

最新推荐文章于 2024-03-07 18:06:05 发布

阅读量421

点赞数 10

分类专栏： # Mysql 文章标签： mysql

本文链接：https://blog.csdn.net/xharvard/article/details/136368772

版权

Mysql 专栏收录该内容

18 篇文章 0 订阅

订阅专栏

mysql> show processlist;
+----+-----------------+-----------------+--------+---------+--------+------------------------+------------------+
| Id | User            | Host            | db     | Command | Time   | State                  | Info             |
+----+-----------------+-----------------+--------+---------+--------+------------------------+------------------+
|  5 | event_scheduler | localhost       | NULL   | Daemon  | 161500 | Waiting on empty queue | NULL             |
| 20 | root            | localhost:56856 | test01 | Query   |      0 | init                   | show processlist |
+----+-----------------+-----------------+--------+---------+--------+------------------------+------------------+
2 rows in set, 1 warning (0.00 sec)