MySQL slow query log analysis

List overview All Threads
Download

newer

older

default pharo image for moose

ROView>>allElementsDo:

laurent laffont

9 Oct 2012 9 Oct '12

9:19 a.m.

Hello, I would like a mysql slow query log parser / analyzer that generates a graph with most time consuming requests. Someone already done it with Moose / Roassal ? Cheers, Laurent

Attachments:

attachment.htm (text/html — 259 bytes)

Show replies by date

Tudor Girba

9 Oct 9 Oct

9:25 a.m.

I guess not. The first step would be to write a parser for the output and build a model out of it. Afterwards we can visualize it. But, where is the graph in this structure? Cheers, Doru On Tue, Oct 9, 2012 at 9:19 AM, laurent laffont <laurent.laffont(a)gmail.com> wrote:

...

Hello, I would like a mysql slow query log parser / analyzer that generates a graph with most time consuming requests. Someone already done it with Moose / Roassal ? Cheers, Laurent _______________________________________________ Moose-dev mailing list Moose-dev(a)iam.unibe.ch https://www.iam.unibe.ch/mailman/listinfo/moose-dev

-- www.tudorgirba.com "Every thing has its own flow"

laurent laffont

12:19 p.m.

On Tue, Oct 9, 2012 at 9:25 AM, Tudor Girba <tudor(a)tudorgirba.com> wrote:

...

I guess not. The first step would be to write a parser for the output and build a model out of it. Afterwards we can visualize it. But, where is the graph in this structure?

I want to group same queries, how many times they are run, mean / max execution time. Group by database. Time distribution. This is a server with +100 mysql databases (same structure), I want to know on which queries we should work to improve performance. Laurent

...

Cheers, Doru On Tue, Oct 9, 2012 at 9:19 AM, laurent laffont <laurent.laffont(a)gmail.com> wrote:

Hello, I would like a mysql slow query log parser / analyzer that generates a

graph

with most time consuming requests. Someone already done it with Moose / Roassal ? Cheers, Laurent _______________________________________________ Moose-dev mailing list Moose-dev(a)iam.unibe.ch https://www.iam.unibe.ch/mailman/listinfo/moose-dev

-- www.tudorgirba.com "Every thing has its own flow" _______________________________________________ Moose-dev mailing list Moose-dev(a)iam.unibe.ch https://www.iam.unibe.ch/mailman/listinfo/moose-dev

Tudor Girba

12:48 p.m.

Sounds interesting. Do you have sample logs? Cheers, Doru On Tue, Oct 9, 2012 at 12:19 PM, laurent laffont <laurent.laffont(a)gmail.com> wrote:

...

On Tue, Oct 9, 2012 at 9:25 AM, Tudor Girba <tudor(a)tudorgirba.com> wrote:

I guess not. The first step would be to write a parser for the output and build a model out of it. Afterwards we can visualize it. But, where is the graph in this structure?

Cheers, Doru On Tue, Oct 9, 2012 at 9:19 AM, laurent laffont <laurent.laffont(a)gmail.com> wrote:

_______________________________________________ Moose-dev mailing list Moose-dev(a)iam.unibe.ch https://www.iam.unibe.ch/mailman/listinfo/moose-dev

-- www.tudorgirba.com "Every thing has its own flow"

laurent laffont

1:30 p.m.

Yes. I'll send you via private email. Laurent On Tue, Oct 9, 2012 at 12:48 PM, Tudor Girba <tudor(a)tudorgirba.com> wrote:

...

Sounds interesting. Do you have sample logs? Cheers, Doru On Tue, Oct 9, 2012 at 12:19 PM, laurent laffont <laurent.laffont(a)gmail.com> wrote:

On Tue, Oct 9, 2012 at 9:25 AM, Tudor Girba <tudor(a)tudorgirba.com>

wrote:

I guess not. The first step would be to write a parser for the output and build a model out of it. Afterwards we can visualize it. But, where is the graph in this structure?

I want to group same queries, how many times they are run, mean / max execution time. Group by database. Time distribution. This is a server with +100 mysql databases (same structure), I want to

know

on which queries we should work to improve performance. Laurent > > > Cheers, > Doru > > > On Tue, Oct 9, 2012 at 9:19 AM, laurent laffont > <laurent.laffont(a)gmail.com> wrote: > > Hello, > > > > I would like a mysql slow query log parser / analyzer that generates a > > graph > > with most time consuming requests. Someone already done it with Moose

Roassal ? Cheers, Laurent _______________________________________________ Moose-dev mailing list Moose-dev(a)iam.unibe.ch https://www.iam.unibe.ch/mailman/listinfo/moose-dev

_______________________________________________ Moose-dev mailing list Moose-dev(a)iam.unibe.ch https://www.iam.unibe.ch/mailman/listinfo/moose-dev

Stéphane Ducasse

12 Oct 12 Oct

8:39 a.m.

Yes laurent could you send a sample? Stef

...

Sounds interesting. Do you have sample logs? Cheers, Doru On Tue, Oct 9, 2012 at 12:19 PM, laurent laffont <laurent.laffont(a)gmail.com> wrote:

On Tue, Oct 9, 2012 at 9:25 AM, Tudor Girba <tudor(a)tudorgirba.com> wrote:

I guess not. The first step would be to write a parser for the output and build a model out of it. Afterwards we can visualize it. But, where is the graph in this structure?

Cheers, Doru On Tue, Oct 9, 2012 at 9:19 AM, laurent laffont <laurent.laffont(a)gmail.com> wrote:

_______________________________________________ Moose-dev mailing list Moose-dev(a)iam.unibe.ch https://www.iam.unibe.ch/mailman/listinfo/moose-dev

4454

days inactive

4457

days old

moose-dev@list.inf.unibe.ch

Manage subscription

5 comments

3 participants

tags (0)

participants (3)

laurent laffont
Stéphane Ducasse
Tudor Girba