What is the difference between setting the max_allowed_packet
via the MySQL commandline using:
set global max_allowed_packet=100000000;
And setting it by editing the MySQL my.ini (Win) or my.cnf (Linux) config and putting the following code under [mysqld]
:
max_allowed_packet=100M