net_buffer_length can't set it

Stephan_Craft · 07-22-2009, 11:17 AM

Hello,

I try to set net_buffer_length in my.cnf
but no meter what i put in it stays the same

+-------------------+---------+
| Variable_name | Value |
+-------------------+---------+
| net_buffer_length | 1048576 |
+-------------------+---------+

"set" also doesn't work...

mysql> set net_buffer_length=256000000;
ERROR 1621 (HY000): SESSION variable 'net_buffer_length' is read-only. Use SET GLOBAL to assign the value

Stephan_Craft · 07-22-2009, 11:40 AM

mysql> set global net_buffer_length=256000000;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> show variables like 'net_buffer_length' ;
+-------------------+---------+
| Variable_name | Value |
+-------------------+---------+
| net_buffer_length | 1048576 |
+-------------------+---------+

what i'm doing wrong?

wamayall · 10-17-2011, 03:36 PM

You set a global variable, then you did NOT do:
mysql>show GOLBAL variables like '%net%';

You just did a
mysql>show variables....