2

Do wait_timeout session clear all running session or only sessions which are in SLEEP mode for specified seconds ?

  • Only the one connection. – Rick James Apr 29 '17 at 19:33
0

Wait Timeout is a variable which represent the time in seconds that MySQL will wait and kill the session if it is in idle/sleep state.

Default value is 28000 secs. If you want to change the wait time value, you also need to change the interactive_timeout variable.

There will be no active sessions with this time interval. If your session is showing as active and some activity is happening so long, then there is issue with the session.

  • default value is 28800 seconds . why do i need to change interactive_timeout variable , if i am changing wait_timeout ? I cannot understand your 3rd part.Can you please explain more ? – Ankit Kapoor Apr 28 '17 at 4:35
  • 28800 is the interactive timeout default. Batch has a different default. – Rick James Apr 29 '17 at 19:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.