[thelist] MySQL: Changing max_allowed_packet?

[Hassan Schroeder]

Frank wrote:

> Is there a way to change max_allowed_packet on the fly?  I know I can 
> restart using
> 
> ./safe_mysqld -O max_allowed_packet=32M
> 
> I'd like to know if there's a way of changing the variables without 
> having to reboot mysql.

Well, this *seems* to work --

mysql> show variables like 'max%' ;

+-----------------------+------------+
| Variable_name         | Value      |
+-----------------------+------------+
| max_allowed_packet    | 1048576    |
...

mysql> set max_allowed_packet = 1500000;
Query OK, 0 rows affected (0.03 sec)

mysql> show variables like 'max%' ;
+-----------------------+------------+
| Variable_name         | Value      |
+-----------------------+------------+
| max_allowed_packet    | 1499136    |
...

but you'd have to test to see if it really was taking effect :-)

HTH!
-- 
Hassan Schroeder ----------------------------- hassan at webtuitive.com
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com

                           dream.  code.