3

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

simplifiedDB
  • 679
  • 6
  • 18
  • 36

1 Answers1

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.

Phanindra
  • 1,007
  • 5
  • 15
  • 31