Thursday, 26 February 2015

Changing max_allowed_packet on mysql :: linux

Changing max_allowed_packet

  1. Access the file /etc/mysql/my.cnf or /etc/my.cnf file and locate the line bellow
max_allowed_packet = 16M
By changing the size from this 16M to xxM will change the value of the maximum size of mysql packet

This file contains the configuration of mysql so be very carefull while modifying the file

Advice is to keep a copy of the file in another location before making any modification