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
> dnelson@stripped
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
