On 10/20/2010 11:33 AM, Ludovic Dubost wrote: > On a side note concerning the max_allowed_packet issue in MySQL, I was > able to change that value at runtime (from the mysql console). If this > also works using a remote connection, maybe we could hack and force a > big value at runtime.
How? mysql> show variables like 'max_allow%'; +--------------------+----------+ | Variable_name | Value | +--------------------+----------+ | max_allowed_packet | 10485760 | +--------------------+----------+ 1 row in set (0.00 sec) mysql> set max_allowed_packet=40000000; ERROR 1621 (HY000): SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value mysql> set global max_allowed_packet=40000000; Query OK, 0 rows affected (0.00 sec) mysql> show variables like 'max_allow%'; +--------------------+----------+ | Variable_name | Value | +--------------------+----------+ | max_allowed_packet | 10485760 | +--------------------+----------+ 1 row in set (0.00 sec) No effect, the variable is unchanged. -- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
