Date: Tue, 23 Sep 2008 12:16:43 +0100 From: Vincent Hoffman <vince@unsane.co.uk> To: Sam Nilsson <lists@servingpeace.com> Cc: FreeBSD Questions <freebsd-questions@freebsd.org> Subject: Re: MySQL Error: 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 Message-ID: <48D8D01B.1060109@unsane.co.uk> In-Reply-To: <48D8C166.1020601@servingpeace.com> References: <48D8C166.1020601@servingpeace.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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 > > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to > "freebsd-questions-unsubscribe@freebsd.org"
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?48D8D01B.1060109>