From owner-freebsd-current@FreeBSD.ORG  Sun Mar 21 04:12:49 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 7EC9F16A4CF
	for <current@freebsd.org>; Sun, 21 Mar 2004 04:12:49 -0800 (PST)
Received: from mail.crypta.net (mail.crypta.net [194.97.74.131])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 1E14743D2D
	for <current@freebsd.org>; Sun, 21 Mar 2004 04:12:49 -0800 (PST)
	(envelope-from ah@crypta.net)
Received: by mail.crypta.net (Postfix, from userid 1001)
	id 2E7EBECD423; Sun, 21 Mar 2004 13:12:47 +0100 (CET)
Date: Sun, 21 Mar 2004 13:12:46 +0100
From: Andy Hilker <ah@crypta.net>
To: Daniel Eischen <eischen@vigrid.com>
Message-ID: <20040321121246.GB93532@mail.crypta.net>
References: <20040321005423.GA48575@mail.crypta.net>
	<Pine.GSO.4.10.10403202355130.23229-100000@pcnet5.pcnet.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <Pine.GSO.4.10.10403202355130.23229-100000@pcnet5.pcnet.com>
User-Agent: Mutt/1.4.2.1i
X-PGP-Key: http://wwwkeys.pgp.net:11371/pks/lookup?op=get&search=0xEC6E1071
X-PGP-Fingerprint: 9B2E 5892 AD93 D5C5 FB8E  3912 35D6 951B EC6E 1071
Organization: cryptobank - Andy Hilker
cc: current@freebsd.org
Subject: Re: libpthread / mysql41-server
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: Sun, 21 Mar 2004 12:12:49 -0000

Hi,

> > It seems that i have a similar issue like
> > 
> > http://lists.freebsd.org/pipermail/freebsd-threads/2004-February/001660.html
> > 
> > But maybe it is not fixed or exists again.
> > Bumping up thread sysctls or using libmap.conf are not better. mySQL
> > becomes very unresponsive.
> 
> Mysql uses scope system threads which are limited to
> kern.threads.max_groups_per_proc.  System scope threads
> seem to have unfair scheduling also.  

Thats exactly, what i see. Installed port without options needs
sometimes minutes to answer normal easy queries. mysqld processes
is not killable (only by -9).

With this libmap.conf it seems better. But no good comparison to
formerly linuxthreads performance...


[mysqld]
libpthread.so.1        libc_r.so.5
libpthread.so          libc_r.so

[/usr/local/libexec/mysqld]
libpthread.so.1        libc_r.so.5
libpthread.so          libc_r.so


I will test a few patches i received and see if it helps.

Andy