本文介绍了如何在MySQL交互式会话中查看当前连接情况，包括使用`show processlist`命令和查询`INFORMATION_SCHEMA.PROCESSLIST`表。同时，展示了如何获取当前会话信息及终止特定会话的方法。
在mysql 交互式会话中查看当前连接情况。
(root@localhost) [(none)]> show processlist;
+-------+------+-----------------------+-------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+------+-----------------------+-------+---------+------+-------+------------------+
| 4 | root | localhost:52778 | mysql | Sleep | 2 | | NULL |
| 1495 | root | 192.168.154.1:57040 | world | Sleep | 1881 | | NULL |
| 10241 | root | 192.168.154.190:51707 | world | Sleep | 649 | | NULL |
| 12671 | root | localhost | NULL | Query | 0 | init | show processlist |
| 13279 | root | localhost:38329 | mysql | Sleep | 50 | | NULL |
| 13362 | root | localhost:38419 | mem | Sleep | 2 | | NULL |
+-------+------+-----------------------+-------+---------+------+-------+------------------+
6 rows in set (0.00 sec)
(root@localhost) [(none)]>
通过查表方式：
(root@localhost) [(none)]> select *from INFORMATION_SCHEMA.PROCESSLIST
-> ;
+-------+------+-----------------------&
最低0.47元/天 解锁文章
1796
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
