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
