- 1力扣热题Top100--每日两题_力扣top100
- 2pytorch利用梯度下降求方程的最小值_day2_pytorch 梯度下降法 最小化
- 3HTML 颜色_html颜色
- 4修改linux系统的root密码_linux修改root用户密码的几种方法
- 5一文快速带您了解 KMM、Compose 和 Flutter 的现状 | 开发者说·DTalk
- 6Vscode 浏览器纯 v8 环境联调 js_node 运行纯净v8
- 7【数据库】快速判断一对多，多对多关系，并建立数据库实体之间的映射_一对多关系1和n标注的位置要区分吗
- 8【Python机器学习】文本特征提取及文本向量化讲解和实战（图文解释 附源码）_文本向量化和特征提取的关系
- 9Stable-Diffusion-webui mac m1安装_installing requirements for codeformer
- 10PostgreSQL 优化器案例之 - order by limit 索引选择问题
mysql 会话查询-查看当前连接状态
赞
踩
在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
-> ;
+-------+------+-----------------------+-------+---------+------+-----------+---------------------------------------------+
| ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO |
+-------+------+-----------------------+-------+---------+------+-----------+---------------------------------------------+
| 4 | root | localhost:52778 | mysql | Sleep | 11 | | NULL |
| 1495 | root | 192.168.154.1:57040 | world | Sleep | 2100 | | NULL |
| 12671 | root | localhost | NULL | Query | 0 | executing | select *from INFORMATION_SCHEMA.PROCESSLIST |
| 13708 | root | localhost:38782 | mem | Sleep | 10 | | NULL |
| 13675 | root | localhost:38746 | mem | Sleep | 11 | | NULL |
| 13707 | root | localhost:38781 | mem | Sleep | 8 | | NULL |
| 13279 | root | localhost:38329 | mysql | Sleep | 29 | | NULL |
| 10241 | root | 192.168.154.190:51707 | world | Sleep | 868 | | NULL |
+-------+------+-----------------------+-------+---------+------+-----------+---------------------------------------------+
8 rows in set (0.00 sec)
(root@localhost) [(none)]>
当前自己的会话信息：
(root@192.168.154.190) [world]> select connection_id()
-> ;
+-----------------+
| connection_id() |
+-----------------+
| 10241 |
+-----------------+
1 row in set (0.02 sec)
(root@192.168.154.190) [world]>
然后杀死这个会话。
mysql>kill 10241
则这个会话出错。
(root@192.168.154.190) [world]> select connection_id()
-> ;
ERROR 2013 (HY000): Lost connection to MySQL server during query
(root@192.168.154.190) [world]>
显示当前所有的连接会话(包括系统的)
(root@192.168.154.190) [world]> SHOW FULL PROCESSLIST
-> ;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 14556
Current database: world
+-------+------+-----------------------+-------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+------+-----------------------+-------+---------+------+-------+-----------------------+
| 4 | root | localhost:52778 | mysql | Sleep | 9 | | NULL |
| 1495 | root | 192.168.154.1:57040 | world | Sleep | 2622 | | NULL |
| 12671 | root | localhost | NULL | Sleep | 71 | | NULL |
| 14228 | root | localhost:39316 | mysql | Sleep | 11 | | NULL |
| 14499 | root | localhost:39600 | mem | Sleep | 10 | | NULL |
| 14511 | root | localhost:39612 | mem | Sleep | 10 | | NULL |
| 14512 | root | localhost:39613 | mem | Sleep | 11 | | NULL |
| 14513 | root | localhost:39614 | mem | Sleep | 10 | | NULL |
| 14514 | root | localhost:39615 | mem | Sleep | 9 | | NULL |
| 14515 | root | localhost:39617 | mem | Sleep | 10 | | NULL |
| 14516 | root | localhost:39616 | mem | Sleep | 10 | | NULL |
| 14517 | root | localhost:39619 | mem | Sleep | 10 | | NULL |
| 14518 | root | localhost:39620 | mem | Sleep | 9 | | NULL |
| 14519 | root | localhost:39621 | mem | Sleep | 10 | | NULL |
| 14520 | root | localhost:39622 | mem | Sleep | 9 | | NULL |
| 14521 | root | localhost:39623 | mem | Sleep | 9 | | NULL |
| 14522 | root | localhost:39624 | mem | Sleep | 10 | | NULL |
| 14523 | root | localhost:39625 | mem | Sleep | 9 | | NULL |
| 14524 | root | localhost:39627 | mem | Sleep | 9 | | NULL |
| 14525 | root | localhost:39626 | mem | Sleep | 9 | | NULL |
| 14526 | root | localhost:39630 | mem | Sleep | 10 | | NULL |
| 14527 | root | localhost:39629 | mem | Sleep | 9 | | NULL |
| 14528 | root | localhost:39632 | mem | Sleep | 10 | | NULL |
| 14529 | root | localhost:39633 | mem | Sleep | 10 | | NULL |
| 14530 | root | localhost:39634 | mem | Sleep | 9 | | NULL |
| 14531 | root | localhost:39637 | mem | Sleep | 9 | | NULL |
| 14532 | root | localhost:39636 | mem | Sleep | 10 | | NULL |
| 14533 | root | localhost:39639 | mem | Sleep | 10 | | NULL |
| 14534 | root | localhost:39640 | mem | Sleep | 10 | | NULL |
| 14535 | root | localhost:39642 | mem | Sleep | 10 | | NULL |
| 14536 | root | localhost:39643 | mem | Sleep | 10 | | NULL |
| 14537 | root | localhost:39644 | mem | Sleep | 10 | | NULL |
| 14538 | root | localhost:39645 | mem | Sleep | 10 | | NULL |
| 14539 | root | localhost:39646 | mem | Sleep | 9 | | NULL |
| 14540 | root | localhost:39647 | mem | Sleep | 10 | | NULL |
| 14541 | root | localhost:39649 | mem | Sleep | 10 | | NULL |
| 14542 | root | localhost:39650 | mem | Sleep | 9 | | NULL |
| 14543 | root | localhost:39651 | mem | Sleep | 9 | | NULL |
| 14545 | root | localhost:39653 | mem | Sleep | 10 | | NULL |
| 14556 | root | 192.168.154.190:56159 | world | Query | 0 | init | SHOW FULL PROCESSLIST |
+-------+------+-----------------------+-------+---------+------+-------+-----------------------+
40 rows in set (0.04 sec)
本文仅代表作者个人观点，不代表SEO研究协会网官方发声，对观点有疑义请先联系作者本人进行修改，若内容非法请联系平台管理员，邮箱cxb5918@163.com。更多相关资讯，请到SEO研究协会网www.seoxiehui.cn学习互联网营销技术请到巨推学院www.jutuiedu.com。
