← Back to team overview

percona-discussion team mailing list archive

Re: some performance results from percona builds

 

Mark,

XtraDB is "improved version of InnoDB plugin", currently based on
1.0.2-plugin.

You can get latest version there
http://www.percona.com/mysql/5.1.31-3/

Thanks,
Vadim



MARK CALLAGHAN wrote:
> On Wed, Mar 11, 2009 at 9:20 PM, Vadim Tkachenko <vadim@xxxxxxxxxxx> wrote:
>> Mark,
>>
>> Good, Thanks for results.
>>
>> Any chance you can try XtraDB vs XtraDB-tcmalloc vs 5131i103tcm ?
> 
> Yes, but with all of your versions (Percona is very productive) I get
> confused about what is XtraDB. Send me a link and I will try it.
> 
>>
>>
>> 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/
>>
> 
> 
> 


-- 
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/



References