Mysql Connection Sleep status issue resolved.

MySQL is always a problem yesterday, when the various programs run, the connection has been disconnected.

Causes for this problem:

1. Maximum number of connections

2. Network problems

3. mysql Server resource issues

However, none of the 3 most common questions above appear. Later, I looked at the MySQL connection status (show Processlist), found a lot of sleep state, and sleep time is very long

It is thought that is not MySQL to prevent the sleep time too long some fault-tolerant mechanism, using show variables like "%timeout%",, interactive_timeout and wait_timeout values represent Max sleep

The duration is 8 hours by default. In fact, the best procedure is not to use long connection, after the release, to ensure that the stability of the server is necessary.

Mysql Connection Sleep status issue resolved.