Forum Moderators: open

Message Too Old, No Replies

mysql error

need help

         

sunroof

9:27 am on Apr 4, 2008 (gmt 0)

10+ Year Member



I've recently upgraded my server from MySQL 4.1 to MySQL 5 and since than I'm having a lot of problems with it.

The biggest problem is that server stucks every once in a while and the following error appears:

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

Server load is fine, but in mytop suddenly there are more than 300 threads and then the error appears and the threads disappear... than it goes back again every 10-30 minutes...

Does anyone have any clue why is this happening and what should I do?

Thanks

sunroof

10:39 am on Apr 4, 2008 (gmt 0)

10+ Year Member



Server details:

MySQL: MySQL (Linux Only) Latest

Processor: 2x Intel Xeon-Harpertown 5430-Quadcore [2.66GHz]

RAM: 6GB

With SWSoft Plesk

wheelie34

12:01 pm on Apr 4, 2008 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I'm not 100% clued up with MySql etc but the first thing that came to mind after reading your issue was.

Do you close your connections after pulling data?

mysql_close($databaselink);

sunroof

12:14 pm on Apr 4, 2008 (gmt 0)

10+ Year Member



Yes, of course.