All the previous hints are correct.
I would also add: the arithmetic is only good for command line settings,
max_allowed_packet = 16*1024*1024
is not valid in the my.cnf
max_allowed_packet = 16M
is the way to go in the my.cnf
2011/11/3 Michael Dykman <mdykman@stripped>
> If you changed the value in the .cnf and restarting the server did not pick
> up he change, I would hazard a guess that the .cnf file you edited is not
> the one your server is reading.
> Check your paths and make sure you are editing the correct file. MySL
> never rewrites it's own config files to reflect manually changed values.
> On Thu, Nov 3, 2011 at 4:37 PM, List Man <list.man@stripped>
> > I am running Server version: 5.1.45-log MySQL Community Server (GPL) and
> > attempted to change max packet with the following: SET GLOBAL
> > max_allowed_packet=16*1024*1024; but it did not work properly. The
> > configuration did not change by using the show variables command. I
> > changed the configuration file (my.cnf) and restarted the server and the
> > variable stayed the same. Does anyone have any ideas?
> > LS
> - michael dykman
> - mdykman@stripped
> May the Source be with you.