Re: HyperThreading
--002215047c9b75207f049d0e3271
Content-Type: text/plain; charset=ISO-8859-1
I apologize for the delay, I was a little bit busy.
Sorry, I am not following, by master you mean the master branch !?
>>
>
> Yep; we produce CD snapshots each night, they're from the latest git code
> as of that day.
>
I believe this results belong to the master branch. As I pulled it through
git and build a custom Kernel based on it. I think I have to change the
labels then. I will redo the whole experiment with 2.8 branch. Correct me if
I am wrong: I have to pull this branch: DragonFly_RELEASE_2_8, right ?
>
>>> Can you give us a bit more information about the h/w and configuration?
>>> In Kris Kennaway's tests, he was seeing FreeBSD 7 sustain 8 times the number
>>> of transactions you're reporting for 8.1, and that was for hardware that is
>>> three or four years old at this point.
>>>
>>
>> I see, good point. The machine I am testing on is a 4 core xeon with 2GB
>> of RAM, and I it is 2 to 3 years old as well (The machine Kris were using
>> was a "2.0Ghz 8-core amd64 system with 16GB of RAM", so as it has twice the
>> number of cores and 8 times more memory than what I have here, I think the
>> results are fair for number of transactions). I might be able to re run the
>> tests on another machine if I get lucky. MySQL configuration is exactly the
>> same as what Kris used (http://people.freebsd.org/~kris/scaling/my.cnf),
>> I am using MySQL 5.0.91. Here is the sysbench command :
>>
>
> http://people.freebsd.org/~kris/scaling/4cpu-mysql.png
was on a 4 x p3
> 700mhz; I believe (but we should ask Kris) that the opterons were not used
> for the cross-OS comparisons; they were used for the fbsd 5.5 vs 6.2 vs 7.0
> tests. (see the titles on that graph vs the cross-OS comparison). Happen to
> know what sort of Xeons exactly?
>
I will email Kris and ask him about it. Comparing the figures,
transaction/sec makes more sens.I am not sure about the specifications of
the CPU, as I do not have physical access to them.
>
>
>
>
> Also, last I tried sysbench/OLTP with MySQL on dfly, I saw MySQL making
>>> many 256K allocations, which fall back to mmap() in our system. mmap()
>>> acquires the VM token, so I expected to see a much more dramatic falloff
>>> than you saw.
>>>
>>
>> I will double check if everything is working properly and there is no
>> mistake in configuration of both machines. Do you remember which version of
>> MySQL you were using ?and What is the best way of profiling in DragonFly ?!
>>
>
> I used MySQL 5.1.37 I believe.
>
Somewhere Kris mentioned Mysql 5.1 Performance is worse that 5.0 when it
comes to scaling.
Watch the output of systat -pv; you'll be able to see contended tokens.
>
I ran sysbench again along with systat running, but in the contention part
nothing really changes. is there something wrong ?
Cheers,
Saman
--002215047c9b75207f049d0e3271
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
<div dir=3D"ltr">I apologize for the delay, I was a little bit busy. <br><b=
r><div class=3D"im"><br><blockquote class=3D"gmail_quote" style=3D"margin: =
0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left:=
1ex;">
<div class=3D"gmail_quote"><div><blockquote class=3D"gmail_quote" style=3D"=
border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; paddi=
ng-left: 1ex;"><div dir=3D"ltr"><div class=3D"gmail_quote"><div>Sorry, I am=
not following, by master you mean the master branch !? <br>
</div></div></div></blockquote></div><div><br>Yep; we produce CD snapshots =
each night, they're from the latest git code as of that day.<br></div><=
/div></blockquote><div>=A0</div></div><div>I
believe this results belong to the master branch. As I pulled it=20
through git and build a custom Kernel based on it. I think I have to=20
change the labels then. I will redo the whole experiment with 2.8=20
branch. Correct me if I am wrong: I have to pull this branch: =A0=A0=A0=20
DragonFly_RELEASE_2_8, right ? <br>
</div><div class=3D"im"><blockquote class=3D"gmail_quote" style=3D"margin: =
0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left:=
1ex;"><div class=3D"gmail_quote"><div><blockquote class=3D"gmail_quote" st=
yle=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex=
; padding-left: 1ex;">
<div dir=3D"ltr"><div class=3D"gmail_quote"><div><blockquote class=3D"gmail=
_quote" style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt=
0pt 0.8ex; padding-left: 1ex;">
<div class=3D"gmail_quote"><div>
<br>Can you give us a bit more information about the h/w and=20
configuration? In Kris Kennaway's tests, he was seeing FreeBSD 7 sustai=
n
8 times the number of transactions you're reporting for 8.1, and that=
=20
was for hardware that is three or four years old at this point. </div>
</div></blockquote></div><div><br>I see, good point. The machine I am testi=
ng on=A0 is a=A0 4 core xeon with 2GB of RAM, and I it
is=A0 2 to 3 years old as well (The machine Kris were using was a "2.=
0Ghz
8-core amd64 system with 16GB of
RAM", so as it has twice the number of cores and 8 times more memory=
=20
than what I have here, I think the results are fair for number of=20
transactions). I might be able to re run the tests on another=20
machine if I get lucky. MySQL=20
configuration is exactly the same as what Kris used=20
(<a href=3D"http://people.freebsd.org/%7Ekris/scaling/my.cnf" target=3D"_bl=
ank">http://people.freebsd.org/~kris/scaling/my.cnf</a>), I am using MySQL =
5.0.91. Here is the sysbench command : <br></div></div></div></blockquote>
<br></div><a href=3D"http://people.freebsd.org/%7Ekris/scaling/4cpu-mysql.p=
ng" target=3D"_blank">http://people.freebsd.org/~kris/scaling/4cpu-mysql.pn=
g</a>
was on a 4 x p3 700mhz; I believe (but we should ask Kris) that the=20
opterons were not used for the cross-OS comparisons; they were used for=20
the fbsd 5.5 vs 6.2 vs 7.0 tests. (see the titles on that graph vs the=20
cross-OS comparison). Happen to know what sort of Xeons exactly?</div>
</blockquote></div><div>I will email Kris and ask him about it.=20
Comparing the figures, transaction/sec makes more sens.I=A0 am not sure=20
about the specifications of the CPU, as I do not have physical access to
them. <br></div><div class=3D"im"><blockquote class=3D"gmail_quote" style=
=3D"margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); p=
adding-left: 1ex;">
<div class=3D"gmail_quote"><div><br><br></div><div><br><br></div><div><bloc=
kquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, 204, =
204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div dir=3D"ltr">
<div class=3D"gmail_quote"><div><blockquote class=3D"gmail_quote" style=3D"=
border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; paddi=
ng-left: 1ex;">
<div class=3D"gmail_quote"><div>Also, last I tried sysbench/OLTP with=20
MySQL on dfly, I saw MySQL making many 256K allocations, which fall back
to mmap() in our system. mmap() acquires the VM token, so I expected to
see a much more dramatic falloff than you saw.<br>
</div></div></blockquote></div><div>=A0<br>I will double check if=20
everything is working properly and there is no mistake in configuration=20
of both machines. Do you remember which version of MySQL you were using=20
?and What is the best way of profiling in DragonFly ?! <br>
</div></div></div></blockquote></div><div><br>I used MySQL 5.1.37 I believe=
.. </div></div></blockquote></div><div><br>Somewhere Kris mentioned=A0 Mysql=
5.1 Performance is worse that 5.0 when it comes to scaling.=A0=A0 <br><br>=
</div>
<div class=3D"im"><blockquote class=3D"gmail_quote" style=3D"margin: 0pt 0p=
t 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"=
>
<div class=3D"gmail_quote"><div>Watch the output of systat -pv; you'll =
be able to see contended tokens.<br></div></div></blockquote></div><br>I ra=
n sysbench again along with systat running, but in the contention part noth=
ing really changes. is there something wrong ?<br>
<br><br>Cheers,<br>Saman</div>
--002215047c9b75207f049d0e3271--
討論串 (同標題文章)
完整討論串 (本文為第 16 之 16 篇)：