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=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? > > 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. > > -- > Dan Nelson > dnel...@allantgroup.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=list....@bluejeantime.com > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
