From owner-freebsd-threads@FreeBSD.ORG Tue Feb 10 14:39:38 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 A265616A4CF for ; Tue, 10 Feb 2004 14:39:38 -0800 (PST) Received: from rms04.rommon.net (rms04.rommon.net [212.54.2.140]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1509343D1F for ; Tue, 10 Feb 2004 14:39:38 -0800 (PST) (envelope-from pete@he.iki.fi) Received: from he.iki.fi (h81.vuokselantie10.fi [193.64.42.129]) by rms04.rommon.net (8.12.9p1/8.12.9) with ESMTP id i1ALdWcM065551; Tue, 10 Feb 2004 23:39:32 +0200 (EET) (envelope-from pete@he.iki.fi) Message-ID: <40294F56.6020706@he.iki.fi> Date: Tue, 10 Feb 2004 23:38:30 +0200 From: Petri Helenius User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Daniel Eischen References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit 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:39:38 -0000 Daniel Eischen wrote: >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? > > > All. (any other executables you´re interested in?) > ldd /usr/local/libexec/mysqld /usr/local/libexec/mysqld: libwrap.so.3 => /usr/lib/libwrap.so.3 (0x28377000) libz.so.2 => /lib/libz.so.2 (0x2837f000) libcrypt.so.2 => /lib/libcrypt.so.2 (0x2838d000) libc_r.so.5 => /usr/lib/libkse.so.1 (0x283a6000) libstdc++.so.4 => /usr/lib/libstdc++.so.4 (0x283ca000) libm.so.2 => /lib/libm.so.2 (0x28486000) libc.so.5 => /lib/libc.so.5 (0x2849f000) > >Can you also do a 'top -H' and see if mysql is running >with multiple system scope threads? > > > PID USERNAME PRI NICE SIZE RES STATE C TIME WCPU CPU COMMAND 642 mysql 96 0 284M 250M select 0 67:13 1.37% 1.37% mysqld 642 mysql 20 0 284M 250M kserel 1 67:13 1.37% 1.37% mysqld 642 mysql -8 0 284M 250M biowr 1 67:13 1.37% 1.37% mysqld 642 mysql 20 0 284M 250M kserel 1 67:13 1.27% 1.27% mysqld 642 mysql 4 0 284M 250M sbwait 1 67:13 0.93% 0.93% mysqld 642 mysql 20 0 284M 250M kserel 1 67:13 0.00% 0.00% mysqld 642 mysql 20 0 284M 250M ksesig 1 67:13 0.00% 0.00% mysqld 642 mysql 20 0 284M 250M sigwai 1 67:13 0.00% 0.00% mysqld 642 mysql 4 0 284M 250M sbwait 1 67:13 0.00% 0.00% mysqld 642 mysql 4 0 284M 250M sbwait 0 67:13 0.00% 0.00% mysqld >Libc_r use to have the same exactl problem with MySql if I recall. > > > Cannot recall that happening to me, though I´ve been mostly using linuxthreads due to the performance increase they give. >We need to get someone familiar with mysql to help figure out >what is going on. > > > Pete