List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:November 24 2009 8:04pm
Subject:Re: Specific benchmarking tool
View as plain text  
Yeah, I figured that out in the mean time :-) I was putting the log type
right after --split, and the damn thing doesn't think of throwing an
'unknown field' error :-)

It's working now, thanks a lot !

On Tue, Nov 24, 2009 at 8:27 PM, ewen fortune <ewen.fortune@stripped>wrote:

> 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
> >> >>>> >
> >> >>>
> >> >>
> >> >>
> >> >
> >
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>

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