From owner-freebsd-questions@FreeBSD.ORG Tue Sep 23 11:16:49 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 762BF106566B for ; Tue, 23 Sep 2008 11:16:49 +0000 (UTC) (envelope-from vince@unsane.co.uk) Received: from unsane.co.uk (unsane-pt.tunnel.tserv5.lon1.ipv6.he.net [IPv6:2001:470:1f08:110::2]) by mx1.freebsd.org (Postfix) with ESMTP id CED0A8FC0C for ; Tue, 23 Sep 2008 11:16:48 +0000 (UTC) (envelope-from vince@unsane.co.uk) Received: from vhoffman.lon.namesco.net (150.117-84-212.staticip.namesco.net [212.84.117.150]) (authenticated bits=0) by unsane.co.uk (8.14.0/8.14.0) with ESMTP id m8NBHV7f043825 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 23 Sep 2008 12:17:33 +0100 (BST) (envelope-from vince@unsane.co.uk) Message-ID: <48D8D01B.1060109@unsane.co.uk> Date: Tue, 23 Sep 2008 12:16:43 +0100 From: Vincent Hoffman User-Agent: Thunderbird 2.0.0.16 (Macintosh/20080707) MIME-Version: 1.0 To: Sam Nilsson References: <48D8C166.1020601@servingpeace.com> In-Reply-To: <48D8C166.1020601@servingpeace.com> X-Enigmail-Version: 0.95.7 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Cc: FreeBSD Questions 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 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 23 Sep 2008 11:16:49 -0000 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"