WinSQL » Knowledge base

Details


By default, MySQL server terminates a client connection after 28800 seconds of inactivity. Often database administrators change this value to a lower number. This results in a broken connection if the user does not submit any query for a long period of time.

Type the following query to see what the current setting is for this variable.

SHOW VARIABLES like 'interactive_timeout'

In addition to 'interactive_timeout', you might also want to check the value for 'wait_timeout. Refer to MySQL documentation for a detailed description of these parameters.

To set a new value for these parameters, you can use the SET command. For example:

SET interactive_timeout=32000

IMPORTANT: There is no configuration setting in WinSQL (the client) that automatically terminates a connection. Therefore, the only way to fix this problem is to change the configuration parameter on the server.


Navigation

Social Media

Powered by 10MinutesWeb.com