On Mon, Nov 29, 2004 at 11:50:20AM -0700, Sasha Pachev wrote:

Hi,

> >Hello,
> >
> >For a few servers with > 1000 concurrent connections, 
> >I've compiled glibc 2.3.3 with a patched STACK_SIZE in
> >linuxthreads/descr.h :
> >
> >#ifndef STACK_SIZE
> >#define STACK_SIZE  (128 * 1024)
> >#endif
> >
> >instead of #define STACK_SIZE  (2 * 1024 * 1024)
> >
> >This by the hints on the Documentation @ mysql.com
> >
> >But, now I notice:
> >
> >041125 15:15:34  mysqld started
> >041125 15:15:34 Warning: Asked for 196608 thread stack, but got 126976
> >041125 15:15:35  InnoDB: Started
> >/usr/local/mysql/libexec/mysqld: ready for connections.
> >
> >
> >Is the 128K STACK_SIZE I've built glibc with too little, and should I
> >update it to 256K ?
> 
> Originally, MySQL team believed 128K was sufficient. Then some time later 
> it was discovered that some DNS resolving routines required a 192K stack in 
> some cases. So for safety reasons, mysqld was modified to request at least 
> 192K stack. In your case, your modification to glibc makes it impossible 
> for it to have a 192K stack, which is why you are getting the message. 
> However, if you run mysqld with --skip-name-resolve (you will need to 
> update your priv tables to use numeric addresses), glibc DNS routines are 
> never called, so  128K should be sufficient.

I see :)

With MySQL 4.1.8 and higher, I need to use a stack_size of at least 256K, 
else MySQL segfaults (signal 11) when started. This is with gcc-3.3.5 and 
glibc-2.3.3.

Maybe something you guys should look into this some more, since 
it really boosts performance :)

Also, I have one other question regarding this:

When building with --with-other-libc, the build automatically changes to
a static build. But, when using OpenSSL, it _must be_ a dynamic build, 
according to the configure-script. 

Does anyone have a clue on howto built with a custom glibc, but also
have OpenSSL-support ? I really need it :)

Thanks !

Kind regards,

-- 
WideXS                          http://www.widexs.nl
Wouter de Jong                  System-Administrator
Tel +31 (0)23 5698070           Fax +31 (0)23 5698099
Bijlmermeerstraat 62,           2131 HG  HOOFDDORP, NL

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to