All the previous hints are correct. I would also add: the arithmetic is only good for command line settings, something like:
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 Cheers Claudio 2011/11/3 Michael Dykman <mdyk...@gmail.com> > 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....@bluejeantime.com> > 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? > > > > LS > > > > > > > > > > > -- > - michael dykman > - mdyk...@gmail.com > > May the Source be with you. > -- Claudio
