From owner-freebsd-current@FreeBSD.ORG  Tue Feb  3 15:05:57 2004
Return-Path: <owner-freebsd-current@FreeBSD.ORG>
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 6029616A4D0
	for <freebsd-current@freebsd.org>;
	Tue,  3 Feb 2004 15:05:57 -0800 (PST)
Received: from mail.asn.net (mail.asn.net [66.235.231.4])
	by mx1.FreeBSD.org (Postfix) with SMTP id 4481843D2D
	for <freebsd-current@freebsd.org>;
	Tue,  3 Feb 2004 15:05:56 -0800 (PST)	(envelope-from kgale@asn.net)
Received: (qmail 68244 invoked by uid 80); 3 Feb 2004 23:05:55 -0000
Received: from 68.3.131.72
        (SquirrelMail authenticated user kgale)
        by mail.asn.net with HTTP;
        Tue, 3 Feb 2004 16:05:55 -0700 (MST)
Message-ID: <54754.68.3.131.72.1075849555.squirrel@mail.asn.net>
In-Reply-To: <1075842770.23952.15.camel@lanshark.dmv.com>
References: <54647.68.3.131.72.1075836867.squirrel@mail.asn.net>
    <1075842770.23952.15.camel@lanshark.dmv.com>
Date: Tue, 3 Feb 2004 16:05:55 -0700 (MST)
From: "Kris Gale" <kgale@asn.net>
To: "Sven Willenberger" <sven@dmv.com>
User-Agent: SquirrelMail/1.4.2
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Priority: 3
Importance: Normal
X-Mailman-Approved-At: Wed, 04 Feb 2004 05:09:46 -0800
cc: freebsd-current@freebsd.org
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
	<freebsd-current.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-current>,
	<mailto:freebsd-current-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-current>
List-Post: <mailto:freebsd-current@freebsd.org>
List-Help: <mailto:freebsd-current-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-current>,
	<mailto:freebsd-current-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 03 Feb 2004 23:05:57 -0000

> 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. It seems that mysql
> is partial to libc_r rather than libkse or libthr(?) as changing the
> libmap entry back to libc_r for default cured the mysql woes.

To get around what you're describing, you should tweak

kern.threads.max_threads_per_proc
and
kern.threads.max_groups_per_proc

The default on 5.2 is quite low.

Still, I have a feeling once you get this limit increased, you might
see a problem similar to the one I described.

Kris