From owner-freebsd-threads@FreeBSD.ORG Sun May 23 11:35:31 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 895BD16A4CE for ; Sun, 23 May 2004 11:35:31 -0700 (PDT) Received: from rms04.rommon.net (rms04.rommon.net [212.54.2.140]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5A00543D4C for ; Sun, 23 May 2004 11:35:30 -0700 (PDT) (envelope-from pete@he.iki.fi) Received: from he.iki.fi (h91.vuokselantie10.fi [193.64.42.145]) by rms04.rommon.net (8.12.10/8.12.9) with ESMTP id i4NIZ33v028349; Sun, 23 May 2004 21:35:03 +0300 (EEST) (envelope-from pete@he.iki.fi) Message-ID: <40B0EED6.3040104@he.iki.fi> Date: Sun, 23 May 2004 21:35:02 +0300 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: JG References: <5.2.0.9.2.20040523102747.015557e8@mail.ojoink.com> <5.2.0.9.2.20040523090659.01628af8@mail.ojoink.com> <5.2.0.9.2.20040522135338.0158cc50@mail.ojoink.com> <5.2.0.9.2.20040522100318.01598f50@mail.ojoink.com> <5.2.0.9.2.20040522052606.0156fd70@mail.ojoink.com> <5.2.0.9.2.20040521154458.01627688@127.0.0.1> <5.2.0.9.2.20040521154458.01627688@127.0.0.1> <5.2.0.9.2.20040522052606.0156fd70@mail.ojoink.com> <5.2.0.9.2.20040522100318.01598f50@mail.ojoink.com> <5.2.0.9.2.20040522135338.0158cc50@mail.ojoink.com> <5.2.0.9.2.20040523090659.01628af8@mail.ojoink.com> <5.2.0.9.2.20040523102747.015557e8@mail.ojoink.com> <5.2.0.9.2.20040523104834.01465598@mail.ojoink.com> In-Reply-To: <5.2.0.9.2.20040523104834.01465598@mail.ojoink.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit cc: freebsd-threads@freebsd.org Subject: Re: Why is MySQL nearly twice as fast on Linux? 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: Sun, 23 May 2004 18:35:31 -0000 JG wrote: > At 08:46 PM 5/23/2004 +0300, you wrote: > >> JG wrote: >> >>> >>> You mean where I have the 3 instances of mysqld running in top? You >>> have ~30 instances? >> >> I´m running the supersmack with $1=30. > > > (For those reading this thread who have not looked at the super-smack > source code, > which I'm sure most have not, what Pete means by $1 is the number of > simultaneous > supersmack client connections to run, even though it would be $2 from > shell > ie: super-smack smackfile-to-run clients rounds-per-client) > > > Anyway Pete, I am running the supersmack with 30 clients as well. > > But that isn't what I asked you. > > I have 30 supersmack clients running in top -H when the test is > running (if I ran it with 30 clients anyway). > > What I don't have is 30 mysqld instances (I had 3, as shown), and that > is what you made it sound like you had. > > You said: > > "You seem to have a very small number of active threads. When I tried > supersmack on fairly old machine (800MHz dual pentium) I get ~30 > active mysql threads using CPU between 1.5% and 3.5%." > > So if this is not the case, please clarify. > > Or better... post your top -H while tests are running as well as the > super-smack command you ran. > last pid: 19842; load averages: 7.32, 1.70, 0.67 up 5+10:01:49 21:33:44 110 processes: 1 running, 99 sleeping, 10 lock CPU states: 55.6% user, 0.0% nice, 39.4% system, 0.8% interrupt, 4.2% idle Mem: 312M Active, 64M Inact, 103M Wired, 18M Cache, 60M Buf, 992K Free Swap: 3906M Total, 164K Used, 3906M Free PID USERNAME PRI NICE SIZE RES STATE C TIME WCPU CPU COMMAND 646 mysql 20 0 285M 282M kserel 0 400:31 2.39% 2.39% mysqld 646 mysql 20 0 285M 282M kserel 0 400:31 2.39% 2.39% mysqld 646 mysql 98 0 285M 282M *Giant 0 400:31 2.34% 2.34% mysqld 646 mysql 20 0 285M 282M kserel 1 400:31 2.25% 2.25% mysqld 646 mysql 20 0 285M 282M kserel 0 400:31 2.15% 2.15% mysqld 646 mysql 20 0 285M 282M kserel 1 400:31 2.15% 2.15% mysqld 646 mysql 98 0 285M 282M *Giant 0 400:31 2.15% 2.15% mysqld 646 mysql 20 0 285M 282M kserel 0 400:31 2.05% 2.05% mysqld 646 mysql 20 0 285M 282M kserel 0 400:31 2.00% 2.00% mysqld 646 mysql 20 0 285M 282M kserel 0 400:31 2.00% 2.00% mysqld 646 mysql 20 0 285M 282M kserel 0 400:31 1.95% 1.95% mysqld 646 mysql 20 0 285M 282M kserel 0 400:31 1.95% 1.95% mysqld 646 mysql 20 0 285M 282M kserel 0 400:31 1.95% 1.95% mysqld 646 mysql 20 0 285M 282M kserel 0 400:31 1.95% 1.95% mysqld 646 mysql 98 0 285M 282M *Giant 0 400:31 1.95% 1.95% mysqld 646 mysql 20 0 285M 282M kserel 1 400:31 1.90% 1.90% mysqld 646 mysql 20 0 285M 282M kserel 0 400:31 1.90% 1.90% mysqld 646 mysql 20 0 285M 282M kserel 1 400:31 1.90% 1.90% mysqld 646 mysql 20 0 285M 282M kserel 0 400:31 1.86% 1.86% mysqld 646 mysql 20 0 285M 282M kserel 0 400:31 1.86% 1.86% mysqld 646 mysql 20 0 285M 282M kserel 0 400:31 1.81% 1.81% mysqld 646 mysql 97 0 285M 282M *Giant 0 400:31 1.81% 1.81% mysqld 646 mysql 20 0 285M 282M kserel 1 400:31 1.71% 1.71% mysqld 646 mysql 98 0 285M 282M *Giant 0 400:31 1.71% 1.71% mysqld 646 mysql 20 0 285M 282M kserel 0 400:31 1.66% 1.66% mysqld 646 mysql 20 0 285M 282M kserel 0 400:31 1.66% 1.66% mysqld 646 mysql 97 0 285M 282M *Giant 0 400:31 1.56% 1.56% mysqld 646 mysql 4 0 285M 282M sbwait 0 400:31 1.46% 1.46% mysqld 646 mysql 20 0 285M 282M kserel 0 400:31 1.37% 1.37% mysqld 646 mysql 20 0 285M 282M kserel 1 400:31 1.22% 1.22% mysqld 646 mysql 4 0 285M 282M sbwait 0 400:31 1.22% 1.22% mysqld 19813 pete 4 0 2600K 1712K sbwait 0 0:00 1.19% 0.68% super-smack 19835 pete 4 0 2600K 1712K sbwait 0 0:00 1.11% 0.63% super-smack 19831 pete 96 0 2600K 1712K *Giant 0 0:00 1.11% 0.63% super-smack 19837 pete 4 0 2600K 1712K sbwait 1 0:00 1.11% 0.63% super-smack Pete