From owner-freebsd-current@FreeBSD.ORG Sun Mar 21 00:15:58 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 265C316A4CE for ; Sun, 21 Mar 2004 00:15:58 -0800 (PST) Received: from smtp.mho.com (smtp.mho.net [64.58.4.5]) by mx1.FreeBSD.org (Postfix) with SMTP id E971043D2F for ; Sun, 21 Mar 2004 00:15:57 -0800 (PST) (envelope-from scottl@freebsd.org) Received: (qmail 29047 invoked by uid 1002); 21 Mar 2004 08:15:54 -0000 Received: from unknown (HELO freebsd.org) (64.58.1.252) by smtp.mho.net with SMTP; 21 Mar 2004 08:15:54 -0000 Message-ID: <405D4F09.5050804@freebsd.org> Date: Sun, 21 Mar 2004 01:15:05 -0700 From: Scott Long User-Agent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.7a) Gecko/20040214 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Daniel Eischen References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit cc: Craig Rodrigues cc: 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 21 Mar 2004 08:15:58 -0000 Daniel Eischen wrote: > 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. > Having MySQL work 'out of the box' is a critical item for the success of FreeBSD 5.3 and beyond. Should your patch be incorporated into the port? What are the tradeoffs between system and process scope threads in this situation? Since issues with system scope threads seem to come up alot, what will it take to make them no longer be a problem? Scott