From: List Man Date: November 3 2011 8:57pm Subject: Re: setting max_allowed_packet dynamically problem List-Archive: http://lists.mysql.com/mysql/226228 Message-Id: MIME-Version: 1.0 (Apple Message framework v1084) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Thanks for the explanation. LS On Nov 3, 2011, at 4:41 PM, Dan Nelson wrote: > In the last episode (Nov 03), List Man said: >> 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=3D16*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? >=20 > SET GLOBAL changes the server's default runtime value. Any new = connections > will get that value, but existing connections will not change. When = the > server restarts, it will fall back to whatever you have set in my.cnf, = or > the default value if you don't have anything in my.cnf. >=20 > --=20 > Dan Nelson > dnelson@stripped >=20 > --=20 > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: = http://lists.mysql.com/mysql?unsub=3Dlist.man@stripped >=20