尝试在重置之前查看“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)
问题,反馈,请求 – 只是评论,谢谢!
从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.