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/