Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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!

share|improve this question

1 Answer 1

up vote 1 down vote accepted

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. 
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.