21 Oct
2010
21 Oct
'10
1:25 a.m.
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/