From owner-freebsd-threads@FreeBSD.ORG Tue Feb 10 12:16:43 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 768AF16A4CE for ; Tue, 10 Feb 2004 12:16:43 -0800 (PST) Received: from mail.pcnet.com (mail.pcnet.com [204.213.232.4]) by mx1.FreeBSD.org (Postfix) with ESMTP id 30AA443D2F for ; Tue, 10 Feb 2004 12:16:43 -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 i1AKGefo013792; Tue, 10 Feb 2004 15:16:40 -0500 (EST) Date: Tue, 10 Feb 2004 15:16:40 -0500 (EST) From: Daniel Eischen X-Sender: eischen@pcnet5.pcnet.com To: Petri Helenius In-Reply-To: <40293892.9070607@he.iki.fi> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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 20:16:43 -0000 On Tue, 10 Feb 2004, Petri Helenius wrote: > Craig Rodrigues wrote: > > >How did you compile and configure MySQL with KSE? > > > > > > > I just did build it out of ports, using libmap.conf to map it to libkse. > No extra options given. "map it" equates to what? Mapping all libc_r to libkse or just mysql? Can you also do a 'top -H' and see if mysql is running with multiple system scope threads? > >Did you build it from ports? If so, what version? > >What configuration did you use? > > > >How big were the tables that you used? > >How many queries did you hit the database with? > > > > > > > The tables I have are multiple gigabytes but the query load is not too > bad on the test system, but it takes a few moments after starting when > the mysqld stops answering to SIGTERM for proper shutdown and only way > to get it to die is SIGKILL which is not exactly what you want to use to > stop a database daemon. Libc_r use to have the same exactl problem with MySql if I recall. We need to get someone familiar with mysql to help figure out what is going on. -- Dan