Sam Nilsson wrote: > Hello, > > The error message: Can't create a new thread (errno 35); if you are > not out of available memory, you can consult the manual for a possible > OS-dependent bug > > Our website started getting this error several weeks ago (when we > increased the number of application server machines connecting to the > database from 5 to 7. It seems to happen anywhere from every 2 days > to once a week, there does not seem to be a consistent pattern. Our > CPU utilization, memory utilization, and number of HTTP Requests seem > to be at "normal" (they are no where closed to being maxed out). When > this error happens we CAN log onto the server with the MySQL database, > but I CAN NOT use the mysql client to connect to the mysql database > (localhost connection as root) - it reports the error mentioned > above. The way we temporarily solve the problem is to restart one of > our web servers. > > Here is our technology stack: > > Web Servers: 7, Each server has: > 4 Gb of Memory on each server > FreeBSD 6.2-RELEASE-p9 > 2.4 GHz CPU > Apache 2.2 > Webware for Python > Python 2.5 > > DB Servers: One Master, Two Read Only (replication) > 4 GB of Memory on each server > FreeBSD 6.3-RELEASE-p3 FreeBSD 6.3-RELEASE-p3 > MySQL 5.0.1 > > > We have tried bumping up our number of max allowed connections (up to > 1000) on MySQL and kern.ssize to 512Mb for FreeBSD. That did not > help. The max connections usually hovers ~300, so it does not even > get close to the 1000 we have set. Finally the last place that we > have looked is the openfiles, it is set at 20,000 for the whole > system, with 14K per process on the FreeBSD operating system. > > > Here are some relevent items from my.cnf: > - set-variable = max_connections=1000 > - set-variable = key_buffer_size=384M > - set-variable = read_buffer_size=64M > - set-variable = read_rnd_buffer_size=32M > - set-variable = thread_cache_size=20 > > Any help would be much appreciated. > > Thanks > - Sam Nilsson > If you havent already, you could try increasing the per process memory limit as per examples in http://unix.derkeiler.com/Mailing-Lists/FreeBSD/hackers/2008-05/msg00258.html (man tuning also says a bit about these tuneables but doesnt have the examples that post does)
Vince > > _______________________________________________ > email@example.com mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to > "[EMAIL PROTECTED]" _______________________________________________ firstname.lastname@example.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"