mysql提示Lost connection to MySQL server during query

一点OK 2021-11-25 17:23:36

我的mysql查询为什么一超过30秒就提示 Lost connection to MySQL server during query

各种全局变量都设置了;

0117:15:35SELECT *FROM............... LIMIT 0, 1000Error Code: 2013. Lost connection to MySQL server during query30.015 sec

show global variables like '%timeout%';
SET GLOBAL connect_timeout = 43200;
SET GLOBAL connect_timeout = 43200;

SET GLOBAL delayed_insert_timeout = 43200;
SET GLOBAL innodb_lock_wait_timeout = 43200;

SET GLOBAL interactive_timeout = 43200;

SET GLOBAL mysqlx_connect_timeout = 43200;

SET GLOBAL mysqlx_interactive_timeout = 43200;

SET GLOBAL mysqlx_idle_worker_thread_timeout = 43200;

SET GLOBAL mysqlx_interactive_timeout = 43200;

SET GLOBAL mysqlx_read_timeout = 43200;

SET GLOBAL mysqlx_wait_timeout = 43200;

SET GLOBAL mysqlx_write_timeout = 43200;

SET GLOBAL net_read_timeout = 43200;

SET GLOBAL net_write_timeout = 43200;

SET GLOBAL mysqlx_write_timeout = 43200;

SET GLOBAL rpl_stop_slave_timeout = 31536000;

SET GLOBAL slave_net_timeout = 43200;

SET GLOBAL wait_timeout = 43200;

...全文
576 回复 打赏 收藏 举报
写回复
回复
切换为时间正序
请发表友善的回复…
发表回复
发帖
非技术区

421

社区成员

非技术问题的乐园
社区管理员
  • 非技术区社区
加入社区
帖子事件
创建了帖子
2021-11-25 17:23
社区公告
暂无公告