Hello.


> I have mysql-server   3.23.49-8.9 in a debian woody,

> chosen for its stability. It looks like the server

> stops accepting connections when it has created

> more than 1024 threads.





I recommend you to switch to the official binaries.

Does the problem remain on the latest release (4.1.10a now)?











Francesc Guasch <[EMAIL PROTECTED]> wrote:

> I have mysql-server   3.23.49-8.9 in a debian woody,

> chosen for its stability. It looks like the server

> stops accepting connections when it has created

> more than 1024 threads.

> 

> The kernel is 2.4.29.

> 

>   failed: Can't create a new thread (errno 11). If you

>   are not out of available memory.

> 

> I have searched a lot for OS problem :

> 

> I changed kernel thread max:

> more /proc/sys/kernel/threads-max

> 14336

> 

> I also changed ulimit max open files in the init.d

> mysql script:

> 

>   ulimit -n 60000 -u unlimited

> 

> I recompiled the kernel with a modified version

> of limits.h

> 

> I still can't go beyond 1000 threads. I know this

> because I type show processlist in mysql.

> 

> What else can I try ?

> 

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




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

Reply via email to