MySQL Forums
Forum List  »  Newbie

Re: Connection is timing out due to inactivity
Posted by: Zach Ellis
Date: October 03, 2023 06:47PM

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

Options: ReplyQuote


Subject
Written By
Posted
Re: Connection is timing out due to inactivity
October 03, 2023 06:47PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.