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 Kumar