From owner-freebsd-current@FreeBSD.ORG Wed Feb 4 07:22:33 2004 Return-Path: Delivered-To: freebsd-current@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 3039216A4CE for ; Wed, 4 Feb 2004 07:22:33 -0800 (PST) Received: from smtp-gw-cl-d.dmv.com (smtp-gw-cl-d.dmv.com [216.240.97.42]) by mx1.FreeBSD.org (Postfix) with ESMTP id D1EAC43D46 for ; Wed, 4 Feb 2004 07:22:28 -0800 (PST) (envelope-from sven@dmv.com) Received: from lanshark.dmv.com (lanshark.dmv.com [216.240.97.46]) i14FIBRv008862 for ; Wed, 4 Feb 2004 10:18:11 -0500 (EST) (envelope-from sven@dmv.com) From: Sven Willenberger To: freebsd-current@freebsd.org In-Reply-To: <20040204081527.GB1525@mobile.acs-et.com> References: <20040204081527.GB1525@mobile.acs-et.com> Content-Type: text/plain Message-Id: <1075908142.26003.71.camel@lanshark.dmv.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Wed, 04 Feb 2004 10:22:22 -0500 Content-Transfer-Encoding: 7bit X-Scanned-By: MIMEDefang 2.39 Subject: Re: MySQL with KSE -- Unstable? X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 04 Feb 2004 15:22:33 -0000 On Wed, 2004-02-04 at 03:15, Mike Makonnen wrote: > >Ran into a similar situation when I used libmap.conf to use libkse for > >apache and mpm worker model. Following the manpage example, I set > >default threads to use libthr instead of libc_r. Running a fairly hi > >load web/mysql server, I ended up with with the error "unable to create > >new threads" and and had to kill the mysql server. > > For a long time the number of concurrent threads in libthr were limited > to about 100. I just bumped this up to 8000+ a few days ago. The newer > libthr in -current also has some bugfixes that were not in 5.2, so if > you have the time I would like to hear what your experiences are with > it and MySQL. > > Cheers. This is a production box (yeah, I know, I have been warned about using 5.x for production servers) so I like to stick with at least the release versions. If it can be deemed relatively safe to cvsup the libthr (or just recompile libthr changing #define MAXTHR to 8192 in _setcurthread.c) I would be willing to try that. As far as compiling mysql to use any other threading (not including linuxthreads) from ports, I am not sure if that can be done by supplying make arguments. Sven