From: Michael Dykman Date: November 3 2011 8:43pm Subject: Re: setting max_allowed_packet dynamically problem List-Archive: http://lists.mysql.com/mysql/226227 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=14dae9340d4bb1b7aa04b0daa397 --14dae9340d4bb1b7aa04b0daa397 Content-Type: text/plain; charset=ISO-8859-1 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. --14dae9340d4bb1b7aa04b0daa397--