Can't create a new thread (errno 12)

Hi All,

I’m facing the error in mysql - “Can’t create a new thread (errno 12);
if you are not out of available memory, you can consult the manual for a
possible OS-dependent bug”

Also, It throws the error like,

"090925 20:50:53 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 1048583
bytes)
090925 22:09:52 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 132176
bytes) "

I those, Mysql asked me to use the ulimit to increase the size of its
elements to avoid these kind of problems,
so that, I have increased the open files limit in ulimit. it was 1024
before I changed as 2048.

Even so, My problem is not solved, When the mysql thread connection
increases because of lot of request to my application, Mysql starts to
throw this error.

I don’t know how to solve this problem yet. As of now, I have decreased
my wait_timeout as 10 sec. from 180 sec.

Please guide me through to get rid of this issue.

Thanks in Advance,
Sathish K.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs