interactive_timeout
2024-03-04 06:06:23
[mysqld]
interactive_timeout=20
交互式连接
会话1
[root@localhost ~]# mysql -umysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.28-debug-log Source distribution Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
会话2
mysql> show full processlist;
+----+-------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+-----------+------+---------+------+-------+-----------------------+
| 8 | root | localhost | NULL | Query | 0 | init | show full processlist |
| 10 | mysql | localhost | NULL | Sleep | 8 | | NULL |
+----+-------+-----------+------+---------+------+-------+-----------------------+
2 rows in set (0.00 sec) mysql> show full processlist;
+----+-------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+-----------+------+---------+------+-------+-----------------------+
| 8 | root | localhost | NULL | Query | 0 | init | show full processlist |
| 10 | mysql | localhost | NULL | Sleep | 9 | | NULL |
+----+-------+-----------+------+---------+------+-------+-----------------------+
2 rows in set (0.00 sec) mysql> show full processlist;
+----+-------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+-----------+------+---------+------+-------+-----------------------+
| 8 | root | localhost | NULL | Query | 0 | init | show full processlist |
| 10 | mysql | localhost | NULL | Sleep | 9 | | NULL |
+----+-------+-----------+------+---------+------+-------+-----------------------+
2 rows in set (0.00 sec) mysql> show full processlist;
+----+-------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+-----------+------+---------+------+-------+-----------------------+
| 8 | root | localhost | NULL | Query | 0 | init | show full processlist |
| 10 | mysql | localhost | NULL | Sleep | 10 | | NULL |
+----+-------+-----------+------+---------+------+-------+-----------------------+
2 rows in set (0.00 sec) mysql> show full processlist;
+----+-------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+-----------+------+---------+------+-------+-----------------------+
| 8 | root | localhost | NULL | Query | 0 | init | show full processlist |
| 10 | mysql | localhost | NULL | Sleep | 10 | | NULL |
+----+-------+-----------+------+---------+------+-------+-----------------------+
2 rows in set (0.00 sec) mysql> show full processlist;
+----+-------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+-----------+------+---------+------+-------+-----------------------+
| 8 | root | localhost | NULL | Query | 0 | init | show full processlist |
| 10 | mysql | localhost | NULL | Sleep | 11 | | NULL |
+----+-------+-----------+------+---------+------+-------+-----------------------+
2 rows in set (0.01 sec) mysql> show full processlist;
+----+-------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+-----------+------+---------+------+-------+-----------------------+
| 8 | root | localhost | NULL | Query | 0 | init | show full processlist |
| 10 | mysql | localhost | NULL | Sleep | 12 | | NULL |
+----+-------+-----------+------+---------+------+-------+-----------------------+
2 rows in set (0.00 sec) mysql> show full processlist;
+----+-------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+-----------+------+---------+------+-------+-----------------------+
| 8 | root | localhost | NULL | Query | 0 | init | show full processlist |
| 10 | mysql | localhost | NULL | Sleep | 12 | | NULL |
+----+-------+-----------+------+---------+------+-------+-----------------------+
2 rows in set (0.00 sec) mysql> show full processlist;
+----+-------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+-----------+------+---------+------+-------+-----------------------+
| 8 | root | localhost | NULL | Query | 0 | init | show full processlist |
| 10 | mysql | localhost | NULL | Sleep | 13 | | NULL |
+----+-------+-----------+------+---------+------+-------+-----------------------+
2 rows in set (0.00 sec) mysql> show full processlist;
+----+-------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+-----------+------+---------+------+-------+-----------------------+
| 8 | root | localhost | NULL | Query | 0 | init | show full processlist |
| 10 | mysql | localhost | NULL | Sleep | 14 | | NULL |
+----+-------+-----------+------+---------+------+-------+-----------------------+
2 rows in set (0.00 sec) mysql> show full processlist;
+----+-------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+-----------+------+---------+------+-------+-----------------------+
| 8 | root | localhost | NULL | Query | 0 | init | show full processlist |
| 10 | mysql | localhost | NULL | Sleep | 14 | | NULL |
+----+-------+-----------+------+---------+------+-------+-----------------------+
2 rows in set (0.01 sec) mysql> show full processlist;
+----+-------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+-----------+------+---------+------+-------+-----------------------+
| 8 | root | localhost | NULL | Query | 0 | init | show full processlist |
| 10 | mysql | localhost | NULL | Sleep | 15 | | NULL |
+----+-------+-----------+------+---------+------+-------+-----------------------+
2 rows in set (0.00 sec) mysql> show full processlist;
+----+-------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+-----------+------+---------+------+-------+-----------------------+
| 8 | root | localhost | NULL | Query | 0 | init | show full processlist |
| 10 | mysql | localhost | NULL | Sleep | 16 | | NULL |
+----+-------+-----------+------+---------+------+-------+-----------------------+
2 rows in set (0.00 sec) mysql> show full processlist;
+----+-------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+-----------+------+---------+------+-------+-----------------------+
| 8 | root | localhost | NULL | Query | 0 | init | show full processlist |
| 10 | mysql | localhost | NULL | Sleep | 16 | | NULL |
+----+-------+-----------+------+---------+------+-------+-----------------------+
2 rows in set (0.00 sec) mysql> show full processlist;
+----+-------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+-----------+------+---------+------+-------+-----------------------+
| 8 | root | localhost | NULL | Query | 0 | init | show full processlist |
| 10 | mysql | localhost | NULL | Sleep | 17 | | NULL |
+----+-------+-----------+------+---------+------+-------+-----------------------+
2 rows in set (0.00 sec) mysql> show full processlist;
+----+-------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+-----------+------+---------+------+-------+-----------------------+
| 8 | root | localhost | NULL | Query | 0 | init | show full processlist |
| 10 | mysql | localhost | NULL | Sleep | 18 | | NULL |
+----+-------+-----------+------+---------+------+-------+-----------------------+
2 rows in set (0.00 sec) mysql> show full processlist;
+----+-------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+-----------+------+---------+------+-------+-----------------------+
| 8 | root | localhost | NULL | Query | 0 | init | show full processlist |
| 10 | mysql | localhost | NULL | Sleep | 18 | | NULL |
+----+-------+-----------+------+---------+------+-------+-----------------------+
2 rows in set (0.00 sec) mysql> show full processlist;
+----+-------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+-----------+------+---------+------+-------+-----------------------+
| 8 | root | localhost | NULL | Query | 0 | init | show full processlist |
| 10 | mysql | localhost | NULL | Sleep | 19 | | NULL |
+----+-------+-----------+------+---------+------+-------+-----------------------+
2 rows in set (0.00 sec) mysql> show full processlist;
+----+-------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+-----------+------+---------+------+-------+-----------------------+
| 8 | root | localhost | NULL | Query | 0 | init | show full processlist |
| 10 | mysql | localhost | NULL | Sleep | 20 | | NULL |
+----+-------+-----------+------+---------+------+-------+-----------------------+
2 rows in set (0.00 sec) mysql> show full processlist;
+----+------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------+------+---------+------+-------+-----------------------+
| 8 | root | localhost | NULL | Query | 0 | init | show full processlist |
+----+------+-----------+------+---------+------+-------+-----------------------+
1 row in set (0.00 sec) 20秒钟后,会话1,退去
最新文章
- POJ 1753. Flip Game 枚举or爆搜+位压缩，或者高斯消元法
- PHP基础知识之对象复制
- 跟着思维导图学习javascript
- TCSQL实时列表缓存数据库帮助文档
- i-doit
- 【Hadoop学习】Apache Hadoop ResourceManager HA
- Django的请求流程(url)
- Swift - 37 - 值类型和引用类型的简单理解
- Journey
- 多线程下QAxObject指针为NULL的解决办法
- AX3298添加新sensor
- Spring Boot 的 10 个核心模块
- Redis 持久化之RDB和AOF
- linux学习笔记整理（一）
- git bash中的快捷键
- skyline添加wfs服务时，弹出错误“no layers were found”!
- mysql查看当前执行线程_关闭当前的某些线程 show processlist_kill
- eclipse的Git忽略某些不需要提交的文件
- list中null或者空的区别
- Scala学习(七)---包和引入