From owner-freebsd-threads@FreeBSD.ORG Tue Apr 20 12:13:22 2004 Return-Path: Delivered-To: freebsd-threads@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 6A95916A4CE for ; Tue, 20 Apr 2004 12:13:22 -0700 (PDT) Received: from miramanee.icarz.com (miramanee.icarz.com [207.99.22.55]) by mx1.FreeBSD.org (Postfix) with ESMTP id CFA7343D1D for ; Tue, 20 Apr 2004 12:13:21 -0700 (PDT) (envelope-from kenfreebsd@icarz.com) Received: from deanna.icarz.com (deanna.icarz.com [207.99.22.19]) by miramanee.icarz.com (8.12.10/8.12.10) with ESMTP id i3KJD9BQ026867 for ; Tue, 20 Apr 2004 15:13:09 -0400 (EDT) (envelope-from kenfreebsd@icarz.com) Received: from kenxp (netb-138.icarz.com [209.123.219.138]) by deanna.icarz.com (8.12.9p2/8.12.9) with SMTP id i3KJD6Rd075592 for ; Tue, 20 Apr 2004 15:13:06 -0400 (EDT) (envelope-from kenfreebsd@icarz.com) Message-ID: <05b101c4270b$82e696d0$8adb7bd1@icarz.com> From: "Ken Menzel" To: References: Date: Tue, 20 Apr 2004 15:13:06 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-Spam-Score: -100.001 () BAYES_40,USER_IN_WHITELIST X-Scanned-By: MIMEDefang 2.39 Subject: Re: MySQL and libpthread X-BeenThere: freebsd-threads@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: Ken Menzel List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 20 Apr 2004 19:13:22 -0000 Hi Dan, Looks like a simple enough patch, is this something that should be suggested to the mysql folks to include in future versions for FreeBSD? Looks like this patch does not break 4.9 with or without Linux threads. (I checked). Is there any downside to this for FreeBSD? Would other platforms perhaps benefit from this change? Ken ----- Original Message ----- From: "Daniel Eischen" To: "Mike Silbersack" Cc: Sent: Tuesday, April 20, 2004 7:39 AM Subject: Re: MySQL and libpthread > On Tue, 20 Apr 2004, Mike Silbersack wrote: > > > > > I haven't had time to fully track it down yet, but FYI I've found that > > MySQL and libpthread don't seem to get along well for me; with sources > > from april 12th and mysql 4.1 from ports, mysqld just seems to hang for > > long periods of time, and is unkillable. When I libmap it to libthr or > > libc_r, all is well. > > There are a lot of posts regarding mysql in the threads > archives. Two things -- mysql with libwrap support doesn't > work with default CFLAGS (-march), and mysql uses scope > system threads which chew up more kernel resources and > can hang when you hit kern.threads.* limits. > > To make mysql40 use scope process threads: > > http://people.freebsd.org/~deischen/mysql40-server.diffs > > > The test I was running was simply mysql's included benchmark suite, using > > local socket connections to mysql. If one of the libpthread developers > > can not reproduce this behavior, I'll try more tests later in the week to > > see if I can pin it down more. > > I've got mysql40-server running here with the above patches > and a test script that causes creation of 1800 mysql threads. > > -- > Dan Eischen > > _______________________________________________ > freebsd-threads@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-threads > To unsubscribe, send any mail to "freebsd-threads-unsubscribe@freebsd.org" >