How to is MySQL's "net_buffer_length" config: viewed and reset?
- by blunders
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!
