[thelist] MySQL: Changing max_allowed_packet?
Hassan Schroeder
hassan at webtuitive.com
Tue May 18 12:28:58 CDT 2004
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.
More information about the thelist
mailing list