In one of my MySQL Production server, I have faced an issue that MySQL could not create a new thread.Below the error i got in mysql error log file.
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
Solution :
1.Check your hardlimit and softlimit for MySQL user in the server.
#ulimit -a mysql
2.Change the threads in OS level,edit the below file and add the bold lines in the file.
#vi /etc/security/limits.conf
mysql soft nofile 30000
mysql hard nofile 30000
mysql soft nproc 30000
mysql hard nproc 30000
Restart MySQL
Then MySQL works fine without any error.
Its happened because of the linux server has limited connections to handle for MySQL user.After increased the value in server the error didn’t occurs.
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
Solution :
1.Check your hardlimit and softlimit for MySQL user in the server.
#ulimit -a mysql
2.Change the threads in OS level,edit the below file and add the bold lines in the file.
#vi /etc/security/limits.conf
mysql soft nofile 30000
mysql hard nofile 30000
mysql soft nproc 30000
mysql hard nproc 30000
Restart MySQL
Then MySQL works fine without any error.
Its happened because of the linux server has limited connections to handle for MySQL user.After increased the value in server the error didn’t occurs.
