Re: Change wait_timeout parameter

[Rick James]

Let's look at it from another point of view. What will happen if there is a glitch in the network? The connection will be lost. What will the client do? It will probably issue a commend and die. Instead, it should
* issue the command
* get a trap
* discover that the trap was because "mysql server has gone away"
* then reconnect and continue.

Once you have implemented that 'recovery' code, you can easily set wait_timeout to something civilized, like 30 (seconds).

A note: SHOWing or SETting wait_timeout may or may not set the desired session/global interactive/batch value. Recommend changing my.cnf/my.ini and restarting. (After all, you are restarting nightly, now.)