From: Claudio Nanni Date: November 3 2011 8:58pm Subject: Re: setting max_allowed_packet dynamically problem List-Archive: http://lists.mysql.com/mysql/226229 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0016e64af75c56d75804b0dadbce --0016e64af75c56d75804b0dadbce Content-Type: text/plain; charset=ISO-8859-1 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 > 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 > 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 > - mdykman@stripped > > May the Source be with you. > -- Claudio --0016e64af75c56d75804b0dadbce--