A single SQL statement submitted to the MySQL server constitutes a communication packet. One gigabyte is the maximum packet size that can be delivered to a MySQL server. The MySQL server displays the error shown below when it gets a packet larger than the maximum amount permitted.<\/p>\n\n\n\n
MySQL said: Documentation
#1153 \u2013 Got a packet bigger than \u2018max_allowed_packet\u2019 bytes<\/p>\n\n\n\n
At times you might loose connectivity with mysql server if the packet is too large. Both client & server has a threshold of max packet size, so if you want to handle big packets, you must increase the variable limits on the server.<\/p>\n\n\n\n
Open the file below on your server. You cannot increase the limits on\u00a0shared hosting\u00a0OR\u00a0reseller hosting\u00a0plans.<\/p>\n\n\n\n
# vi \/etc\/my.cnf<\/strong><\/p>\n\n\n\n The\u00a0limit\u00a0can\u00a0be\u00a0raised\u00a0to\u00a0suit\u00a0your\u00a0needs. We\u00a0will\u00a0set\u00a0it\u00a0to\u00a016MB\u00a0right\u00a0now. Here\u00a0are\u00a0the\u00a0items\u00a0you\u00a0must\u00a0include\u00a0in\u00a0the\u00a0MySQL\u00a0configuration\u00a0file.<\/p>\n\n\n\n max_allowed_packet=16M<\/strong><\/p>\n\n\n\n Save the file & exit. Restart mysql. # mysqladmin variables | grep max_allowed_packet<\/strong><\/p>\n\n\n\n You can configure custom mysql variables as required with our VPS hosting\u00a0&\u00a0dedicated server\u00a0plans.<\/p>\n","protected":false},"excerpt":{"rendered":" A single SQL statement submitted to the MySQL server constitutes a communication packet. One gigabyte is the maximum packet size that can be delivered to a MySQL server. The MySQL server displays the error shown below when it gets a packet larger than the maximum amount permitted. MySQL said: Documentation#1153 \u2013 Got a packet bigger […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":23377,"menu_order":472,"comment_status":"closed","ping_status":"closed","template":"","doc_tag":[],"class_list":["post-10440","docs","type-docs","status-publish","hentry","no-post-thumbnail"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/docs\/10440","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/comments?post=10440"}],"version-history":[{"count":2,"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/docs\/10440\/revisions"}],"predecessor-version":[{"id":10443,"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/docs\/10440\/revisions\/10443"}],"up":[{"embeddable":true,"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/docs\/23377"}],"wp:attachment":[{"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/media?parent=10440"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/doc_tag?post=10440"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
You can check the increased limit with command.<\/p>\n\n\n\n