mysql提示Lost connection to MySQL server during query

[一点OK]

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

各种全局变量都设置了；

0

1

17:15:35

SELECT *FROM............... LIMIT 0, 1000

Error Code: 2013. Lost connection to MySQL server during query

30.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;

[CSDN-Ada助手]

您可以前往 CSDN问答-大数据 发布问题, 以便更快地解决您的疑问