List:General Discussion« Previous MessageNext Message »
From:ewen fortune Date:November 24 2009 7:27pm
Subject:Re: Specific benchmarking tool
View as plain text  
Johan,

Yes, there are built in parsers for different formats, for example I
was using the general log.
mk-log-player --split Thread_id --type genlog

(genlog was added the other day and is only in trunk so far)

http://www.maatkit.org/doc/mk-log-player.html

--type

    type: string; group: Split

    The type of log to --split (default slowlog). The permitted types are

    binlog

        Split a binary log file.
    slowlog

        Split a log file in any varation of MySQL slow-log format.

Cheers,

Ewen

On Tue, Nov 24, 2009 at 2:41 PM, Johan De Meersman <vegivamp@stripped> wrote:
> Ewen,
>
> Do you need a specific log format or setting ? I'm debugging the tool, and
> it uses ";\n#" as record separator, which is entirely not consistent with
> the log format I get out of the mysql log. Does it perchance try to parse
> zero-execution-time slowlogs instead of the regular log ?
>
>
> On Sat, Nov 14, 2009 at 1:23 AM, Johan De Meersman <vegivamp@stripped>
> wrote:
>>
>> hmm, I got segfaults. i,ll check after the weekend.
>>
>> On 11/13/09, ewen fortune <ewen.fortune@stripped> wrote:
>> > Johan,
>> >
>> > What does? mk-log-player? - I just used it to split and play back 8G,
>> > no problem.
>> >
>> >
>> > Ewen
>> >
>> > On Fri, Nov 13, 2009 at 6:20 PM, Johan De Meersman
> <vegivamp@stripped>
>> > wrote:
>> >> It seems to have a problem with multi-gigabyte files :-D
>> >>
>> >> On Fri, Nov 13, 2009 at 5:35 PM, Johan De Meersman
> <vegivamp@stripped>
>> >> wrote:
>> >>>
>> >>> Ooo, shiny ! Thanks, mate :-)
>> >>>
>> >>> On Fri, Nov 13, 2009 at 4:56 PM, ewen fortune
> <ewen.fortune@stripped>
>> >>> wrote:
>> >>>>
>> >>>> Johan,
>> >>>>
>> >>>> The very latest version of mk-log-player can do that.
>> >>>> If you get the version from trunk:
>> >>>>
>> >>>> wget http://www.maatkit.org/trunk/mk-log-player
>> >>>>
>> >>>> mk-log-player --split Thread_id --type genlog
>> >>>>
>> >>>> Cheers,
>> >>>>
>> >>>> Ewen
>> >>>>
>> >>>> On Fri, Nov 13, 2009 at 4:33 PM, Johan De Meersman
>> >>>> <vegivamp@stripped>
>> >>>> wrote:
>> >>>> > Hey all,
>> >>>> >
>> >>>> > I'm looking for a Mysql benchmarking/stresstesting tool
> that can
>> >>>> > generate a
>> >>>> > workload based on standard Mysql full query log files. The
> idea is
>> >>>> > to
>> >>>> > verify
>> >>>> > performance of real production loads on various database
> setups.
>> >>>> >
>> >>>> > Does anyone know of such a tool, free or paying ?
>> >>>> >
>> >>>> > Thx,
>> >>>> > Johan
>> >>>> >
>> >>>
>> >>
>> >>
>> >
>
>
Thread
Specific benchmarking toolJohan De Meersman13 Nov
  • Re: Specific benchmarking toolWalter Heck - OlinData.com13 Nov
    • Re: Specific benchmarking toolJohan De Meersman13 Nov
  • Re: Specific benchmarking toolewen fortune13 Nov
    • Re: Specific benchmarking toolJohan De Meersman13 Nov
Re: Specific benchmarking toolewen fortune24 Nov
  • Re: Specific benchmarking toolJohan De Meersman24 Nov