How do I fix the "MySQL server has gone away" error?
I'm frequently receiving the error "MySQL server has gone away" how can I fix this?
The type of error you're receiving can be caused mainly by two things. The first cause can be your server timing out and closing the connection, the second can be your server dropped a packet that was incorrect or too large. We'll go over how to adjust some values in your MySQL configuration files to correct these issues.
In order to fix your server timing out and closing your connection, you'll want to check that the
wait_timeout variable in your my.cnf file is large enough. This sets the time the server waits for activity on a non-interactive connection before closing it. If you're unfamiliar with this variable you can learn more about it through the MySQL Reference Manual.
You may also need to increase the log file size by increasing the
innodb_log_file_size variable in your my.cnf file. The default value is 48 MB, the value you'll want to increase it to will depend on what you use your server for. Something to keep in mind, setting this to a large value can lead to long recovery times after a crash.
The most common fix for this error is increasing the
max_allowed_packet variable in your my.cnf file. The default value for this is 4 MB, increasing this value to 128 MB should reduce server drops due to a too large packet. You ant to restart your MySQL server after making this change using
/etc/init.d/mysql restart. I also found thisStack Overflow post covering this topic and most users had success by increasing the
I hope this information helps! If there is anything I may have missed, feel free to leave a reply.