3.设置全局变量connect_timeout为12小时(12*3600=43200) MySQL [(none)]> SET GLOBAL connect_timeout = 43200; Query OK, 0 rows affected (0.00 sec) 4.再次查看,确认参数是否修改成功 MySQL [(none)]> show global variables like '%timeout%'; +---+---+ | Variable_name | Value | +---+-...
3.设置全局变量connect_timeout为12小时(12*3600=43200) MySQL [(none)]> SET GLOBAL connect_timeout = 43200; Query OK, 0 rows affected (0.00 sec) 4.再次查看,确认参数是否修改成功 MySQL [(none)]> show global variables like '%timeout%'; +---+---+ | Variable_name | Value | +---+-...
MySQL修改connect_timeout(连接超时)全局变量telnet 测试数据库的连接超时时间 telnet 10.5.36.* 3306 1.登录mysql数据库 [root@iZbp11rfoyeescusr9ha9qZ conf]# mysql -u root -p 2.查询匹配“timeout”的全局变量 MySQL [(none)]> show global variables like '%timeout%';+---+---+ | Variable...