Monday, July 27, 2015

MySQL Can't create a new thread (errno 11)

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.





No comments:

Post a Comment