Alex Coke-Smyth wrote:
> max_connections=300
>
> basically anything over 256 ends up giving the error :
>
> Can't create a new thread (errno 11). If you are not out of available
> memory, you can consult the manual for a possible OS-dependent bug
>
> after 256 connections are open.
>
> There is plenty of memory available and checking the docs says you
> should be able to get up to 1500 :
>
> "If you are using our binary or RPM version 3.23.25 or later, you can
> safely set
> `max_connections' at 1500"
>
>
> using a linux 2.2.19 kernel and glibc2.1.
>
> Has anyone experienced this problem or know how I can get around it?
Yes sure! This is limit of linux 2.2.x kernel. Upgrade to 2.4.x OR
change values in file limits.h of linux 2.2.x kernel. There is a value
of NR_TASKS set to 512 which you should to increase. There are some
comments about it also. All this is documented in manual...
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Tonu Samuel <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator
/_/ /_/\_, /___/\___\_\___/ Hong Kong, China
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php