2

Attempt to see the "net_buffer_length" config before resetting it:

mysql> show variables like "net_buffer_length";
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| net_buffer_length | 16384 |
+-------------------+-------+
1 row in set (0.00 sec)

Attempt to reset "net_buffer_length" config:

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

Attempt to confirm the "net_buffer_length" config has been reset:

mysql> show variables like "net_buffer_length";
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| net_buffer_length | 16384 |
+-------------------+-------+
1 row in set (0.00 sec)

What's wrong with the commands I'm using that result in the config not updating?


  • MySQL Server Version: 5.1.53-community
  • DATABASE_ENGINE: INNOdb

Questions, feedback, requests -- just comment, thanks!

1 Answer 1

3

From the MySQL system variables page on net_buffer_length:

As of MySQL 5.1.31, the session value of this variable is read only. 
Before 5.1.31, setting the session value is permitted but has no effect. 

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .