percona-discussion team mailing list archive

[Vadim Tkachenko <vadim@xxxxxxxxxxx>]

Mark,

We have no plans for benchmarks for query processing now, but what we
plan it is to create scripting framework for benchmark so we can easily
 script query scenarios.

We are going to base it on sysbench.

Sysbench was published on Launchpad and Sysbench v5 has included LUA
scripting language, and we already have some simple scripts to test
"web" queries.

I've heard from many customers and storage engine vendors that all of
them badly need "Web benchmark", so we are thinking to script in
sysbench some kind of benchmarks that represents "Web site" load. Your
input is welcome.






MARK CALLAGHAN wrote:
> On Thu, May 28, 2009 at 7:39 PM, Vadim Tkachenko <vadim@xxxxxxxxxxx> wrote:
>> Mark,
>>
>> btw, we also have tpce-mysql, which is absolutely different workload,
>> mostly read-intensive. Interesting it shows different problems than
>> tpcc-mysql.
> 
> I have yet to work up the energy to try out all of it. For now, I copy
> the tpcc_mysql binary into my simpler benchmark framework. But I will
> try it eventually. We need a benchmark for query processing -- dbt-3,
> Star Schema benchmark. Do you have anything in progress?
> 
> I also have enough problems in my current benchmark suite (insert
> benchmark, tpcc_mysql, sysbench) to keep me busy for a few months.
> 
>>
>>
>> MARK CALLAGHAN wrote:
>>> On Thu, May 28, 2009 at 1:28 PM, Vadim Tkachenko <vadim@xxxxxxxxxxx> wrote:
>>>> Mark,
>>>>
>>>> Yes, thanks for results.
>>>>
>>>> I am getting lost in different patches...
>>>> One should categorize them :)
>>> Welcome to the club. I too am frequently lost.
>>>
>>> tpcc-mysql has been a great. I have gotten a lot of work done with it.
>>> Thanks for publishing it.
>>>
>>
>> --
>> 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/
>>
> 
> 
> 


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