Date: Sun, 23 May 2004 21:35:02 +0300 From: Petri Helenius <pete@he.iki.fi> To: JG <amd64list@jpgsworld.com> Cc: freebsd-threads@freebsd.org Subject: Re: Why is MySQL nearly twice as fast on Linux? Message-ID: <40B0EED6.3040104@he.iki.fi> In-Reply-To: <5.2.0.9.2.20040523104834.01465598@mail.ojoink.com> 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>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?40B0EED6.3040104>