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> wrote:
> I am running Server version: 5.1.45-log MySQL Community Server (GPL) and I
> 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?
- michael dykman
May the Source be with you.