Re: Connection is timing out due to inactivity

[Zach Ellis]

Hello vijay jhamtani

I'm new to mysql dba so if someone more experienced comes go with them.

wait_timeout from the manual

The number of seconds the server waits for activity on a noninteractive connection before closing it. On thread startup, the session wait_timeout value is initialized from the global wait_timeout value or from the global interactive_timeout value, depending on the type of client (as
defined by the CLIENT_INTERACTIVE connect option to mysql_real_connect()). See also interactive_timeout.

sections from the manual that might help

B.3.2.9 Communication Errors and Aborted Connections

Section B.3.2.7, “MySQL server has gone away”

the sections go into more detail

but the answer might be The client had been sleeping more than wait_timeout or interactive_timeout seconds without issuing any requests to the server is one of the possibility that those sections say.

so the user if its the same user thats using three different threads might have issued a query or done something else and not have closed the connect so 8 hours later their connection was closed and killed all threads that were being used by that user.

regards
Zach Ellis