MySQL Bugs: #4316: Can't create new threads

Bug #4316	Can't create new threads
Submitted:	28 Jun 2004 20:12	Modified:	28 Jun 2004 21:04
Reporter:	Don Choa	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Compiling	Severity:	S2 (Serious)
Version:	4.0.20	OS:	Linux (Redhat kernel 2.4.26)
Assigned to:	Dean Ellis	CPU Architecture:	Any

Description:
Hello, 

When I have more than 1500 users online on my website, mysql gives this error:
"Warning: 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 "

A person said that gcc was the guilty but I don't know what I should do. I've tried with the binaries or source but always the same problem.
My server is a Bi-Xeon 2.4Ghz with 2Go ram and "free" shows that memory is still available so he should create new threads.

Please help me.
Best Regards, 

How to repeat:
My gcc is:

  rpm -qa | grep gcc
gcc-g77-3.2.2-5
gcc-c++-3.2.2-5
libgcc-3.2.2-5
gcc-3.2.2-5

In addition to RAM you also need to be able to allocate enough file descriptors for the connections and tables and so on.  You likely need to increase open-files-limit.  Not a bug, however.

Hello, 

Thanks. My mysql has 600reqs/s so how determine the value of the open-files-limit? I have also 12'000 tables in 60 DB. 

Thanks, 
Best Regards