Skip to main content

Posts

Showing posts with the label MySQL server has gone away

SQL Native Error Code '2006' MySQL server has gone away

This error means that your application (client) has lost the connection to mysql server when a session is exceeding the time out limit while idle you will hit this error or when there are network issues and packet loss. (you can define the packet size that above it this error is raised) so - go you you cnf file (the standard is my.cnf) unless you've changed it look for these parameters and use appropriate values per your needs. wait-timeout                   = 31536000 max-allowed-packet             = 32M if your mysql server is already running and you don't want to restart it, these parameters can be changed on the fly (dynamic parameters) you should use SET GLOBAL/SESSION command to change them full list of dynamic parameters: http://dev.mysql.com/doc/refman/5.7/en/dynamic-system-variables.html Enjoy