|
你好~ 请教个问题，我们业务客户端在连接时候出现 “The client was disconnected by the server because of inactivity.” ，请问是什么问题导致的，他们之前习惯是用5.7版本，是啊不是他们要升级什么驱动或者设置需要改啥的~ 还有个现象就是show process 没有出现业务连接~，是不是都被服务端进程给kill 了~ 以下是timeout 参数 +------------------------------------------+----------+ | Variable_name | Value | +------------------------------------------+----------+ | connect_timeout | 10 | | delayed_insert_timeout | 300 | | have_statement_timeout | YES | | innodb_flush_log_at_timeout | 1 | | innodb_lock_wait_timeout | 10 | | innodb_print_lock_wait_timeout_info | ON | | innodb_rollback_on_timeout | ON | | interactive_timeout | 600 | | lock_wait_timeout | 600 | | mysqlx_connect_timeout | 30 | | mysqlx_idle_worker_thread_timeout | 60 | | mysqlx_interactive_timeout | 28800 | | mysqlx_port_open_timeout | 0 | | mysqlx_read_timeout | 30 | | mysqlx_wait_timeout | 28800 | | mysqlx_write_timeout | 60 | | net_read_timeout | 30 | | net_write_timeout | 60 | | parallel_queue_timeout | 0 | | replica_net_timeout | 60 | | rpl_stop_replica_timeout | 31536000 | | rpl_stop_slave_timeout | 31536000 | | secondary_engine_read_delay_wait_timeout | 60 | | slave_net_timeout | 60 | | ssl_session_cache_timeout | 300 | | thread_pool_idle_timeout | 60 | | wait_timeout | 600 | +------------------------------------------+----------+ 27 rows in set (0.00 sec) |
|
|
caihe.li
2025-3-20 10:03:27
| |
|
|
yejr
2025-3-20 10:23:04
| |
|
|
reddey
2025-3-20 14:29:25
| |
|
一个学艺不精的国产数据库爱好者
|
||
|
|
caihe.li
2025-3-21 10:40:58
| |
合作电话：010-64087828
社区邮箱：greatsql@greatdb.com
