From owner-freebsd-current@FreeBSD.ORG Sat Mar 20 20:58:29 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 2389216A4CE for ; Sat, 20 Mar 2004 20:58:29 -0800 (PST) Received: from mail.pcnet.com (mail.pcnet.com [204.213.232.4]) by mx1.FreeBSD.org (Postfix) with ESMTP id B5D4E43D1D for ; Sat, 20 Mar 2004 20:58:28 -0800 (PST) (envelope-from eischen@vigrid.com) Received: from mail.pcnet.com (mail.pcnet.com [204.213.232.4]) by mail.pcnet.com (8.12.10/8.12.1) with ESMTP id i2L4wNW7025431; Sat, 20 Mar 2004 23:58:23 -0500 (EST) Date: Sat, 20 Mar 2004 23:58:23 -0500 (EST) From: Daniel Eischen X-Sender: eischen@pcnet5.pcnet.com To: Andy Hilker In-Reply-To: <20040321005423.GA48575@mail.crypta.net> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII cc: Craig Rodrigues 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 21 Mar 2004 04:58:29 -0000 On Sun, 21 Mar 2004, Andy Hilker wrote: > Hi, > > You (Craig Rodrigues) wrote: > > On Sat, Mar 20, 2004 at 12:35:56PM +0100, Andy Hilker wrote: > > > Hi, > > > > > > i have used mysql41 with linuxthreads since a few month without problems. > > > Now linuxthreads from ports does not compile and i wanted to try > > > without linuxthreads. > > > > Look at the mailing list archives for the freebsd-threads > > mailing list. There was some discussion about mysql. > > > > http://lists.freebsd.org/pipermail/freebsd-threads > > http://lists.freebsd.org/pipermail/freebsd-threads/2004-January/ > > 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. I use SCHED_4BSD and this patch to mysql40-server to make it use process scope threads and it works much better: http://people.freebsd.org/~deischen/mysql40-server.diffs I haven't made a patch to other versions of mysql, but I have sent the maintainer the patch. -- Dan Eischen