3

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

Improve this question
1
  • Only the one connection.
    – Rick James
    Apr 29, 2017 at 19:33

1 Answer 1

Reset to default
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.

Improve this answer
2
  • 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 ?
    – simplifiedDB
    Apr 28, 2017 at 4:35
  • 28800 is the interactive timeout default. Batch has a different default.
    – Rick James
    Apr 29, 2017 at 19:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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