MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:alastair Date:February 22 2002 11:14am
Subject:Re: Setting net_buffer_length
View as plain text  
On Fri, Feb 22, 2002 at 10:52:14AM +0100, Martin MOKREJ? wrote:
> Hi,
>   we have 3.23.42 official binaries running on Linux 2.4.17. It seems
> mysqld does not read in from /etc/my.cnf the value for net_buffer_length.
> 
> When having in the config file:
> [mysqld]
> set-variable    = net_buffer_length=16M
> set-variable    = max_allowed_packet=16M
> [...]
> 
> I get
> | net_buffer_length               | 1047552
> | max_allowed_packet              | 16776192


I'm using 3.23.36 on Linux and posted a question yesterday about
configuration parsing, in particular the way MySQL seems to parse (or
not) the my.cnf file (I can't get it to recognise a 'log=' line in
my.cnf, to log elsewhere).


I tried doing the same as you ...

Before ;

net_buffer_length       | 16384

Add to /etc/my.cnf (in [mysqld] section) ;

set-variable = net_buffer_length=3M

After (stop/start server) ;

net_buffer_length       | 1047552


So ... at least in my version here there some difference being made. I
was expecting a figure of roughly 3Mb and not 1Mb though!

Something's flaky with configuration.

Cheers,

-- 
Alastair                   |                               |
alastair@stripped        |                               |
http://www.nucoda.com      |                               |
------------------------------------------------------------
Thread
Setting net_buffer_lengthMartin MOKREJ┼á22 Feb
  • Re: Setting net_buffer_lengthalastair22 Feb