Set Mysql connection timeout parameters

Set the Mysql connection timeout parameter in the default settings of Mysql. If a database connection is not used for more than 8 hours (idle for 8 hours, that is, 28800 seconds), mysqlserver will automatically disconnect this connection, subsequent query operations on the connection will fail, and the following error occurs: error2006 (MySQLserverhasgoneaway )!. View mysqlse

Set the Mysql connection timeout parameter in the default settings of Mysql. If a database connection is not used for more than 8 hours (idle for 8 hours, that is, 28800 seconds), mysql server will automatically disconnect this connection, subsequent query operations on the connection will fail, and error 2006 (MySQL server has gone away) will occur )!. View mysql se

Set Mysql connection timeout parameters
In the default settings of Mysql, if a database connection is not used for more than 8 hours (idle for 8 hours, that is

28800 s), mysql server will take the initiative to disconnect this connection, and subsequent query operations on this connection will fail

Error 2006 (MySQL server has gone away )!.

View mysql server Timeout:

Msyql> show global variables like '% timeout % ';

Set mysql server timeout (in seconds ):

Msyql> set global wait_timeout = 10;

Msyql> set global interactive_timeout = 10;