interactive_timeout

最新推荐文章于 2024-04-24 15:38:09 发布
最新推荐文章于 2024-04-24 15:38:09 发布
阅读量78 收藏
点赞数
文章标签： 数据库
原文链接：http://www.cnblogs.com/zengkefu/p/5651964.html
版权 
[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,退去

 

转载于:https://www.cnblogs.com/zengkefu/p/5651964.html

weixin_30408165
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
MySQL中的配置参数interactive_timeout和wait_timeout(可能导致过多sleep进程的两个参数)...
weixin_30778805的博客
04-28 870
1)interactive_timeout:参数含义：服务器关闭交互式连接前等待活动的秒数。交互式客户端定义为在mysql_real_connect()中使用CLIENT_INTERACTIVE选项的客户端。参数默认值：28800秒（8小时）(2)wait_timeout:参数含义：服务器关闭非交互连接之前等待活动的秒数。在线程启动时，根据全局wait_timeout值或全局interactive...
MySQL中wait_timeout与interactive_timeout详解
热门推荐
小小默：进无止境
06-05 1万+
【1】分别是什么 ① interactive_timeout 官网说明如下： MySQL服务器关闭交互式连接前等待的秒数。交互式客户端定义为在mysql_real_connect()中使用CLIENT_INTERACTIVE选项的客户端。参数默认值：28800秒（8小时） ② wait_timeout MySQL服务器关闭非交互连接之前等待的秒数。在会话启动时，根据全局wai...
MySQL中的interactive_timeout和wait_timeout
最新发布
Mr_lee_1的博客
04-24 1080
参数指定了交互式连接的超时时间，即当一个客户端连接到 MySQL 服务器时，在该连接处于空闲状态并且没有发出任何查询或者交互操作时，服务器等待的时间长度。参数也是控制连接超时的一个参数，它指定了非交互式连接的超时时间。：适用于用户和数据库服务器之间有交互操作的连接，例如命令行客户端连接或者用户通过应用程序与数据库服务器进行交互的连接。：适用于没有用户交互操作的连接，例如应用程序和数据库服务器之间的连接。：可以通过以下 SQL 命令查看当前的。的值，MySQL 会自动关闭连接。：可以通过以下方式之一来设置。
mysql小知识点---interactive_timeout和wait_timeout区别
zys1440298847的博客
03-18 530
定义了对于交互式连接（比如使用cmd命令窗口或者在linux上连接msyql），服务器等待的最大时间，如果超过这个时间，服务端仍然没有受到数据，则会关闭连接；【我理解设置该参数的目的，就是为了减少mysql服务器端不必要的空闲长连接】定义的是非交互连接，比如jdbc，功能和interactive_timeout一样，都是为了让客户端超过一定时间以后就被动关闭；这2个参数的默认值都是28800s，即8小时；
MySQL中interactive_timeout和wait_timeout的区别
09-12 128
在用mysql客户端对数据库进行操作时，打开终端窗口，如果一段时间没有操作，再次操作时，常常会报如下错误： ERROR 2013 (HY000): Lost connection to MySQL server during query ERROR 2006 (HY000): MySQL server has gone away No connect...
如何修改mysql数据库的max_allowed_packet参数
09-10
在MySQL数据库中，`max_allowed_packet` 是一个非常重要的参数，它定义了客户端与服务器之间可以传输的最大数据包大小。这个参数对处理大数据操作，如导入大文件、执行大查询或者传输大对象（如BLOB或TEXT列）时至关...
mysql提示got timeout reading communication packets的解决方法
09-09
在MySQL中，有两个重要的超时参数：`interactive_timeout`和`wait_timeout`。默认情况下，`interactive_timeout`是28800秒（8小时），而`wait_timeout`是120秒。这两个参数分别控制交互式会话（如MySQL客户端）和非...
SQL查询超时的设置方法(关于timeout的处理)
12-15
通过对`connect_timeout`、`interactive_timeout`、`wait_timeout`等参数的调整，可以更好地控制连接的生命周期，防止因长时间无响应导致的问题，并确保系统能够有效地处理各种查询。在进行调整时，务必根据实际情况...
interactive_timeout，wait_timeout参数
weixin_40524659的博客
02-21 496
interactive_timeout：服务器关闭交互式连接前等待活动的时间，默认是28800（8小时） wait_timeout：服务器关闭非交互式连接之前等待的活动时间，默认是28800（8小时） 说明：这两个参数一定要一起调整，并且值要一致，网上建议调整为300~600秒，不具有 参考性，我司生产配置72小时。即不主动关闭客户端请求。 innodb_flush_method：这个参数影响in...
MySQL连接超时相关的两个参数interactive_timeout和wait_timeout的区别和解释
做最专业的总结 大师
09-04 1万+
1、interactive_timeout针对交互式连接，wait_timeout针对非交互式连接。所谓的交互式连接，即在mysql_real_connect()函数中使用了CLIENT_INTERACTIVE选项。      说得直白一点，通过mysql客户端连接数据库是交互式连接，通过jdbc连接数据库是非交互式连接。 interactive_timeout：交互式连接超时时间(mysql工...
MySQL连接空闲时间超过8小时报错原因与延伸知识
BASK2311的博客
04-14 1317
当一个连接处于交互状态时，MySQL服务器在关闭连接之前等待的秒数。：当一个连接处于空闲状态时，MySQL服务器在关闭连接之前等待的秒数。这种问题不仅出现在访问MySQL时，在访问其它一些数据源时也可能出现这个问题，例如ES与MongoDB等等。根据上述原因分析我们知道，解决方案核心是设置合理的连接池连接超时时间，本章节通过Druid连接池进行说明。MySQL通过wait_timeout维护连接A超时时间等于8小时。，当申请连接的时候检测，如果空闲时间大于。连接池认为连接A可用，继续使用连接A。
wait_timeout 和 interactive_timeout
weixin_30607029的博客
09-26 323
wait_timeout 和 interactive_timeout Table of Contents 1. 参数说明 2. 原代码 3. interactive_timeout覆盖wait_timeout 4. 总结 1 参数说明 这里简单解释一下两个参数含义如下： interactive_timeout：对于交互式客户端创建的...
Mysql interactive_timeout和wait_timeout参数
hbhe0316的专栏
11-28 3870
官网解释:https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html https://www.cndba.cn/hbhe0316/article/22633 https://www.cndba.cn/hbhe0316/article/22633https://www.cndba.cn/hbh...
mysql设置interactive_设置Mysql的连接超时参数wait_timeout、interactive_timeout
weixin_39601929的博客
01-28 1017
交互式操作：通俗的说，就是你在你的本机上打开mysql的客户端，就是那个黑窗口，在黑窗口下进行各种sql操作，当然走的肯定是tcp协议。非交互式操作：就是你在你的项目中进行程序调用。比如一边是tomcat web服务器，一边是数据库服务器，两者怎么通信？在java web里，我们通常会选择hibernate或者是jdbc来连接。那么这时候就是非交互式操作。在之前，我基本上不关系这两个属性，都是用的...
MySQL 的连接时长控制--interactive_timeout和wait_timeout
翔云
10-13 1万+
在用MySQL客户端对数据库进行操作时，如果一段时间没有操作，再次操作时，常常会报如下错误： ERROR 2013 (HY000): Lost connection to MySQL server during query ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... 这...
mysql 5.6 interactive_timeout_mysql wait_timeout interactive_timeout 详解
weixin_34378978的博客
01-27 339
查看mysql server超时时间：msyql> show global variables like '%timeout%';设置mysql server超时时间(以秒为单位)：最小设置msyql> set global wait_timeout=28800;msyql> set global interactive_timeout=28800;mysql默认是28800，...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值