DB wait_timeout

[Wayne Workman]

I’ve just learned about this MySQL / MariaDB setting. The wait_timeout.

I’m not sure if FOG sets this or not, but my FOG server’s wait_timeout is set to 8 hours.

Can someone running Ubuntu 14.04 or 15.04 check what their wait_timeout is please?

mysql
SHOW VARIABLES;

The wait_timeout variable is towards the bottom, it’s in seconds.

[Sebastian Roth]

@Wayne-Workman Same here, 8 hours on Debian! Are you concerned about it being that high or what especially made you aware of this setting. My guess is that MySQL connections that don’t get any input for 8 hours straight will be terminated from the server side. All good I reckon!

[Wayne Workman]

I don’t really know lol. I stumbled across it working on a dhcp service manager for fog. Then I started thinking about how the fog database has a bad habit of crashing on Ubuntu…

[Raymond Bell]

@Wayne-Workman

Ubuntu 14.04

| version_compile_os                                | debian-linux-gnu                                                                                                       |
| wait_timeout                                      | 28800