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!