From owner-freebsd-threads@FreeBSD.ORG Tue Feb 10 14:11:18 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 13BA616A4D5 for ; Tue, 10 Feb 2004 14:11:18 -0800 (PST) Received: from rwcrmhc13.comcast.net (rwcrmhc13.comcast.net [204.127.198.39]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0A5F943D1D for ; Tue, 10 Feb 2004 14:11:18 -0800 (PST) (envelope-from rodrigc@crodrigues.org) Received: from h00609772adf0.ne.client2.attbi.com ([66.31.45.197]) by comcast.net (rwcrmhc13) with ESMTP id <2004021022111601500k5h4ge>; Tue, 10 Feb 2004 22:11:17 +0000 Received: from h00609772adf0.ne.client2.attbi.com (localhost.crodrigues.org [127.0.0.1])i1AMBPhd048329; Tue, 10 Feb 2004 17:11:25 -0500 (EST) (envelope-from rodrigc@h00609772adf0.ne.client2.attbi.com) Received: (from rodrigc@localhost)i1AMBO7T048328; Tue, 10 Feb 2004 17:11:24 -0500 (EST) (envelope-from rodrigc) Date: Tue, 10 Feb 2004 17:11:24 -0500 From: Craig Rodrigues To: Kris Gale Message-ID: <20040210221124.GA48300@crodrigues.org> References: <1076398781.b793f9a0dkt@digitalme.com> <51993.68.3.131.72.1076432061.squirrel@mail.asn.net> <20040210193240.GA47392@crodrigues.org> <53224.68.3.131.72.1076449765.squirrel@mail.asn.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <53224.68.3.131.72.1076449765.squirrel@mail.asn.net> User-Agent: Mutt/1.4.1i cc: freebsd-threads@freebsd.org Subject: Re: Question about threads [beaver challenge] X-BeenThere: freebsd-threads@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 10 Feb 2004 22:11:18 -0000 On Tue, Feb 10, 2004 at 02:49:25PM -0700, Kris Gale wrote: > MySQL 4.0.17 from ports. KSE entries in libmap.conf. > > I tried it with and without BUILD_OPTIMIZED. I did not BUILD_STATIC, > as I normally do. The DB_DIR was reconfigured. > > > How big were the tables that you used? > > The database powers a complicated web application. There are about > 150 tables. Some have a few rows, some have hundreds of thousands > of rows. > > > How many queries did you hit the database with? > > ---[ From previous thread]--- > The first time I tried it, we were maintaining a load of about 600 > threads and 300 queries/second and lasted about three hours > before the thread count went through the roof and MySQL became > unresponsive. > > The second time, we were sustaining a load of 1300 threads and > 600 queries/second. This only lasted about 30 minutes. > ------ OK, this is good information to start off with. Is there a representative test application which comes with MySQL that could be used to hammer on the FreeBSD KSE implementation? I see many MySQL mailing lists at: http://lists.mysql.com.....is there a mailing list there which is appropriate to ask about threading issues, such as MySQL Internals? I think certain applications like MySQL and Apache should be of high priority to get working nicely with FreeBSD KSE before 5.3. -- Craig Rodrigues http://crodrigues.org rodrigc@crodrigues.org