Na página de variáveis do sistema MySQL em 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.
Tente ver a configuração "net_buffer_length" antes de redefini-la:
mysql> show variables like "net_buffer_length";
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| net_buffer_length | 16384 |
+-------------------+-------+
1 row in set (0.00 sec)
Tente redefinir a configuração "net_buffer_length":
mysql> set global net_buffer_length=1000000;
Query OK, 0 rows affected (0.00 sec)
Tentativa de confirmar que a configuração "net_buffer_length" foi redefinida:
mysql> show variables like "net_buffer_length";
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| net_buffer_length | 16384 |
+-------------------+-------+
1 row in set (0.00 sec)
Perguntas, comentários, pedidos - apenas comente, obrigado!
Na página de variáveis do sistema MySQL em 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.
Tags mysql configuration