Re: mysql threads and debian woody
Francesc Guaschwrote: Gleb Paharenko wrote: I thought it was OS related, and the mysql version was not the problem. So I tweaked the limit of bash and linux. In addition I don't want to loose the deb dependency. Is there something else I can try before ? I'm having the same problem, and I'm using mysql official binary. I have two servers, one is webserver and the other is the database server. The webserver connects to the mysql server over tcp. at some times there are many connections and mysql creates more than 1000 threads and then just can't create any more -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql threads and debian woody
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 6 -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 ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql threads and debian woody
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 6 -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]
Re: mysql threads and debian woody
Gleb Paharenko wrote: 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)? I thought it was OS related, and the mysql version was not the problem. So I tweaked the limit of bash and linux. In addition I don't want to loose the deb dependency. Is there something else I can try before ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]