mysql connection overload and death and denial of service solutions

  • 2020-05-06 11:45:37
  • OfStack

mysql connection excessive always die, then search found this article from Mysql   5. x a version, Mysql automatically shut off the free connection characteristics changed, if a connection is idle timeout to 8 hours (28000 seconds by default), once again launched Reconnect reconnect the request will not be accepted, need to establish a new connection, this leads to SER reconnection mechanism does not work: SER only USES the same connection interface when the database needs to be operated on, and disconnects to initiate a reconnection request, and SER will not be able to solve this problem in the short term:) 2. Restart Mysql server or Ser regularly (since this problem may also affect other server programs that need Mysql support, it is better to restart Mysql server, but it is difficult to determine when the Mysql server is not used). [mysqld]port   =   3306socket   =   /tmp/mysql.sockwait_timeout=   /tmp/mysql.sockwait_timeout=   /tmp/mysql. Restart the Mysqld application or add the -o   wait_timeout=500000 parameter to mysqld. At mysql client show   variable you should see the last one change from the default wait_time=28000 to 500000. You may need to restart the machine if restarting Mysqld does not work)

Related articles: