MySQL Bugs: #25293: Can't create a new thread (errno 11)

Bug #25293	Can't create a new thread (errno 11)
Submitted:	27 Dec 2006 10:15	Modified:	27 Jan 2007 12:00
Reporter:	li sm	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	4.1.12	OS:	Linux (SuSe 8)
Assigned to:		CPU Architecture:	Any
Tags:	bugs of mysql

Description:
/data/mysql/bin/mysql user -p
ERROR 1135 (00000): 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

Server:IBM X445 3.0G*8CPU 32G mem

netstat -neta |grep 3306|wc -l =23411

my.cnf
-------------------------------------------------------
[mysqld]
user = mysql
port            = 3306
socket          = /tmp/mysql.sock
skip-locking
key_buffer = 512M
max_allowed_packet = 24M
table_cache = 1024
sort_buffer_size = 2M
read_buffer_size = 2M
#net_buffer_length = 8K
myisam_sort_buffer_size = 128M
thread_cache_size = 32M
query_cache_size = 128M
max_connections =1024
max_connect_errors = 512
thread_cache = 16
thread_concurrency =  16
---------------------------------------------------

How to repeat:
when large users visit our web site

Thank you for a problem report. Please, first of all, remove that:

thread_cache_size = 32M

Use 512 instead. Check with a newer version, 4.1.22. In case of similar problem, please, send the results of:

free
ulimit -a

Linux commands.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".