Performance!
Krassimir Slavchev
krassi at bulinfo.net
Thu Jan 10 00:10:57 PST 2008
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Kris Kennaway wrote:
> Krassimir Slavchev wrote:
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> Hello,
>>
>> Kris Kennaway wrote:
>>> Krassimir Slavchev wrote:
>>>> -----BEGIN PGP SIGNED MESSAGE-----
>>>> Hash: SHA1
>>>>
>>>> Hello,
>>>>
>>>> Here are lock profiling results with select patch applied.
>>> OK, you are doing I/O over TCP. Are you sure you are using TCP on both
>>> systems? Linux may not be defaulting to TCP transport for local
>>> queries.
>>>
>>> Add --pgsql-host="" to your sysbench command line to make it communicate
>>> over a local domain socket, which is much more efficient.
>>>
>>> Kris
>>>
>>
>> Hmm, Yes linux uses local domain sockets!
>> Here are results using local domain sockets on FreeBSD too:
>> #threads #tranzactions/sec
>> 1 728
>> 5 2996
>> 10 5301
>> 20 3931
>> 40 2466
>> 60 1852
>> 80 1424
>> 100 1216
>>
>> Just to remember:
>> Linux (2.6.18)
>> #threads #transactions/sec
>> 1 693
>> 5 3539
>> 10 5789
>> 20 5791
>> 40 5661
>> 60 5517
>> 80 5401
>> 100 5319
>>
>> I have results using Fedora 8 on the same hardware:
>> Linux (2.6.23)
>> #threads #transactions/sec
>> 1 740
>> 5 2675
>> 10 6486
>> 20 6893
>> 40 6623
>> 60 6623
>> 80 6522
>> 100 6417
>>
>> If we look at the results with up to 10 threads the performance of
>> FreeBSD is very good.
>> May be something can be tuned for number of threads > number of CPUs?
>>
>> Are you interested in lock profiling statistics with more threads than
>> the number of CPUs?
>
> Yes, it's still performing anomalously. Glad we're making progress
> though :)
>
> Kris
>
Okay, but how many threads will be more useful to test with?
Best Regards
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (FreeBSD)
iD8DBQFHhdMIxJBWvpalMpkRAowhAKCOLh6eUptQhVQlUA2O2vSS4fi6XACaA8Bx
BVgsYLIpqdKZpMdaz4mj9gg=
=MhN8
-----END PGP SIGNATURE-----
More information about the freebsd-stable
mailing list