如何是MySQL的“net_buffer_length”configuration:查看和重置?

尝试在重置之前查看“net_buffer_length”configuration

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

尝试重置“net_buffer_length”configuration:

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

尝试确认“net_buffer_length”configuration已被重置:

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

我使用的命令有什么问题导致configuration不能更新?


  • MySQL服务器版本: 5.1.53-社区
  • DATABASE_ENGINE: INNOdb

问题,反馈,请求 – 只是评论,谢谢!

net_buffer_length上的MySQL系统variables页面 :

 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.