From owner-freebsd-current@FreeBSD.ORG  Tue Feb  3 13:12: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 A344116A4CE
	for <freebsd-current@freebsd.org>;
	Tue,  3 Feb 2004 13:12:57 -0800 (PST)
Received: from smtp-gw-cl-c.dmv.com (smtp-gw-cl-c.dmv.com [216.240.97.41])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 7895F43D46
	for <freebsd-current@freebsd.org>;
	Tue,  3 Feb 2004 13:12:56 -0800 (PST)	(envelope-from sven@dmv.com)
Received: from lanshark.dmv.com (lanshark.dmv.com [216.240.97.46])
	i13L8HW1067457	for <freebsd-current@freebsd.org>;
	Tue, 3 Feb 2004 16:08:17 -0500 (EST)	(envelope-from sven@dmv.com)
From: Sven Willenberger <sven@dmv.com>
To: freebsd-current@freebsd.org
In-Reply-To: <54647.68.3.131.72.1075836867.squirrel@mail.asn.net>
References: <54647.68.3.131.72.1075836867.squirrel@mail.asn.net>
Content-Type: text/plain
Message-Id: <1075842770.23952.15.camel@lanshark.dmv.com>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.5 
Date: Tue, 03 Feb 2004 16:12:50 -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
	<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 21:12:57 -0000

On Tue, 2004-02-03 at 14:34, Kris Gale wrote:
> I've given MySQL on KSE a couple of tries in production, and I've
> run into a problem where threads seem to build up after an hour
> or so, depending on load.
> 

> Any ideas?  Has anyone else had success with MySQL on 5.2
> with KSE in high-load environments?
> 
> Kris Gale

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.

Sven