Home / server / Questions / 244725
Accepted
blunders
Asked: 2011-03-09 07:22:10 +0800 CST

How to is MySQL's "net_buffer_length" config: viewed and reset?

  • 772

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!

mysql configuration

1 Answers

  1. Best Answer

    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.
    • 2