This article is half-done without your Comment! *** Please share your thoughts via Comment ***
ERROR 2006 (HY000:) MySQL server has gone away.
Generally, when we are dealing with large column’s queries and values, MySQL raises this kind of error.
max_allowed_packet:
To resolve this error, we should look into this parameter of MySQL Server.Whenever we require to process big binary string like BLOB column, we should increase the value of this variable.
The solution of this error is to increase the value of max_allowed_packet parameter.
The default value is 16MB.
You can add below line into my.cnf file:
|
1 |
max_allowed_packet=64M |
After this change, You must restart the MySQL service.
