percona-discussion team mailing list archive
-
percona-discussion team
-
Mailing list archive
-
Message #00371
Re: some performance results from percona builds
Mark,
Good, Thanks for results.
Any chance you can try XtraDB vs XtraDB-tcmalloc vs 5131i103tcm ?
MARK CALLAGHAN wrote:
> On Tue, Mar 10, 2009 at 10:28 AM, MARK CALLAGHAN <mdcallag@xxxxxxxxx> wrote:
>> These are sysbench readonly results from a 16 core server. I used my
>> --oltp-secondary-index patch. The workload is CPU bound. The numbers
>> are transactions/second for 1, 2, 4, 8, 16, 32 and 64 concurrent
>> threads. With my sysbench patch, 2X more work is done per transaction
>> so the results should be ~1/2 of what you get. tcmalloc helps the
>> binaries in which other SMP problems have been fixed. I have not
>> debugged the slowdowns for the other cases. Postgres thrashes for 64
>> concurrent users, so I don't include that result.
>>
>> 311 684 1305 2401 2678 2211 0 pg
>> 213 460 874 1361 836 732 522 5075p
>> 210 468 841 1260 713 561 490 5075ptcm
>> 209 473 900 1432 1766 1102 1069 5077percb13hp
>> 209 477 879 1477 2015 2070 2019 5077percb13hptcm
>> 192 417 755 1182 1245 733 621 5131perc
>> 198 435 796 1256 1573 1382 1118 5131perctcm
>>
>> Legend:
>> - pg -- Postgres 8.3.6
>> - 5075p -- Percona build 12
>> - 5075ptcm -- Percona build 12 + tcmalloc
>> - 5077percb13hp -- Percona high-perf build 13
>> - 5077percb13hptcm -- 5077percb13hp + tcmalloc
>> - 5131perc -- Percona for 5.1.31
>> - 5131perctcm -- 5131perc + tcmalloc
>
> Results for the Innodb plugin on the same hardware from sysbench readonly
> 5131i102 -> 5.1.31 + 1.0.2 plugin
> 5131i103 -> 5.1.31 + 1.0.3 plugin (has the Google SMP changes)
> 5131i103tcm -> 5131i103 + tcmalloc
>
> 195 421 733 1069 558 380 222 5131i102
> 192 437 769 1252 1202 672 534 5131i103
> 213 479 871 1473 1860 1996 2023 5131i103tcm
>
--
Vadim Tkachenko, CTO
Percona Inc.
ICQ: 369-510-335, Skype: vadimtk153, Phone +1-888-401-3403
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.percona.com/
Attend the 2009 Percona Performance Conference
April 22-23 - http://conferences.percona.com/
Follow ups
References